Hello,
Hi now I am experimenting with JOOQ.
Can SQL generator of JOOQ gets string like SELECT *, but not SELECT COL1,
COL2, COL3.....
Because It increases string length enormously.
Example
JOOQ Experession:
create.select().from(create.selectOne().from((create.select(DSL.fieldByName("MyTableColumn").as("Alias")).from(DSL.tableByName("MyTable")).asTable()))).getSQL();
Query Generated: select "alias_111354813"."Alias" from (select
"alias_94194960"."Alias" from (select "MyTableColumn" "Alias" from
"MyTable") "alias_94194960") "alias_111354813"
Expected one: select * from (select * from (select "MyTableColumn" "Alias"
from "MyTable") "alias_94194960") "alias_111354813"
This is better because, If we have a table of 100 columns string length is
huge!
I checked selectFrom(), It won't work
Do you know any way
Thank you
--
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].
For more options, visit https://groups.google.com/groups/opt_out.
