Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread prrvchr
If we want to be able to offer users intelligent software, we must find intelligence where it is found. In this case, you are the one holding it... Le mercredi 10 avril 2024 à 16:06:22 UTC+2, prrvchr a écrit : > > But for you, that would require waiting for a new version to become > available,

Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread prrvchr
> But for you, that would require waiting for a new version to become available, which might take some months. To be honest, the deadline is not very important, what matters is that ultimately we can offer users a tool (LibreOffice Base) that is easy to use for databases. This is necessary if w

Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread Noel Grandin
On Wed, 10 Apr 2024 at 13:01, prrvchr wrote: > > if we _did_ improve it, we would break some downstream libraries (like > JOOQ and Hibernate), who rely on the values we currently return from that > method > > Not if you only change the input handling: support the SYSTEM TABLE and > TABLE types in

Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread prrvchr
> if we _did_ improve it, we would break some downstream libraries (like JOOQ and Hibernate), who rely on the values we currently return from that method Not if you only change the input handling: support the SYSTEM TABLE and TABLE types in addition to TABLE BASE in the type given as input to t

Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread prrvchr
Hi Noel, If this is not appreciated, then I apologize. But I'm not paying either and I'm trying to bring some more functionality to LibreOffice Base for H2. Now if it is forbidden to talk about what is not working and it is preferable to hide behind bogus justifications, I do not think that t

Re: [h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread Noel Grandin
On Wed, 10 Apr 2024 at 11:00, prrvchr wrote: > No definitely, JDBC has nothing to do with it. It is your implementation > which by not differentiating the type of the tables, necessarily, does not > allow any filtering on the tables. Too bad and I don't think it's going > to change any time soon

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread prrvchr
No definitely, JDBC has nothing to do with it. It is your implementation which by not differentiating the type of the tables, necessarily, does not allow any filtering on the tables. Too bad and I don't think it's going to change any time soon since you can't understand such a simple thing...

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-10 Thread Evgenij Ryazanov
H2 returns table types exactly as required by the SQL Standard. JDBC doesn't have any own requirements. -- 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 h2-databa

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-09 Thread prrvchr
Correction: DatabaseMetaData.getTables() method more intelligent... Le mardi 9 avril 2024 à 18:23:06 UTC+2, prrvchr a écrit : > To be more precise, it is not a change in the type of tables that I am > asking for, but the possibility of making the > DatabaseMetaData.getTablesTypes() method more i

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-09 Thread prrvchr
To be more precise, it is not a change in the type of tables that I am asking for, but the possibility of making the DatabaseMetaData.getTablesTypes() method more intelligent in order to be able to filter or not the system tables. That this method recognizes the types TABLE, SYSTEM TABLE and BAS

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-09 Thread prrvchr
Hi Evgenij, All databases use a different type in order to be able to filter system tables, well all those that I manage in Base (HsqlDB, SQLite xerial, Derby, PostgreSQL pgJDBC, Firebird Jaybird). MariaDB connector/J gives system tables only for those located in the information_schema. It see

[h2] Re: H2 does not use SYSTEM TABLE in table types

2024-04-09 Thread Evgenij Ryazanov
Hi! > Why H2 does not use SYSTEM TABLE in the table types returned by the DatabaseMetaData.getTableTypes() method Because there is no such thing as system table in the SQL Standard. JDBC metadata is an entirely unreliable thing, you can't construct anything serious on top of it. There is a di