Slick 3.2 documentation states that SQL standard join syntax will be generated for applicative joins as follows:
val innerJoin = for {
(c, s) <- coffees join suppliers on (_.supID === _.id)
// compiles to SQL (simplified):
// select x2."COF_NAME", x3."SUP_NAME" from "COFFEES" x2
// inner join "SUPPLIERS" x3
// on x2."SUP_ID" = x3."SUP_ID"
However, during execution Slick outputs the following lines:
2017-02-26 23:08:02.464 - #1: result [select x2."COF_NAME", x3."SUP_NAME" from "COFFEES" x2, "SUPPLIERS" x3 where x2."SUP_ID" = x3."SUP_ID"]
2017-02-26 23:08:03.240 - Preparing statement: select x2."COF_NAME", x3."SUP_NAME" from "COFFEES" x2, "SUPPLIERS" x3 where x2."SUP_ID" = x3."SUP_ID"
So, the documentation and implementation don't seem to be in sync.
Is this a bug?
Is the syntax database profile specific?
marko