Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.12
-
None
-
None
Description
In 10.5.12 I saw test failures for main.selectivity_no_engine:
main.selectivity_no_engine w18 [ fail ]
|
Test ended at 2021-08-08 23:42:01
|
|
CURRENT_TEST: main.selectivity_no_engine
|
--- /var/tmp/portage/dev-db/mariadb-10.5.12/work/mysql/mysql-test/main/selectivity_no_engine.result 2021-08-03 10:29:08.000000000 +0200
|
+++ /var/tmp/portage/dev-db/mariadb-10.5.12/work/mysql/mysql-test/main/selectivity_no_engine.reject 2021-08-08 23:42:01.777747924 +0200
|
@@ -311,8 +311,8 @@
|
EXPLAIN
|
SELECT * FROM t1 AS a NATURAL JOIN t1 AS b;
|
id select_type table type possible_keys key key_len ref rows Extra
|
-1 SIMPLE a ALL NULL NULL NULL NULL 5 Using where
|
-1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 5 Using where; Using join buffer (flat, BNLH join)
|
+1 SIMPLE a ALL NULL NULL NULL NULL 4 Using where
|
+1 SIMPLE b hash_ALL NULL #hash#$hj 612 test.a.Host,test.a.User,test.a.Password,test.a.Select_priv,test.a.Insert_priv,test.a.Update_priv,test.a.Delete_priv,test.a.Create_priv,test.a.Drop_priv,test.a.Reload_priv,test.a.Shutdown_priv,test.a.Process_priv,test.a.File_priv,test.a.Grant_priv,test.a.References_priv,test.a.Index_priv,test.a.Alter_priv,test.a.Show_db_priv,test.a.Super_priv,test.a.Create_tmp_table_priv,test.a.Lock_tables_priv,test.a.Execute_priv,test.a.Repl_slave_priv,test.a.Repl_client_priv,test.a.Create_view_priv,test.a.Show_view_priv,test.a.Create_routine_priv,test.a.Alter_routine_priv,test.a.Create_user_priv,test.a.Event_priv,test.a.Trigger_priv,test.a.Create_tablespace_priv,test.a.Delete_history_priv,test.a.ssl_type,test.a.ssl_cipher,test.a.x509_issuer,test.a.x509_subject,test.a.max_questions,test.a.max_updates,test.a.max_connections,test.a.max_user_connections,test.a.plugin,test.a.authentication_string,test.a.password_expired,test.a.is_role,test.a.default_role,test.a.max_statement_time 4 Using where; Using join buffer (flat, BNLH join)
|
DROP TABLE t1,t2,t3;
|
#
|
# End of the test file
|
|
mysqltest: Result content mismatch
|
|
- saving '/var/tmp/portage/dev-db/mariadb-10.5.12/temp/var-tests/18/log/main.selectivity_no_engine/' to '/var/tmp/portage/dev-db/mariadb-10.5.12/temp/var-tests/log/main.selectivity_no_engine/'
|
|
Note that the test is passing when I re-run it manually.