[h2] Re: Problems with TO_CHAR function (invalid format and non evaluation in SELECT statement)

2016-02-10 Thread Sam Blume
> > 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 changelog - yet). > *Note*: If you have programed an alias with that name, you need to delete > that alias first or H2 will complain of having a name clash. > Am

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

2016-02-10 Thread Sam Blume
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

[h2] Re: Alias for Existing functions

2016-02-10 Thread Sam Blume
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

[h2] TO_DATE and TO_TIMESTAMP are in version 1.4.191 but not mentioned in the change log

2016-02-10 Thread Sam Blume
Hi I've contributed the TO_DATE (and TO_TIMESTAMP) code to H2 and it should be in Version 1.4.191 . But it's not mentioned in the change log. AND it can be removed from the road map as well. Please also add following note (or

Re: [h2] Compatibility with Oracle

2016-02-10 Thread Sam Blume
Hi Victor *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

[h2] Re: H2 User Defined Functions

2016-02-10 Thread Sam Blume
Hi Alex *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

[h2] Re: Starting/stopping H2 with ant?

2016-02-10 Thread Sam Blume
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

[h2] ALTER TABLE "table-name" MODIFY "columne" NOT NULL; fail with Unknown data type: "NOT";

2017-08-29 Thread Sam Blume
Version: h2-1.4.196 ALTER TABLE "table-name" MODIFY "columne-name" NOT NULL; fails with Unknown data type: "NOT"; - - - I kowticed that h2 started to support the "ALTER TABLE - MODIFY"-SQL syntax (used in Oracle) since ca. Version: h2-1.4.19x. In the older version h2-1.4.192 it failed when

[h2] Re: ALTER TABLE "table-name" MODIFY "columne" NOT NULL; fail with Unknown data type: "NOT";

2017-08-29 Thread Sam Blume
e30a976dea49f8821b055c3b1b6#> A NULL(0) NO *null* NULL B VARCHAR(50) NO *null* NULL Am Dienstag, 29. August 2017 14:21:23 UTC+2 schrieb Sam Blume: > > Version: h2-1.4.196 > > ALTER TABLE "table-name" MODIFY "columne-name" NOT NULL; fails with > Unknown da