mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
5c9770d1e6
JSON functions were implemented violating an assumption of their pureness, as they should not have any state. This concrete patch fixes implementation of JSON_VALUE function.
33 lines
1.5 KiB
Plaintext
33 lines
1.5 KiB
Plaintext
--disable_warnings
|
|
DROP DATABASE IF EXISTS MCOL5607;
|
|
--enable_warnings
|
|
CREATE DATABASE MCOL5607;
|
|
USE MCOL5607;
|
|
CREATE TABLE zu (hu TEXT) ENGINE = COLUMNSTORE;
|
|
INSERT INTO zu(hu) VALUES ('{}'), (NULL), ('{ "": "huh", "10001" : "10001", "10002" : "10001", "10003" : "10001", "10004" : "10001", "10005" : "10001", "10006" : "10001", "10007" : "10001", "10008" : "10001", "10009" : "10001", "10010" : "10001", "10011" : "10001", "10012" : "10001", "10013" : "10001", "10014" : "10001", "10015" : "10001", "10016" : "10001", "10017" : "10001", "10018" : "10001", "10019" : "10001", "10020" : "10001", "buga" : ""}');
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
INSERT INTO zu(hu) SELECT hu FROM zu;
|
|
SELECT COUNT(*) FROM zu;
|
|
SELECT COUNT(*) FROM zu wHERE
|
|
JSON_VALUE(hu, '$.buga') IS NOT NULL
|
|
AND JSON_VALUE(hu, '$.zhuga') IS NULL;
|
|
DROP DATABASE MCOL5607;
|