Details
Description
Máme dvě tabulky, prázdnou hlavní, s (prázdným before upfdate triggerem) a dvouřádkovou nepráznou (not null) dočasnou.
Database contains two tables,
main is empty, with (empty, but same trouble comes with any content) before update trigger.
temp has two non-empty rows.
Fail:
INSERT into MIxQIbind_bck (M_ID,Q_ID) select M_ID,Q_ID from `MIxQItemp`;
pokud odejmeme trigger, vše funguje, a zadání jednoho řádku také.
if limit 1 used., all is OK, if no trigger, all OK too.
Attachments
Issue Links
- duplicates
-
MDEV-36026 Problem with INSERT SELECT on NOT NULL columns while having BEFORE UPDATE trigger
-
- Closed
-
- is caused by
-
MDEV-19761 Before Trigger not processed for Not Null Columns if no explicit value and no DEFAULT
-
- Closed
-