Hi Mohan, Well, that's a good question :) We don't officially support Snowflake, so it may well be that this particular feature cannot be properly emulated. You could use a dialect like Oracle for this particular query, but then other queries might stop working...
I suggest you don't use the VALUES() clause, but manually write your own SELECT .. UNION ALL SELECT .. UNION ALL SELECT .. derived table. I hope this helps, Lukas 2017-11-28 14:39 GMT+01:00 Mohan <[email protected]>: > Hi, > > Thanks for the reply. My target database is Snowflake. So which dialect I > should use. Also I am using jooq as sql query generator. > > -- > 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/d/optout. > -- 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/d/optout.
