Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.2, 11.8.5, 12.1.2
-
None
-
None
Description
MariaDB silently accepts malformed UUIDs in WHERE clauses and returns incorrect results.
*Steps to reproduce:*
CREATE TABLE test_items ( |
id UUID NOT NULL PRIMARY KEY |
);
|
|
|
-- Insert some test data
|
INSERT INTO test_items (id) VALUES |
('1f073854-2fa2-62e2-a017-45b695424f53'), |
('2f073854-2fa2-62e2-a017-45b695424f53'), |
('3f073854-2fa2-62e2-a017-45b695424f53'); |
|
|
-- This query uses a MALFORMED UUID (missing leading '1')
|
SELECT * FROM test_items |
WHERE id != 'f073854-2fa2-62e2-a017-45b695424f53'; |
Example: https://onecompiler.com/mariadb/44bxngh22
*Expected behavior:*
Either:
- A warning/error about the invalid UUID format, OR
- 3 results returned since no row equals the malformed UUID
*Actual behavior:*
- Silently returns 0 rows with no warning
*Additional context:*
The correct query with a valid UUID returns expected results:
-- Correct query returns 2 rows as expected
|
SELECT * FROM test_items |
WHERE id != '1f073854-2fa2-62e2-a017-45b695424f53'; |