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

An index on a double column erroneously uses prefix compression

    Details

      Description

      CREATE TABLE t1 (
        id INT NOT NULL PRIMARY KEY,
        d  DOUBLE,
        KEY (d)
      ) ENGINE=MyISAM;
      

      MyISAM file:         MYSQLD_DATADIR/test/t1
      Record format:       Fixed length
      Character set:       latin1_swedish_ci (8)
      Data records:                    0  Deleted blocks:                 0
      Recordlength:                   13
       
      table description:
      Key Start Len Index   Type
      1   2     4   unique  long                 
      2   6     8   multip. double prefix NULL   
      DROP TABLE t1;
      

      Notice prefix in the second index.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: