Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Trigger not fired under bulk insert #4045

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Trigger not fired under bulk insert #4045

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2016-07-30 09:06:04 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2020-05-27 09:43:13 +0200

Comment 22268

Date: 2016-07-30 09:06:04 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko/20100101 Firefox/47.0
Build Identifier:

A test has been added for the failing trigger activation on bullk insert

CREATE TABLE t111 (id INT, name VARCHAR(1024));

INSERT INTO t111 VALUES(10, 'monetdb');
INSERT INTO t111 VALUES(20, 'monet');

CREATE TRIGGER
test5
BEFORE INSERT ON t111
FOR EACH ROW
INSERT INTO t111 VALUES(4, 'update_when_statement_true');

INSERT INTO t111 SELECT * FROM t111;

Reproducible: Always

Comment 22269

Date: 2016-07-30 09:15:13 +0200
From: MonetDB Mercurial Repository <>

Changeset 811f7bf559d4 made by Martin Kersten mk@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=811f7bf559d4

Changeset description:

Trigger functionality bug
test case for Bug #4045

Comment 24580

Date: 2016-10-22 16:51:45 +0200
From: @njnes

this trigger will cause an endless loop...

Comment 27733

Date: 2020-05-27 09:43:13 +0200
From: MonetDB Mercurial Repository <>

Changeset d701f4fbebea made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=d701f4fbebea

Changeset description:

Missing stack overflow checks (required for Bug #4045 test)
@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants