Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 10.4(EOL), 11.0(EOL), 11.3(EOL)
-
debian 12
11.2.2-MariaDB-1:11.2.2+maria~deb12
Description
CREATE TABLE `test` (
`id` int(11) NOT NULL,
`txt` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `test` (`id`, `txt`) VALUES (1, 'test');
Doing
INSERT INTO `test` (`id`, `txt`) VALUES (2, 'test ');
Throws a duplicate index error because the txt value is trimed.
Attachments
Issue Links
- relates to
-
MDEV-25904 New collation functions to compare InnoDB style trimmed NO PAD strings
- Closed
-
MDEV-30095 Unexpected duplicate entry error for UNIQUE USING HASH + NOPAD
- Open