Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13420

views not compiling after installing 10.1.25 error on order clause

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.1, 10.2, 10.1.25
    • Fix Version/s: N/A
    • Component/s: Views
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              marc.langevin@usherbrooke.ca Marc
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: