Hi, I'm not able to test this now, but I think you inverted the parameters of the convert function:
CONVERT ( value <http://www.h2database.com/html/grammar.html#value> , dataType <http://www.h2database.com/html/grammar.html#data_type> ) Regards, Fred Em 10/04/2015 13:14, <[email protected]> escreveu: > Hi, > > I'm using h2-1.4.186 in a java program. I'm using > Mode.getInstance("MSSQLServer").swapConvertFunctionParameters = true to > swap parameters of the convert function (to use CONVERT(dataType, value). > When I want to execute the following query > >> SELECT CONVERT(CHAR(5), test) >> FROM (SELECT CONVERT(CHAR(5),'test') AS test) > > I have this message > >> SELECT CONVERT(CHAR(5), test) >> FROM (SELECT CONVERT(CHAR(5),'test') AS test) : Unknown data type: "'"; >> SQL statement: >> SELECT >> CONVERT('test',CHAR(5)) AS TEST >> FROM SYSTEM_RANGE(1, 1) [50004-186] > > > That happens when I do a SELECT CONVERT into a FROM > Why the parameters of the second CONVERT are swaped during the execution ? > How can I fix ? > > Thanks > > -- > 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. > -- 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.
