Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.2.2, 11.2.4, 11.5.2
-
None
-
Docker linux image: e.g. mariadb:11.5.2
Description
See this easy reproducable example:
CREATE TABLE `uuid_problem` ( |
`id` UUID NOT NULL, |
PRIMARY KEY (`id`) USING BTREE |
)
|
COLLATE='utf8mb4_unicode_ci' |
ENGINE=InnoDB
|
;
|
|
INSERT INTO `uuid_problem` (`id`) VALUES ('e8748eee-fabe-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('036d4fc5-fabf-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('2acf42cc-fabf-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('594a8970-fabf-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('4238a6e5-fac1-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('6d001a4d-fac1-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('e4e67615-fad5-11eb-af18-005056bc575d'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('1ec69927-30f3-62ca-a0a0-4b98bb6957f8'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('1ec6992e-5c9e-6b2a-a21b-fbc054a2075e'); |
INSERT INTO `uuid_problem` (`id`) VALUES ('1ec6992e-e5be-6342-8293-e107448b2cd5'); |
|
-- This returns 10 rows
|
SELECT * FROM `uuid_problem` WHERE id IN ( |
"036d4fc5-fabf-11eb-af18-005056bc575d","e8748eee-fabe-11eb-af18-005056bc575d","2acf42cc-fabf-11eb-af18-005056bc575d","594a8970-fabf-11eb-af18-005056bc575d","4238a6e5-fac1-11eb-af18-005056bc575d","6d001a4d-fac1-11eb-af18-005056bc575d","e4e67615-fad5-11eb-af18-005056bc575d","1ec69927-30f3-62ca-a0a0-4b98bb6957f8","1ec6992e-5c9e-6b2a-a21b-fbc054a2075e","1ec6992e-e5be-6342-8293-e107448b2cd5" |
);
|
|
|
-- Here we only swap the first 2 values of the `id IN ()` array
|
-- This suddenly return 9 rows
|
SELECT * FROM `uuid_problem` WHERE id IN ( |
"e8748eee-fabe-11eb-af18-005056bc575d","036d4fc5-fabf-11eb-af18-005056bc575d","2acf42cc-fabf-11eb-af18-005056bc575d","594a8970-fabf-11eb-af18-005056bc575d","4238a6e5-fac1-11eb-af18-005056bc575d","6d001a4d-fac1-11eb-af18-005056bc575d","e4e67615-fad5-11eb-af18-005056bc575d","1ec69927-30f3-62ca-a0a0-4b98bb6957f8","1ec6992e-5c9e-6b2a-a21b-fbc054a2075e","1ec6992e-e5be-6342-8293-e107448b2cd5" |
);
|