[h2] Re: UNSIGNED and array problem in H2 query
Thanks for responding , I am migration my code from H2 1.3.176 to H2 2.1.214 These are the queries that are already being used in the original code . But now as I have upgraded the version of H2 it started to throw this exception . Thanks you. On Monday, 18 July 2022 at 14:06:55 UTC+5:30 Evgenij Ryazanov wrote: > Hello. > > Where did you find that syntax? There are no unsigned numeric data types > in the SQL Standard and in the most of database systems including the H2. > This is a feature of MySQL. H2 silently accepts UNSIGNED only in MySQL and > MariaDB compatibility modes, but this declaration is ignored by H2 anyway. > https://h2database.com/html/features.html#compatibility > Also the real MySQL doesn't have the ARRAY data type, so if you use H2 as > an replacement of MySQL for unit tests, you shouldn't try to use it. > > If you use H2 as a primary database, you can use standard-compliant ARRAY > data type safely: > https://h2database.com/html/datatypes.html#array_type > You cannot declare your column as UNSIGNED, but you can add a check > constraint to it if you wish. > -- 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-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/eb41da36-3e47-483d-8a7a-899d72a3aec3n%40googlegroups.com.
Re: [h2] Question about recover tool
On 2022/07/15 2:35 pm, Silvio wrote: Can the recover tool be manipulated to open a database in some form of "safe mode"? Or is there any other way to read a database file with the sole purpose of dumping the content of its tables? Not at the moment. The recover tool passes down a flag to make certain parts of the lower level code more tolerant of problems. Certainly that could be extended to cover more situations. Patches are welcome :-) -- 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-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/a98b1346-1a5d-82d9-692f-4cdc78c73822%40gmail.com.
[h2] Re: UNSIGNED and array problem in H2 query
Hello. Where did you find that syntax? There are no unsigned numeric data types in the SQL Standard and in the most of database systems including the H2. This is a feature of MySQL. H2 silently accepts UNSIGNED only in MySQL and MariaDB compatibility modes, but this declaration is ignored by H2 anyway. https://h2database.com/html/features.html#compatibility Also the real MySQL doesn't have the ARRAY data type, so if you use H2 as an replacement of MySQL for unit tests, you shouldn't try to use it. If you use H2 as a primary database, you can use standard-compliant ARRAY data type safely: https://h2database.com/html/datatypes.html#array_type You cannot declare your column as UNSIGNED, but you can add a check constraint to it if you wish. -- 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-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/73bf3449-81ac-415e-b749-7ffdef344489n%40googlegroups.com.
[h2] UNSIGNED and array problem in H2 query
Hello I have these key words in the query Actual : CREATE TABLE STUDENT(S_PK varchar PRIMARY KEY, S_id BIGINT UNSIGNED NOT NULL UNIQUE) But when exception is thrown it shows the Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE STUDENT(S_PK varchar PRIMARY KEY, S_id BIGINT [*]UNSIGNED NOT NULL UNIQUE)" It happens with USER and Array as well For USER I have added "NON_KEYWORDS=USER" to the jdbc connection string and it solves the problem but what should I do for UNSIGNED and Array 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/7210e8d9-94e8-494c-8bd9-0f8494ebc728n%40googlegroups.com.