Slick 3.2 applicative join not generating standard SQL join

59 views
Skip to first unread message

marko

unread,
Feb 26, 2017, 4:22:31 PM2/26/17
to Slick / ScalaQuery

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)
} yield (c.name, s.name)
// 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
Reply all
Reply to author
Forward
0 new messages