Hello.
Your command is obliviously invalid. You can't insert a NULL into column
with NOT NULL constraint. You need to use DEFAULT
INSERT INTO test_table(column1, update_time) VALUES ('test', DEFAULT);
or you can simply remove this column from the list of INSERT columns.
INSERT INTO test_table(column1) VALUES ('test');
MySQL historically allows different incorrect commands, but recent versions
of MySQL disallow many of them by default. H2 allowed some incorrect
commands in MySQL compatibility mode too, but some such support was removed
to match default behavior of MySQL better and to remove unnecessary
complications from H2.
It looks like MySQL does not allow NULL for NOT NULL columns any more in
some cases, but still allows it in others. This difference wasn't found
earlier and such support was removed completely from H2 and I don't think
that it will be restored. You need to fix your command instead or continue
to use some outdated version of 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/7e16badb-dbf8-4925-82c9-5561b3684d6e%40googlegroups.com.
