rved word in the SQL Standard and H2, it cannot be used as
> unquoted identifier.
>
> https://h2database.com/html/advanced.html#keywords
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop re
The "[*]" indicates where the problem lies in the statement.
"value" is a reserved identifier. so you will either need to change that
column name, or surround it with quotes
--
You received this message because you are subscribed to the Google Groups "H2
Database&qu
Hi!
VALUE is a reserved word in the SQL Standard and H2, it cannot be used as
unquoted identifier.
https://h2database.com/html/advanced.html#keywords
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this grou
Utilizing H2 for my project's JUnit tests, I am currently seeing an
exception thrown in a number of tests run by Maven, but not when run in
Eclipse as a JUnit test.
Exception is:
[INFO] Running
ca.joyes.sportssjef.service.scheduled.SendApprovalRequestNotificationServiceTest
22:13:51.052 [main
I am currently using H2 as the database engine when running unit tests for
my project. For a number of my tests it has started failing when the tests
are run as part of my deployment packaging step (Maven), however the same
tests will pass when run in Eclipse as a JUnit Test.
Stack trace from
That cte is a cool idea! In the end, I wrote my own function to get the tags.
Thanks for everyone's input.
Best,Peter
--
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, sen
tml/commands.html#create_aggregate
--
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
));
Is the same as this:
select tags from company;
--
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
Something like this:
SELECT Array_Agg( a )
FROM ( SELECT ARRAY [ 1, 2, 3] a
UNION
SELECT ARRAY [ 2, 3, 4] a )
;
Unfortunately, H2 does not seem to support any Flatten or Concat-
Aggregate function for arrays.
And UNNEST() is not deep.
So I am indeed not sure if this can
, 'Peter Borissow' via H2 Database
wrote:
> Hello,
> I have a simple query in PostgreSQL that I am trying to emulate
> in H2:
> SELECT DISTINCT(unnest(tags)) as tags FROM company;
>
> The "tags" column is a varchar array. The query returns a unique list
>
Hello, I have a simple query in PostgreSQL that I am trying to emulate in
H2:SELECT DISTINCT(unnest(tags)) as tags FROM company;
The "tags" column is a varchar array. The query returns a unique list of tags
from the "tags" column.
When I try to run the same query
Hi Mahima,
You did not even mention, if you are usin in-memory or persistent database,
your connection URL should be the first thing to post. Database version
would be helpful too.
If you suspect memory leak - H2 is just another java library, so follow
standard best practices to detect JVM
, usually there are
> separate methods or parameters for user name and password.
>
> H2's own org.h2.jdbcx.JdbcDataSource can log JDBC URLs and user names,
> but it doesn't log passwords specified with setPassword() method.
>
> JdbcConnectionSource is not a part of H2, so you should read its
&
Hi!
Passwords shouldn't be specified in the JDBC URL, usually there are
separate methods or parameters for user name and password.
H2's own org.h2.jdbcx.JdbcDataSource can log JDBC URLs and user names, but
it doesn't log passwords specified with setPassword() method.
JdbcConnectionSource
,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
--
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 em
Thank you so much, H2 team!
We have done our part and integrated it into the H2 Migration Tool
already: https://manticore-projects.com/H2MigrationTool/index.html
All the best
Andreas
On Sun, 2024-07-14 at 18:57 -0400, Andrei Tokar wrote:
> Hello,
>
> A new version 2.3.230 of H2 is
Hello,
A new version 2.3.230 of H2 is available at http://www.h2database.com
(you may have to click 'Refresh') and
https://github.com/h2database/h2database/releases/tag/version-2.3.230
For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html
New artefacts
Hi all, we are using the default H2 database that came with the open source
WSO2 Enterprise Service Bus (ESB) application. Our H2 DB is setup in
embedded mode as follows:
xml
WSO2_CARBON_DB
The datasource used for registry and user
manager
jdbc/WSO2CarbonDB
:8080/h2-console.
when I debug and step through h2 code, I realized it defined a username and
password using the above environment variables instead of sa
Is this expected behavior or bug?
thanks
Manas
--
You received this message because you are subscribed to the Google Groups "H2
Dat
ct...args) {
System.out.println(m.formatted(args));
}
private static void printMapVersion(MVMap map,long version) {
MVMap mapv=map.openVersion(version);
println("m1.v%d=%d %d",version,mapv.getVersion(),mapv.get("a"));
}
}
--
You recei
ges, but the metadata IS stored.
>>
>> Is this intended behavior?
>>
>> Thanks!
>>
>> Chris
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop rece
to have
> unsaved changes, but the metadata IS stored.
>
> Is this intended behavior?
>
> Thanks!
>
> Chris
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving email
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-da
We recently started using "CREATE MEMORY LOCAL TEMPORARY TABLE IF NOT
>> EXISTS" more frequently. Could this be related to the problem?
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this gr
paypal.me/yusufwelding
--
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 vi
his 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/dbd67b4e-e095-4548-bed3-55122e4feb9en%40googlegroups.com.
ecause 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/4d8
Hi,
The last release is from Sept 2023?
I have seen there are some patches since than. Does anyone know when a new
versie will be released?
Thanks,
Olaf
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this grou
string contains comma-separated properties in the
> name:value format. You can check value of the property format.
>
> 1 was used by old historic H2 1.4 or H2 1.3. There is no reliable and easy
> way to determine a database version from their files. There is a CREATE
> BUILD 196 or
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 u
by old historic H2 1.4 or H2 1.3. There is no reliable and easy
way to determine a database version from their files. There is a CREATE
BUILD 196 or something like it in the file, 196 means H2 1.4.196.
2 was used by H2 2.0/2.1. Because H2 2.1.214 can read all these files, you
can safely pass 214
Hi,
I am upgrading my app that uses H2 as the database. Some people using it
will not move to version 2 of my app and may go straight to version 3.
Since I am changing the H2 version with each release of my app, when I
connect to an old version of the database, I get the 90048 error
the h2.sql dump to recover the database.
Does anyone has got know when a new release will be released, so we can use
this patch? The last release is from Sept 2023?
Thanks for you reply in advance!
Olaf
Op maandag 13 mei 2024 om 11:51:07 UTC+2 schreef Olaf van der Meer:
> Hi,
>
> I
run further and the recover produces an h2.sql dump.
Is this a good fix for this issue?
I was also wondering where wondering where the mv.txt dump file is used
for.
I only need the h2.sql dump to recover the database.
--
You received this message because you are subscribed to the Google Groups
On 5/8/2024 6:31 PM, Bruce Visscher wrote:
On stack overflow, Thomas Mueller
<https://stackoverflow.com/users/382763/thomas-muelle> wrote:
The Oracle lock table statement doesn't work in H2. The suggested select...for update
<https://stackoverflow.com/a/71210443/3604905>
On stack overflow, Thomas Mueller
<https://stackoverflow.com/users/382763/thomas-muelle> wrote:
> I'm one of the authors of H2. If something doesn't work, please post it
on the H2 mailing list.
Is this the H2 mailing list?
The Oracle lock table statement doesn't work in H2. The
On 5/1/2024 10:10 PM, Marat Akselrod wrote:
And if it can take a long, I want to understand if I'm allowed(by license) to provide to my customers my modified
version meanwhile ?
Yes you are
--
You received this message because you are subscribed to the Google Groups "H2
Dat
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
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
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
l have the same size ~ 20k.
>
> These mv.db files cause an exception while making a backup.
>
> What are these files?
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop recei
the same.
>
> * Place DB on PC1 and access from PC2
> >>Error. Possible solutions: close all other connection(s); use the
> server mode [90020-224]
>
> * Place DB on PC2 and access from PC1
> >> success.
> 2024年4月27日土曜日 21:18:46 UTC+9 neive:
>
>> Hi
on PC2 and access from PC1
>> success.
2024年4月27日土曜日 21:18:46 UTC+9 neive:
> Hi Team,
>
> I tried upgrading h2-1.4.196 to h2-2.2.224 to verify.
> Is connecting with Automatic Mixed Mode(AUTO_SERVER=TRUE) from different
> PCs no longer supported?
>
> * Automatic Mixed Mode
&g
Hi Team,
I tried upgrading h2-1.4.196 to h2-2.2.224 to verify.
Is connecting with Automatic Mixed Mode(AUTO_SERVER=TRUE) from different
PCs no longer supported?
* Automatic Mixed Mode
https://www.h2database.com/html/features.html?highlight=AUTO_SERVER=AUTO_SERVER%20#auto_mixed_mode
* Could
Just moved to mvstore. After conversion in some directories there is a
*.mv.db file, all have the same size ~ 20k.
These mv.db files cause an exception while making a backup.
What are these files?
--
You received this message because you are subscribed to the Google Groups "H2
Dat
It's done, it's called H2dbOOo <https://prrvchr.github.io/H2dbOOo/> and
there are two versions:
- 1.0.0 for LibreOffice up to 7.x
- 1.1.0 for LibreOffice 24.2.x or higher
You can create H2 databases only with the mouse (say goodbye to your
keyboard...)
If you fill a table, you kill Libre
Understood. 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 vi
too
many unknown variables. You can't rely on them.
--
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 th
don't think we should be
seeing "duplicates" like I reported - esp when there's a unique primary key.
But I'll let you guys have the last word on that.
Best,Peter
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubsc
On Tue, 2024-04-16 at 09:54 +, 'Peter Borissow' via H2 Database
wrote:
> Hmm... I kinda have a row id already via the unique primary key. What
> advantage would a temp table give in my case?
The advantage is, that special column _rowid_ is the physical row of
the data frame and it
Hmm... I kinda have a row id already via the unique primary key. What advantage
would a temp table give in my case?
--
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, sen
In my understanding, you could create a temporary table from your query
(without pagination) and then use the special column `_row_id_` for the
pagination.
On Tue, 2024-04-16 at 16:42 +0700, Andreas Reichel wrote:
> On Tue, 2024-04-16 at 09:14 +, 'Peter Borissow' via H2 Database
>
break point looking at just 2 records at a time looks like this:
Does having a unique primary key make any difference? Or should it?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving e
On Tuesday 16 April 2024 at 17:18:41 UTC+8 Evgenij Ryazanov wrote:
These rows are called *pears* in the SQL Standard.
I meant *peers*, of course.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this grou
On Tue, 2024-04-16 at 09:14 +, 'Peter Borissow' via H2 Database
wrote:
> I don't care if 218 appears before 217 or if 217 appears before 218
> as long as they both appear.
Peter,
please consider that
1) the second query call knows nothing about the first query call ( and
this fact
| 2
2 | 4
2 | 3
(3 rows)
Row (1, 3) is missing.
Results in H2 are slightly different:
# select * from test order by a offset 0 rows fetch first 3 rows only;
A | B
-- | -
-1 | 4
0 | 4
1 | 3
(3 rows)
# select * from test order by a offset 3 rows fetch first 3 rows only;
A | B
- | -
1 | 3
2
;duplicate" 218 at the break point, with no 217 like this:
That's point #1.
Point #2 regarding consistency is that if I run the same query over and over I
get 4 different results. Bear in mind that the table and data is 100% static.
--
You received this message because you are subscribed to t
queries don't order anything but
imply grab any 50 records first.
Cheers
--
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...@google
On 4/16/2024 10:19 AM, 'Peter Borissow' via H2 Database wrote:
(2) The query response is inconsistent. I see 4 different responses coming back from the same query on a static table. I
don't think that's right.
SQL databases implement the relational model. The relational model works
ully,Peter
--
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.g
Hi all,
I am working on an extension allowing access to H2 in LibreOffice in
embedded mode.
This allows you to have your H2 database, these Base Queries and Forms in a
single odb file.
In order to be able to manage the privileges I provide at the connection
during the creation of the H2
arlier but I don't see this behavior
> in PostgreSQL. Not sure how other RDBMS behave but it would be interesting
> to compare.
>
> Peter
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this gr
to
compare.
Peter
--
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 vi
, it can process all of them and run next query with OFFSET 151 ROWS
FETCH NEXT 50 ROWS WITH TIES.
--
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 h
can replicate.
Thanks in advance,
Peter
My environment:
Java 21.0.1
Windows 11
H2 2.2.224 (PostgreSQL mode)
--
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 em
rights inherited
from roles.
Please notify me of any malfunction.
--
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...@googlegro
ligent and communicative functionalities.
>
> > Why is it hard to use the workaround? ie. doing
>
> I already have specific code for H2 because of the type of table named
> TABLE BASE. If you use H2 in LibreOffice Base with the native JDBC driver
> you will only see the views, t
ary if we want to be able to offer intelligent
and communicative functionalities.
> Why is it hard to use the workaround? ie. doing
I already have specific code for H2 because of the type of table named
TABLE BASE. If you use H2 in LibreOffice Base with the native JDBC driver
you will on
essage 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/CAFYHVnU
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 this is
> of much interest.
>
> Sometimes it is better to say:
> - Yes this is a
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
n from
that method.
We would also likely break the code of various people who use H2.
--
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+
...
Le mercredi 10 avril 2024 à 09:37:59 UTC+2, Evgenij Ryazanov a écrit :
> 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" gr
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 em
Firebird Jaybird).
>> MariaDB connector/J gives system tables only for those located in the
>> information_schema.
>>
>> It seems to me that if this is used by so many databases it is because it
>> is the simplest solution to provide such functionality.
>>
>>
> is the simplest solution to provide such functionality.
>
> I already have specific code for H2 which returns TABLE BASE instead of
> TABLE and I had to set up mock ResultSet on the
> DatabaseMetaData.getTypeInfos() and DatabaseMetaData.getTablePrivileges()
> methods for
.
It seems to me that if this is used by so many databases it is because it
is the simplest solution to provide such functionality.
I already have specific code for H2 which returns TABLE BASE instead of
TABLE and I had to set up mock ResultSet on the
DatabaseMetaData.getTypeInfos
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
Hi,
Thank you for this information, it allowed me to integrate the management
of roles and rights into Base for H2. I give you the queries that I use,
this may possibly benefit other people.
Get a user's roles:
SELECT GRANTEDROLE FROM INFORMATION_SCHEMA.RIGHTS WHERE GRANTEETYPE =
'USER
Hi all,
It's just a question. Why H2 does not use SYSTEM TABLE in the table types
returned by the DatabaseMetaData.getTableTypes() method.
How to filter tables found in system schemas (ie: INFORMATION_SCHEMA) using
the getTableType() method?
Thank you for your suggestions.
--
You received
offering psql and h2 options in my software, as well as using h2
> in my tests. But I'm having an issue when trying to store json data.
> H2 requires "FORMAT JSON" in the value for json but this syntax isn't
> allowed in PSQL. I'm trying to use the same queries between both
>
hi!
I'm offering psql and h2 options in my software, as well as using h2 in my
tests. But I'm having an issue when trying to store json data. H2 requires
"FORMAT JSON" in the value for json but this syntax isn't allowed in PSQL.
I'm trying to use the same queries between both whic
Run the EXPLAIN command to see which indexes are used for a specific query
--
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-databas
e the cost and only one is finally
used to access the data.
Hope this helps.
Rinse Lemstra schrieb am Fr., 5. Apr. 2024, 18:50:
>
> from the H2 website:
>
> If a table has multiple indexes, *sometimes more than one index could be
> used.* Example: if there is a table
,
…) columns for optimal performance.
H2 doesn't have a bitmap index scan optimization, so if you have only
separate indexes, only one index will be used. Some database systems can
use two indexes on the same time in such queries, but even in them a
two-column index should be significantly faster than
from the H2 website:
If a table has multiple indexes, *sometimes more than one index could be
used.* Example: if there is a table TEST(ID, NAME, FIRSTNAME) and an index
on each column, then two indexes could be used for the query SELECT * FROM
TEST WHERE NAME='A' AND FIRSTNAME='B', the index
Hello,
I'm a university student and i have to contribute to an oss as an
assignment for a course of "Software engineering". I chose h2 but i would
appreciate some help. I'm a beginner so i'm looking for an issue that is
not very complicated to solve or an enhancement to
Hello!
Make sure you have only one version of H2 in classpath of your application.
If you have a standalone H2 Server process, check its classpath instead. If
you use auto-server mode, check classpaths of all involved applications.
--
You received this message because you are subscribed
Seeing this NoClassDefFoundError, looks like it's from the Server side.
Anyone has an idea? H2 version 2.2.224
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: General error:
"java.lang.NoClassDefFoundError:
org/h2/command/dml/SetClauseList" [5-224]
:
> When you use Statement.RETURN_GENERATED_KEYS, driver may choose what it
> should return by itself, see JDBC™ 4.3 Specification, section 13.6. Modern
> versions of H2 return primary key columns, identity columns, and columns
> with non-constant default expression (including expressions in
transitive permissions
from these roles.
--
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
INFORMATION_SCHEMA.ROLE_AUTHORIZATION_DESCRIPTORS WHERE GRANTEE=? AND
ROLE_NAME!=GRANTEE
But I couldn't find anything for H2, thanks for your help...
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiv
When you use Statement.RETURN_GENERATED_KEYS, driver may choose what it
should return by itself, see JDBC™ 4.3 Specification, section 13.6. Modern
versions of H2 return primary key columns, identity columns, and columns
with non-constant default expression (including expressions inherited from
>
>>
>> Thanks,
>> Balamurali
>>
>> On Fri, Mar 29, 2024 at 3:55 PM Balamurali Krishna Ippili <
>> balamurali.ipp...@broadcom.com> wrote:
>>
>>> Hi Evgenij,
>>>
>>> Thanks for your quick reply and suggestion. Really appreciate
gt;
>> Thanks,
>> Balamurali
>>
>> On Fri, Mar 29, 2024 at 3:06 PM Evgenij Ryazanov
>> wrote:
>>
>>> Hi!
>>>
>>> You shouldn't try to insert NULL into columns with NOT NULL constrains.
>>> Only non-null values or DEFAULT may be
umns with NOT NULL constrains.
>> Only non-null values or DEFAULT may be inserted into them.
>>
>> H2 allows such incorrect insertions into identity columns only in Legacy,
>> HSLQDB, MariaDB, and MySQL compatibility modes.
>>
>> You can also enable this feature for
nly non-null values or DEFAULT may be inserted into them.
>
> H2 allows such incorrect insertions into identity columns only in Legacy,
> HSLQDB, MariaDB, and MySQL compatibility modes.
>
> You can also enable this feature for any column in any compatibility mode
> with ALTE
Hi!
You shouldn't try to insert NULL into columns with NOT NULL constrains.
Only non-null values or DEFAULT may be inserted into them.
H2 allows such incorrect insertions into identity columns only in Legacy,
HSLQDB, MariaDB, and MySQL compatibility modes.
You can also enable this feature
tion, forwarding, printing, or copying of
this e-mail is strictly prohibited. If you received this e-mail in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
--
You received this message because you are subscribed to the Google Groups &quo
l in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
--
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 e
1 - 100 of 12345 matches
Mail list logo