Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
Test:
set SQL_MODE=ORACLE; |
|
create table t12(c1 int); |
insert into t12 values(1); |
insert into t12 values(2); |
create table t13(c1 int); |
insert into t13 values(1); |
insert into t13 values(3); |
create table t234(c1 int); |
insert into t234 values(2); |
insert into t234 values(3); |
insert into t234 values(4); |
|
create view v1 as select * from t13 union select * from t234 intersect select * from t12; |
select * from v1; |
drop view v1; |
|
drop table t12,t13, t234; |
Expected result:
c1
|
1
|
2
|
Actual result:
c1
|
1
|
3
|
2
|
Attachments
Issue Links
- is part of
-
MDEV-27691 make working view-protocol
- Open