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

main.cte_nonrecursive failed in --embedded

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2
    • 10.2.11
    • Tests
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.