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;