[h2] Re: Can aliases made by CREATE ALIAS , be retrieved by SQL?

2024-05-02 Thread Evgenij Ryazanov
Hello! In H2 2.* you can read them from standard INFORMATION_SCHEMA.ROUTINES and INFORMATION_SCHEMA.PARAMETERS views. In historic versions of H2 you need non-standard INFORMATION_SCHEMA.FUNCTION_ALIASES and INFORMATION_SCHEMA.FUNCTION_COLUMNS tables. -- You received this message because you

[h2] Can aliases made by CREATE ALIAS , be retrieved by SQL?

2024-05-02 Thread Rinse Lemstra
Can aliases made by CREATE ALIAS , be retrieved by SQL? could not find any documentation about this also seached the system tables without any result. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

[h2] Linked table issues (autocommit, prepared statement) ,modifications and licensing

2024-05-02 Thread Marat Akselrod
Hello, I'd like to use H2 linked table function to data migration in way insert into "linked target" as select from "linked source". It will be very helpfull for our customers. Technically it works , but I found some problems/issues(or maybe my misaunderstanidg) 1) Autocommit . Setting autocommit