[MDEV-20704] An index on a double column erroneously uses prefix compression - Jira

XML

Word

Printable

CREATE TABLE t1 (

  id INT NOT NULL PRIMARY KEY,

  d  DOUBLE,

  KEY (d)

) ENGINE=MyISAM;

Now run myisamchk -d MYSQLD_DATADIR/test/t1:

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.

blocks

MDEV-4912 Data type plugin API version 1

causes

MDEV-28727 ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade

MDEV-29481 mariadb-upgrade prints confusing statement

relates to

MDEV-28822 Table from older version requires table rebuild when adding column to table with multi-column index

MDEV-29495 Generalize can_convert_xxx() hook engine API to cover any arbitrary data type

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(6 mentioned in)

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