Thank you fro you answer.
I think it good if we provide this function, (explicit asterisk) in future
release.
I am very new to open source community, I want to start contributing. I
want to join JOOQ, can you please guide me.
Thank you.
On Friday, September 27, 2013 8:23:27 PM UTC+8, Lukas Eder wrote:
>
> Hello,
>
> The only way to make jOOQ generate an asterisk with an empty select() is
> when there is at least one "unknown" table reference in the from() / join()
> clauses. So, as a workaround, you could force jOOQ to generate this
> asterisk as such:
>
> create.select().from(... your table reference ...).crossJoin("(select 1 as
> dummy from dual) as dummy");
>
>
> Now, this is of course not a very nice solution. Another idea might be to
> pass a custom alias to the asTable() method. A short one, such as
>
> asTable("t")
>
>
> That wouldn't remove the 100 column references, but at least reduce the
> length of the string.
>
> Lukas
>
> 2013/9/27 g savan <[email protected] <javascript:>>
>
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
--
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.
