[h2] Re: H2 - Throwing Syntax Error for Create Alias

Here's what happened: 1) You created a database with an older H2 jar and added a user-defined function (UDF) 2) You updated your H2 jar to a newer version that has a built-in function that has the same name as your user-defined function 3) Now H2 gets a bit confused at start up because it tries

[h2] Re: H2 - Throwing Syntax Error for Create Alias

Hi, What exactly is going on with this? We were using an older version of H2. We had a table that stored a day, month and year in separate fields and had a query like this to turn the three fields into a Java date... SELECT TO_DATE(day || '-' || month || '-' || year, 'dd-MM-') FROM

[h2] Re: H2 - Throwing Syntax Error for Create Alias

Hi *FYI;* I've contributed the TO_DATE (and TO_TIMESTAMP) code to H2 and it should be in Version 1.4.191 (It's not mentioned in the change log :-( ). *Note*: If you have programed an alias with that name, you need to delete that