Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11.11
Description
Inserting multiple rows into a table from another table fails, when the targeted table has also an update before trigger on another column.
See following examples where one_row_query inserts one value and works perfectly fine, two_rows_query tries to insert two values and fails with "SQL Error (1048): Column 'Id' cannot be null" and two_values_query inserts the same two values but provided within the query and succeeds.
The only workaround I found was to delete and readd the trigger like I did in workaround_query.
This only happens since 10.11.11 in 10.11.10 the two_rows_query works fine.
Attachments
Issue Links
- duplicates
-
MDEV-36026 Problem with INSERT SELECT on NOT NULL columns while having BEFORE UPDATE trigger
-
- Closed
-