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

main.selectivity_no_engine fails sometimes with Result content mismatch

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5.12
    • None
    • Tests
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            whissi Thomas Deutschmann
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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