Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
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;
|
|