Issue Details (XML | Word | Printable)

Key: CORE-92
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: mat000
Votes: 2
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
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
 
Relate

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: Ascending order - Click to sort in descending order
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 ]
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 ]