You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create table t1(id1 int, id2 int);
insert into t1(id1,id2) values(1,2);
insert into t1(id1,id2) values(1,3);
insert into t1(id1,id2) values(1,4);
delete from t1 where id1 in (select id1 from t1 where id2=2) delete one record
delete from t1 where id1 in (select id1 from t1 where id2=3) delete two record
delete from t1 where id1 in (select id1 from t1 where id2=4) delete three record
?
====== Test Details ======
See test cases in core_3362.fbt
The text was updated successfully, but these errors were encountered:
It works well:
delete from t1 where id1 = (select id1 from t1 where id2=2);
delete from t1 where id1 = (select id1 from t1 where id2=3);
delete from t1 where id1 = (select id1 from t1 where id2=4);
Submitted by: Dmitry Kornilov (dk76)
Duplicates CORE3362
create table t1(id1 int, id2 int);
insert into t1(id1,id2) values(1,2);
insert into t1(id1,id2) values(1,3);
insert into t1(id1,id2) values(1,4);
delete from t1 where id1 in (select id1 from t1 where id2=2) delete one record
delete from t1 where id1 in (select id1 from t1 where id2=3) delete two record
delete from t1 where id1 in (select id1 from t1 where id2=4) delete three record
?
====== Test Details ======
See test cases in core_3362.fbt
The text was updated successfully, but these errors were encountered: