Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.6, 10.7, 10.8
-
Component/s: JSON
-
Labels:None
Description
The following queries return result sets, although they are expected to return syntax errors:
-- BLOB cannot have a COLLATE clause
|
SELECT * FROM json_table('[{"name":"str"}]', '$[*]' |
COLUMNS (
|
name BLOB COLLATE `binary` PATH '$.name' |
)
|
) AS jt; |
+------+
|
| name |
|
+------+
|
| str |
|
+------+
|
-- Double COLLATE clause
|
SELECT * FROM json_table('[{"name":"str"}]', '$[*]' |
COLUMNS (
|
name VARCHAR(10) COLLATE latin1_bin COLLATE latin1_swedish_ci PATH '$.name' |
)
|
) AS jt; |
+------+
|
| name |
|
+------+
|
| str |
|
+------+
|
-- Redundant collation: BINARY (abbreviation meaning binary sorting) + standard COLLATE
|
SELECT * FROM json_table('[{"name":"str"}]', '$[*]' |
COLUMNS (
|
name VARCHAR(10) BINARY COLLATE utf8_czech_ci path '$.name' |
)
|
) AS jt; |
+------+
|
| name |
|
+------+
|
| str |
|
+------+
|
Attachments
Issue Links
- relates to
-
MDEV-27009 Add UCA-14.0.0 collations
-
- In Testing
-