> > ...and in trying to code around this I've now found another bug. I tried > re-writing my code to directly generate the TABLE() clause as per the H2 > re-write, but it seems table doesn't generate array columns properly... >
SELECT * FROM TABLE( C1 ARRAY = (null)); C1 <http://192.168.1.22:8082/query.do?jsessionid=2e065613ab741bfe4b41b19009b671e1#>(no rows, 16 ms) SELECT * FROM TABLE( C1 ARRAY = ((1))); C1 <http://192.168.1.22:8082/query.do?jsessionid=2e065613ab741bfe4b41b19009b671e1#> (1)(1 row, 1 ms) SELECT * FROM TABLE( C1 ARRAY = ((1,2))); C1 <http://192.168.1.22:8082/query.do?jsessionid=2e065613ab741bfe4b41b19009b671e1#> (1)(2) (2 rows, 1 ms) In the third case I want a single row with an array containing (1,2) Cheers, Ian. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
