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

vcol.vcol_keys_myisam fails on Windows x64, with Visual Studio 2022

    XMLWordPrintable

Details

    Description

      Fails reproducibly, on x64 only . Seems to be a compiler bug, time-wise correlates with compiler upgrade.

      vcol.vcol_keys_myisam                    w1 [ fail ]
              Test ended at 2021-11-10 23:19:21
       
      CURRENT_TEST: vcol.vcol_keys_myisam
      myisamchk: error: 138 when opening MyISAM-table 'D:/winx64-packages/build/mysql-test/var/1/mysqld.1/data//test/t1'
      myisamchk: error: 138 when opening MyISAM-table 'D:/winx64-packages/build/mysql-test/var/1/mysqld.1/data//test/t1'
      --- D:/winx64-packages/build/src/mysql-test/suite/vcol/r/vcol_keys_myisam.result	2021-11-10 22:57:27.000000000 +0000
      +++ D:\winx64-packages\build\src\mysql-test\suite\vcol\r\vcol_keys_myisam.reject	2021-11-10 23:19:21.521194600 +0000
      @@ -277,12 +277,15 @@
       delete from t1 where b=12;
       analyze table t1;
       Table	Op	Msg_type	Msg_text
      +test.t1	analyze	error	Key in wrong position at page 13312
       test.t1	analyze	status	Engine-independent statistics collected
      -test.t1	analyze	status	OK
      +test.t1	analyze	error	Corrupt
       show keys from t1;
       Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment	Index_comment
       t1	1	b	1	b	A	998	NULL	NULL	YES	BTREE		
       t1	1	i	1	d	A	998	NULL	NULL	YES	BTREE		
      +Warnings:
      +Note	1296	Making backup of data file ./test/t1.MYD with extension '-211110231921.BAK'
       select * from t1 where b=11;
       a	b	c	d
       10	11	-5440	10-5440
      
      

      Attachments

        1. remove_key_vs2022.asm
          11 kB
          Vladislav Vaintroub
        2. remove_key_vs2019.asm
          11 kB
          Vladislav Vaintroub

        Activity

          People

            wlad Vladislav Vaintroub
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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