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
Bad treatment of FIRST/SKIP in subselect [CORE634] #996
Comments
Commented by: Alice F. Bird (firebirds) Date: 2004-07-19 20:38 When this will be fixed ? I think its a very important fix.. |
Commented by: Alice F. Bird (firebirds) Date: 2002-07-17 23:59 yea, there is big problem with correlated subqueries in IB |
Modified by: @dyemanovassignee: Ann Harrison [ awharrison ] => Dmitry Yemanov [ dimitr ] SF_ID: 479483 => |
Modified by: @pcisarassignee: Dmitry Yemanov [ dimitr ] => |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Commented by: Eugenk Konkov (kes) Another testcase for subqueries: create table test(id int, val char(5)); Results for "select * from test" must be: and NOT: |
Modified by: @pcisarWorkflow: jira [ 10658 ] => Firebird [ 15007 ] |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] => Vlad Khorsun [ hvlad ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: This ticket QA Status should be marked as "Covered by another test(s)" when integral test for core-3362 will be done. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done with caveats Test Details: This ticket QA Status should be marked as "Covered by another test(s)" when integral test for core-3362 will be done. => Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Done with caveats => Covered by another test(s) Test Details: Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets. => See test core_3362_basic.fbt |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] Fix Version: 3.0.0 [ 10740 ] Fix Version: 4.0 Initial [ 10621 ] |
Submitted by: @pcisar
Relate to CORE3317
Relate to CORE3362
Is duplicated by CORE3862
Is related to QA501
Votes: 3
SFID: 479483#
Submitted By: pcisar
Commands like
delete from table where col in (select col first 5
from table);
doesn't delete up to five rows, but whole table.
Obviously subselect is executed for each row in master
table, but it should not when FIRST is in game.
====== Test Details ======
See test core_3362_basic.fbt
The text was updated successfully, but these errors were encountered: