[MDEV-20118] Bulk Insert (Column-wise Binding) doesn't insert all required rows Created: 2019-07-22  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Triggers
Affects Version/s: 10.2.24, 10.4.6
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Feral Diana Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None
Environment:

centos 7.5 + db 10.2.24, ubuntu 18.04 + db 10.4.6


Attachments: File 1.sql     File db_main.cc    

 Description   

I try to insert 3 rows into "warning" table.
This table has trigger "after insert" that can insert 1 row into "unit_fault" table.

For example, after the second "warning" row trigger inserts 1 row into "unit_fault" table. it causes that the third "warning" row will not be inserted.

Triggered insert seems to break main insert without any errors.


Generated at Thu Feb 08 08:56:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.