Went over the code, I see I can add NULL_TO_DEFAULT to the column
definition it works!
On Tuesday, April 14, 2020 at 10:31:17 AM UTC+3, Eyal Segal wrote:
>
> 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/8e594073-1be3-4756-9bbd-2591e79413e4%40googlegroups.com.
