Thank you for your response, disappointing a bit, as I would expect it to
have at least a feature that allows that, for compatibility with MySql.
On Tuesday, April 14, 2020 at 7:13:43 AM UTC+3, Evgenij Ryazanov wrote:
>
> 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/99031e27-dfa8-4302-a197-b9249f0cf280%40googlegroups.com.
