[#CORE-92] infinite insertion cycle - Firebird RDBMS Issue Tracker

Firebird Core

infinite insertion cycle

Created: 13/Mar/01 12:00 AM Updated: 18/Sep/16 09:20 PM

Component/s:

Engine

Affects Version/s:

None

Fix Version/s:

3.0 Alpha 1, 4.0 Initial, 3.0.0

Issue Links:

Duplicate

This issue is duplicated by:

~~CORE-1772~~ INSERT INTO myTABLE SELECT * FROM myTABLE

~~CORE-2384~~ insert into t(a) select a from t; enter into recursion mistakenly

~~CORE-2658~~ insert records bug

Relate

This issue relate to:

~~CORE-3362~~ Cursors should ignore changes made by the same statement

This issue is related to:

QA-499 Test for CORE-92

SF_ID:	408272
QA Status:	Covered by another test(s)
Test Details:	See test core_3362_basic.fbt

Description

« Hide

SFID: 408272#
Submitted By: mat000

execution of query like:
"insert into MyTable select * from MyTable"
force IBServer to produce infinite insertion cycle

All

Comments

Change History

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Alice F. Bird added a comment - 14/Jun/06 09:31 AM

Date: 2001-11-10 06:11
Sender: dschnepper
Logged In: YES
user_id=72348

I remember being bit by this "problem" with IB 3.2, back in
1991. I don't know what SQL says about this type of
problem, and I don't know if it's easily solvable. The
intent of this comment is to point out that this is not any
kind of new problem, but has existed in the product for at
least 10 years.
David Schnepper
9 Nov 2001

Dmitry Yemanov made changes - 18/Jun/06 06:14 AM

Field	Original Value	New Value
SF_ID	408272
Fix Version/s		3.0 [ 10048 ]

Pavel Cisar made changes - 06/Jul/06 04:59 PM

Assignee

Dmitry Yemanov [ dimitr ]

Dmitry Yemanov made changes - 16/Jul/06 06:34 PM

Assignee

Dmitry Yemanov [ dimitr ]

[ Permalink | « Hide ]

tom joad added a comment - 05/Jun/07 05:38 PM

A bug or a brainer?

Just as in triggers you have some sort of responisbility of avoiding
infinite or recursive loops,
in this example (which I guess only will be used to fill up a demo-db),
it's just to get the max-pk and then
insert... ..where pkval<your_max_val

Forget it and focus on the superserver smp. ;-) &
thanks for a fantastic db.

/tj

Pavel Cisar made changes - 28/Jan/08 01:18 PM

Workflow

jira [ 10116 ]

Firebird [ 14305 ]

Dmitry Yemanov made changes - 05/Mar/08 08:35 AM

Link

This issue is duplicated by ~~CORE-1772~~ [ ~~CORE-1772~~ ]

Dmitry Yemanov made changes - 23/Mar/09 01:33 AM

Link

This issue is duplicated by ~~CORE-2384~~ [ ~~CORE-2384~~ ]

Dmitry Yemanov made changes - 02/Oct/09 05:30 PM

Link

This issue is duplicated by ~~CORE-2658~~ [ ~~CORE-2658~~ ]

Dmitry Yemanov made changes - 19/Oct/09 05:30 PM

Fix Version/s		3.0 Alpha 1 [ 10331 ]
Fix Version/s	3.0.0 [ 10048 ]

Dmitry Yemanov made changes - 07/Oct/10 06:16 AM

Assignee

Dmitry Yemanov [ dimitr ]

Vlad Khorsun [ hvlad ]

Vlad Khorsun made changes - 25/Feb/11 09:09 AM

Link

This issue relate to ~~CORE-3362~~ [ ~~CORE-3362~~ ]

Dmitry Yemanov made changes - 23/Oct/12 08:37 AM

Status	Open [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Pavel Cisar made changes - 27/Mar/14 01:27 PM

Link

This issue is related to QA-499 [ QA-499 ]

Pavel Zotov made changes - 19/Jan/16 05:23 AM

QA Status

No test

Pavel Zotov made changes - 18/Sep/16 09:20 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
Test Details		See test core_3362_basic.fbt
QA Status	No test	Covered by another test(s)

Pavel Zotov made changes - 18/Sep/16 09:20 PM

Status	Resolved [ 5 ]	Closed [ 6 ]
Fix Version/s		3.0.0 [ 10740 ]
Fix Version/s		4.0 Initial [ 10621 ]