I think by using field("' '"), you're explicitly telling jOOQ to treat it
as a string literal containing a space, which translates correctly into
SQL. This is not what you asked by have u tried DSL.inline(" ")
instead of field("
")?Den sön 27 okt. 2024 kl 16:31 skrev Simon Martinelli < [email protected]>: > Hi, > > If I do this: > > concat(ATHLETE.club().ABBREVIATION, field(" "), ATHLETE.club().NAME) > > I get > > (("alias_128651403"."abbreviation" || cast( as varchar)) || > "alias_128651403"."name") > > Which results in > org.springframework.jdbc.BadSqlGrammarException: jOOQ; bad SQL grammar > [select "public"."athlete"."id", "public"."athlete"."first_name", > "public"."athlete"."last_name", (("alias_128651403"."abbreviation" || cast( > as varchar)) || "alias_128651403"."name") from ("public"."athlete" left > outer join "public"."club" as "alias_128651403" on > "public"."athlete"."club_id" = "alias_128651403"."id") order by > "public"."athlete"."first_name", "public"."athlete"."last_name" offset ? > rows fetch next ? rows only] > at org.jooq_3.19.13.POSTGRES.debug(Unknown Source) ~[na:na] > > To make it work I have to use > > concat(ATHLETE.club().ABBREVIATION, field("' '"), ATHLETE.club().NAME) > > Why? > > Thanks, Simon > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/5c8aa7ca-75cc-4230-a6b1-8fc526343dc4n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/5c8aa7ca-75cc-4230-a6b1-8fc526343dc4n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAJyM8pDvALfMxS8uxX15MC2ZNJkbRbTXpq7Wr%2BWO2p1Oaofbzw%40mail.gmail.com.
