Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.7, 10.8, 10.7.3, 10.8.2
-
Component/s: Data Manipulation - Delete, Data Manipulation - Update
-
Labels:None
-
Environment:Debian GNU/Linux 10
Description
Prepare:
CREATE TABLE companies (id uuid, name varchar(10)); |
INSERT INTO companies (id) values ('7bc95b06-cc6c-11ec-96c5-0242ac130002'); |
 |
CREATE TABLE divisions (company_id uuid); |
INSERT INTO divisions (company_id) values ('7bc95b06-cc6c-11ec-96c5-0242ac130002'); |
Strange results:
// 1 row retrieved
SELECT * |
FROM companies |
WHERE id IN ( |
SELECT company_id FROM divisions |
);
|
// not row affected
UPDATE companies |
SET name = 'value' |
WHERE id IN ( |
SELECT company_id FROM divisions |
);
|
// not row affected
DELETE FROM companies |
WHERE id IN ( |
SELECT company_id FROM divisions |
);
|
// 1 row affected
UPDATE companies |
SET name = 'value' |
WHERE CAST(id as varchar(100)) IN ( |
SELECT company_id FROM divisions |
);
|
// 1 row affected
DELETE FROM companies |
WHERE CAST(id as varchar(100)) IN ( |
SELECT company_id FROM divisions |
);
|
// 1 row affected
UPDATE companies |
SET column_a = 'value' |
WHERE id IN ( |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
);
|
// 1 row affected
DELETE FROM companies |
WHERE id IN ( |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
);
|
// not row affected
UPDATE companies |
SET column_a = 'value' |
WHERE id IN ( |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
UNION |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
);
|
// not row affected
DELETE FROM companies |
WHERE id IN ( |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
UNION |
SELECT '7bc95b06-cc6c-11ec-96c5-0242ac130002' |
);
|
Attachments
Issue Links
- is duplicated by
-
MDEV-28826 UUID field type + WHERE EXISTS doesn't work unless CASTed
-
- Closed
-
- relates to
-
MDEV-4958 Adding datatype UUID
-
- Closed
-