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
Singleton isn't respected in COMPUTED BY expressions [CORE881] #1274
Comments
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 [ 10041 ] |
Modified by: @pcisarVersion: 2.0.1 [ 10090 ] |
Commented by: @pcisar Fix confirmed for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @asfernandesVersion: 2.0.3 [ 10200 ] Version: 2.0.2 [ 10130 ] Fix Version: 2.0.4 [ 10211 ] |
Modified by: @pcisarWorkflow: jira [ 11106 ] => Firebird [ 14615 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: @asfernandes
Is related to QA70
Problem is caused by not complete "copy" of nod_rse in cmp.cpp.
It may occur in others conditions (not with COMPUTED BY), but it's reproducable with it.
create table t1 (n integer);
create table t2 (n integer, c computed by ((select n from t1)));
insert into t1 values (1);
insert into t1 values (2);
insert into t2 values (1);
-- this select should throw a error since the computed expression returns more than one row
select * from t2;
Commits: 4216ef7 6cc9341
The text was updated successfully, but these errors were encountered: