Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.7(EOL), 10.8(EOL)
-
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
-
- Closed
-