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

infinite insertion cycle [CORE92] #417

Closed
firebird-automations opened this issue Mar 13, 2001 · 17 comments
Closed

infinite insertion cycle [CORE92] #417

firebird-automations opened this issue Mar 13, 2001 · 17 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: mat000 (mat000)

Is duplicated by CORE1772
Is duplicated by CORE2384
Is duplicated by CORE2658
Relate to CORE3362
Is related to QA499

Votes: 2

SFID: 408272#⁠
Submitted By: mat000

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

====== Test Details ======

See test core_3362_basic.fbt

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 408272 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Commented by: tom joad (tomjoad)

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10116 ] => Firebird [ 14305 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE1772 [ CORE1772 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE2384 [ CORE2384 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE2658 [ CORE2658 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ] => Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue relate to CORE3362 [ CORE3362 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA499 [ QA499 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See test core_3362_basic.fbt

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Fix Version: 3.0.0 [ 10740 ]

Fix Version: 4.0 Initial [ 10621 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment