Re: [h2] Wrong meta data returned by ARRAY_GET

2015-01-30 Thread christoff . schmitz
/ 254 98 - 50 eMail:mailto:christoff.schm...@finaris.de www: http://www.finaris.de und http://www.rapidrep.com From: FredDaniPandoraAquiles zepf...@gmail.com To: h2-database@googlegroups.com h2-database@googlegroups.com Date: 2015-01-30 16:09 Subject:Re: [h2] Wrong meta

Re: [h2] Wrong meta data returned by ARRAY_GET

2015-01-30 Thread FredDaniPandoraAquiles
Hi, According to the documentation, the method ARRAY_GET returns one element of an array as a string, so I think the meta information is correct. See the documentation: http://www.h2database.com/html/functions.html#array_get. Regards, Fred 2015-01-30 10:57 GMT-02:00

[h2] Wrong meta data returned by ARRAY_GET

2015-01-30 Thread christoff . schmitz
Hi, When executing the following 2 statements, the ResultSetMetaData is wrong for the column with the ARRAY_GET expression. SET @a = ((1, 2), (2, 4)) / SELECT @a, ARRAY_GET(@a, 1) The metadata says that that column is of type VARCHAR, while ARRAY should be correct (getObject() invoked on that