Am Donnerstag, 14. Juni 2012 14:59:10 UTC+2 schrieb Lukas Eder: I wasn't aware of such a Sybase (ASE or SQL Anywhere?) limitation. Can you > provide a documentation link explaining this? What would need to be adapted > by jOOQ? >
I couldn't find it in the docs; try to create an IN with more than 384 (old Sybase) or 1024 (since Sybase 12.5) elements in the IN() clause. The reason is that Sybase internally transforms "x IN()" into "x = value1 OR x = value2 OR ..." and Sybase only allows 384/1024 local operators in a single SELECT. PS: Greetings from Danilo Tommasina :-) We'll see you on July, 3rd in Zurich! Regards, A. Digulla
