Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
2025-9
Description
This SQL script checks recognition of JSON data type and triggers checks on INSERT and UPDATE statements:
USE test; |
DROP TABLE IF EXISTS tj; |
CREATE TABLE tj(j JSON); --ENGINE=COLUMNSTORE; |
INSERT INTO tj(j) VALUES ('()'); -- invalid |
INSERT INTO tj(j) VALUES ('[]'), ('{}'), ('"a"'); -- valid |
SELECT * FROM tj WHERE j = '"A"'; -- empty set. |
SELECT * FROM tj WHERE j = '"a"'; -- single row. |
INSERT INTO tj(j) VALUES ('{"a":"b", "b":"a"}'); |
SELECT * FROM tj WHERE j = '{"b":"a","a":"b"}'; -- empty set, comparison is not structural. |
UPDATE tj SET j = CONCAT(j,'()'); |
The goal of this task is to make it properly work with Columnstore engine.
Attachments
Issue Links
- blocks
-
MCOL-4240 Support non-scalar data types enum, set, json
-
- Stalled
-