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

main.cte_nonrecursive failed in --embedded

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2.11
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/11029/steps/mtr_ps_emb/logs/stdio

      main.cte_nonrecursive                    w2 [ fail ]
              Test ended at 2017-11-16 14:56:16
       
      CURRENT_TEST: main.cte_nonrecursive
      Warning: /mnt/buildbot/build/mariadb-10.2.11/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.2.11/mysql-test/std_data/cacert.pem'
      Warning: /mnt/buildbot/build/mariadb-10.2.11/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.2.11/mysql-test/std_data/client-cert.pem'
      Warning: /mnt/buildbot/build/mariadb-10.2.11/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.2.11/mysql-test/std_data/client-key.pem'
      Warning: /mnt/buildbot/build/mariadb-10.2.11/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
      mysqltest: At line 824: query 'with cte as (select b from t2 where a < 4)
      select * from cte cte1 where b < 15 union select * from cte cte2 where b > 15' succeeded - should have failed with errno 1143...
       
      The result from queries just before the failure was:
      < snip >
      3
      1
      with cte as (select * from t1 where i < 4 group by i)
      select * from cte;
      i
      1
      2
      3
      with cte as (select * from t1 where i < 4)
      select * from cte cte1 where i < 2 union select * from cte cte2 where i > 2;
      i
      1
      3
      with cte as (select * from t1 where i < 4 group by i)
      select * from cte cte1 where i < 2 union select * from cte cte2 where i > 2;
      i
      1
      3
      with cte as (select b from t2 where a < 4)
      select * from cte cte1 where b < 15 union select * from cte cte2 where b > 15;
      
      

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: