maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Completed: Failed 1/1865 tests, 99.95% were successful
_________________________________________

[root@testserver:~]$ cat /usr/local/bin/mysql-test.sh
#!/usr/bin/dash

/usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl 
--parallel=4 --max-test-fail=0 --mysqld=--binlog-format=row --force 
--suites="main-,binlog-,csv-,funcs_1-,funcs_2-,handler-,heap-,maria-,optimizer_unfixed_bugs-,parts-,percona-,roles-,rpl-,sys_vars-,unit-,vcol-" 
--skip-test-list=/var/lib/mysql/skip-tests.txt' mysql
rm -rf /usr/share/mysql-test/var/*
_________________________________________

CURRENT_TEST: main.subselect_no_opts
/usr/bin/mysqltest: Error on delete of 
'/usr/share/mysql-test/var/4/tmp/subselect.out.file.1' (Errcode: 2 "No 
such file or directory")
mysqltest: In included file "/usr/share/mysql-test/t/subselect.test":
included from /usr/share/mysql-test/t/subselect_no_opts.test at line 12:
At line 5903: query 'Select
(Select Sum(`TestCase`.Revenue) From mysql.slow_log E
Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2)
) As `ControlRev`
From
(Select  3 as Revenue, 4 as TemplateID) As `TestCase`
Group By  TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery 
returns more than 1 row

The result from queries just before the failure was:
< snip >
2       SUBQUERY        t2      ref     b       b       5 
test.t1.a       2       Using index
DROP TABLE t1,t2;
#
# MDEV-5991: crash in Item_field::used_tables
#
create table t1 (c int);
select exists(select 1 from t1 group by `c` in (select `c` from t1));
exists(select 1 from t1 group by `c` in (select `c` from t1))
0
drop table t1;
#
# MDEV-7565: Server crash with Signal 6 (part 2)
#
Select
(Select Sum(`TestCase`.Revenue) From mysql.slow_log E
Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2)
) As `ControlRev`
From
(Select  3 as Revenue, 4 as TemplateID) As `TestCase`
Group By  TestCase.Revenue, TestCase.TemplateID;

More results from queries before failure can be found in 
/usr/share/mysql-test/var/4/log/subselect_no_opts.log

 - saving '/usr/share/mysql-test/var/4/log/main.subselect_no_opts/' to 
'/usr/share/mysql-test/var/log/main.subselect_no_opts/'
***Warnings generated in error logs during shutdown after running tests: 
main.grant main.subselect3_jcl6 main.subselect_mat 
main.strict_autoinc_3heap main.func_time_hires main.failed_auth_3909 
main.subselect_extra main.gis-json main.gis main.gis-precise 
main.subselect_no_opts main.explain main.get_diagnostics 
main.str_to_datetime_457 main.function_defaults main.execution_constants 
main.func_weight_string main.empty_server_name-8224 main.func_timestamp 
main.subselect_cache main.subselect_gis main.gcc296 main.flush_table

2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: 
localhost, user: root, thread: 164, query: select numeropost as a FROM 
t1 ORDER BY (SELECT 1 FROM t1 HAVING a=1)
2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: 
localhost, user: root, thread: 164, query: SELECT a FROM t1 GROUP BY a
2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: 
localhost, user: root, thread: 164, query: SELECT a FROM t1 GROUP BY a
2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: 
localhost, user: root, thread: 164, query: SELECT a FROM t1
2017-07-13 15:35:31 140219388360448 [Warning] Sort aborted, host: 
localhost, user: root, thread: 164, query: SELECT a FROM t1