subject:"\[h2\] SELECT \* FROM \(SELECT \? FROM DUAL\) fails"

Re: [h2] SELECT * FROM (SELECT ? FROM DUAL) fails

2016-11-28 Thread Thomas Mueller Graf

Hi, You could use "cast": SELECT * FROM (SELECT CAST(? AS VARCHAR) FROM DUAL) On Thursday, November 17, 2016, Boris Granveaud wrote: > Hello, > > I have a problem with the following statement: > > SELECT * FROM (SELECT ? FROM DUAL) > > it gives this error with H2 1.4.191:

[h2] SELECT * FROM (SELECT ? FROM DUAL) fails

2016-11-17 Thread Boris Granveaud

Hello, I have a problem with the following statement: SELECT * FROM (SELECT ? FROM DUAL) it gives this error with H2 1.4.191: org.h2.jdbc.JdbcSQLException: Unknown data type: """?1"""; SQL statement: SELECT * FROM (SELECT ? FROM DUAL) [50004-192] at