Trying to understand the array data type, I'm running this on the web console:
select table(name array=(('foo','bar'), ('ack','blah'))) First time, the result is: (((foo, bar)), ((ack, blah))) (1 row, 0 ms) Second time the result is: General error: "java.lang.NullPointerException" [50000-171] HY000/50000 (Help) org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-171] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:158) at org.h2.message.DbException.convert(DbException.java:281) at org.h2.message.DbException.toSQLException(DbException.java:254) at org.h2.message.TraceObject.logAndConvert(TraceObject.java:368) at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:276) at org.h2.server.web.WebApp.escapeData(WebApp.java:1684) at org.h2.server.web.WebApp.getResultSet(WebApp.java:1602) at org.h2.server.web.WebApp.getResult(WebApp.java:1329) at org.h2.server.web.WebApp.query(WebApp.java:1002) at org.h2.server.web.WebApp$1.next(WebApp.java:965) at org.h2.server.web.WebApp$1.next(WebApp.java:954) at org.h2.server.web.WebThread.process(WebThread.java:166) at org.h2.server.web.WebThread.run(WebThread.java:93) at java.lang.Thread.run(Thread.java:679) Caused by: java.lang.NullPointerException at org.h2.tools.SimpleResultSet.getColumnCount(SimpleResultSet.java:1777) at org.h2.value.ValueResultSet.getString(ValueResultSet.java:94) at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:274) ... 9 more Using h2-1.3.171.jar -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.