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

An index on a double column erroneously uses prefix compression

    XMLWordPrintable

    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: