Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.25, 10.1(EOL), 10.2(EOL)
-
linux red hat 6
Description
Views that were changed to workaround bug MDEV-12819 are not compiling anymore after installing 10.1.25 and gives error on the order clause. But changing them again to use numeral position works
having those 2 tables:
create table if not exists t1 (idcol1 int,t1col1 int, t1col2 int,t1col3 int ); |
create table if not exists t2 (idcol1 int,t2col1 int, t2col2 int, t2col3 int); |
2 different cases:
create or replace view t2_view (col1,col2,col3) as |
select t1col1,t1col2,t1col3 from t1 |
union all |
select t2col1,t2col2,t2col3 from t2 |
order by col1,col2; |
gives error
Code: 1054 SQL State: 42S22 --- Unknown column 'col1' in 'order clause'
|
case #2
create or replace view t4_view (idcol1,col2,col3,col4) as |
select t1.idcol1,t1col2,t1col3,t2.idcol1 from t1 join t2 on (t1.idcol1 = t2.idcol1) |
union all |
select t2.idcol1,t2col2,t2col3,t1.idcol1 from t2 join t1 on (t2.idcol1 = t1.idcol1) |
order by idcol1,col2; |
gives error :
Code: 1052 SQL State: 23000 --- Column 'idcol1' in order clause is ambiguous
|
Those cases were working on 10.1.22 before upgrade to 10.1.25
Attachments
Issue Links
- relates to
-
MDEV-12819 order by ordering expression changed to empty string when creatin view with union
- Closed