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

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