Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32454

JSON test has problem in view protocol

    XMLWordPrintable

Details

    Description

      appeared that for a big part of func_json test view protocol was disabled. Here is problem with it

      --- /home/sanja/maria/git/10.4/mysql-test/main/func_json.result	2023-10-12 19:46:14.967079104 +0200
      +++ /home/sanja/maria/git/10.4/mysql-test/main/func_json.reject	2023-10-12 19:46:38.123111870 +0200
      @@ -226,7 +226,7 @@
       [[3, 4]]
       select json_insert('{"a":1, "b":{"c":1}, "d":[1, 2]}', '$.b.k1', 'word') as exp;
       exp
      -{"a": 1, "b": {"c": 1, "k1": "word"}, "d": [1, 2]}
      +{"a": 1, "b": {"c": 1, "k1": "word"}, "d":
       select json_insert('{"a":1, "b":{"c":1}, "d":[1, 2]}', '$.d[3]', 3) as exp;
       exp
       {"a": 1, "b": {"c": 1}, "d": [1, 2, 3]}
      @@ -238,7 +238,7 @@
       {"a": 1, "b": {"c": 1}, "d": [1, 2]}
       select json_set('{ "a": 1, "b": [2, 3]}', '$.a', 10, '$.c', '[true, false]') as exp;
       exp
      -{"a": 10, "b": [2, 3], "c": "[true, false]"}
      +{"a": 10, "b": [2, 3], "c": "[true,
       select json_replace('{ "a": 1, "b": [2, 3]}', '$.a', 10, '$.c', '[true, false]') as exp;
       exp
       {"a": 10, "b": [2, 3]}
      @@ -335,19 +335,19 @@
       [1, 2, {"id": 47}]
       select json_type('{"k1":123, "k2":345}');
       json_type('{"k1":123, "k2":345}')
      -OBJECT
      +OBJE
       select json_type('[123, "k2", 345]');
       json_type('[123, "k2", 345]')
      -ARRAY
      +ARRA
       select json_type("true");
       json_type("true")
      -BOOLEAN
      +BOOL
       select json_type('123');
       json_type('123')
      -INTEGER
      +INTE
       select json_type('123.12');
       json_type('123.12')
      -DOUBLE
      +DOUB
       select json_keys('{"a":{"c":1, "d":2}, "b":2}');
       json_keys('{"a":{"c":1, "d":2}, "b":2}')
       ["a", "b"]
      @@ -404,10 +404,10 @@
       drop table t1;
       select json_unquote('"abc"');
       json_unquote('"abc"')
      -abc
      +a
       select json_unquote('abc');
       json_unquote('abc')
      -abc
      +a
       create table t1 (c VARCHAR(8)) DEFAULT CHARSET=latin1;
       insert into t1 values ('abc'),('def');
       select json_object('foo', json_unquote(json_object('bar', c)),'qux', c) as fld from t1;
      @@ -420,7 +420,7 @@
       {"a": {"b": "abcd"}}
       select json_object("a", '{"b": "abcd"}');
       json_object("a", '{"b": "abcd"}')
      -{"a": "{\"b\": \"abcd\"}"}
      +{"a": "{\"b\": \"abcd\"}
       select json_object("a", json_compact('{"b": "abcd"}'));
       json_object("a", json_compact('{"b": "abcd"}'))
       {"a": {"b": "abcd"}}
      @@ -596,7 +596,7 @@
       {"a":1,"b":[1,2,3],"c":{"aa":"v1","bb":"v2"}}
       select json_loose('{"a":1, "b":[1,2,3], "c":{"aa":"v1", "bb": "v2"}}') as ex;
       ex
      -{"a": 1, "b": [1, 2, 3], "c": {"aa": "v1", "bb": "v2"}}
      +{"a": 1, "b": [1, 2, 3], "c": {"aa": "v1", "bb": 
       select json_detailed('{"a":1, "b":[1,2,3], "c":{"aa":"v1", "bb": "v2"}}') as ex;
       ex
       {
      @@ -604,15 +604,7 @@
           "b": 
           [
               1,
      -        2,
      -        3
      -    ],
      -    "c": 
      -    {
      -        "aa": "v1",
      -        "bb": "v2"
      -    }
      -}
      +        
       SELECT JSON_search( '{"x": "\\""}', "one", '"') as ex;
       ex
       "$.x"
      @@ -785,13 +777,13 @@
       #
       SELECT JSON_SET('{}', '$.a', _utf8 0xC3B6) as exp;
       exp
      -{"a": "�"}
      +{"a": "�"
       SELECT JSON_SET('{}', '$.a', _utf8 0xC3B6, '$.b', _utf8 0xC3B6) as exp;
       exp
      -{"a": "�", "b": "�"}
      +{"a": "�", "b"
       SELECT JSON_SET('{}', '$.a', _utf8 X'C3B6', '$.x', 1, '$.b', _utf8 X'C3B6') as exp;
       exp
      -{"a": "�", "x": 1, "b": "�"}
      +{"a": "�", "x": 1, "b
       #
       # MDEV-17121 JSON_ARRAY_APPEND
       #
      @@ -969,18 +961,18 @@
       JSON_CONTAINS('{"A": 0, "B": {"C": 1}, "D": 2}', '2', '$.A') AS ison_contains,
       JSON_CONTAINS_PATH('{"A": 1, "B": [2], "C": [3, 4]}', 'one', '$.A', '$.D') AS json_contains_path;
       Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
      -def					json_valid	3	1	1	Y32896	0	63
      -def					json_exists	3	1	1	Y32896	0	63
      -def					ison_contains	3	1	1	Y32896	0	63
      -def					json_contains_path	3	1	1Y	32896	0	63
      +def			mysqltest_tmp_v	json_valid	json_valid	3	11	Y	32768	0	63
      +def			mysqltest_tmp_v	json_exists	json_exists	3	11	Y	32768	0	63
      +def			mysqltest_tmp_v	ison_contains	ison_contains	3	11	Y	32768	0	63
      +def			mysqltest_tmp_v	json_contains_path	json_contains_path	3	1	1	Y	32768	0	63
       json_valid	json_exists	ison_contains	json_contains_path
       1	1	0	1
       SELECT
       JSON_LENGTH('{"a": 1, "b": {"c": 30}}') AS json_length,
       JSON_DEPTH('[10, {"a": 20}]') AS json_depnth;
       Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
      -def					json_length	3	10	1	Y32896	0	63
      -def					json_depnth	3	10	1	N32897	0	63
      +def			mysqltest_tmp_v	json_length	json_length	3	10	1	Y	32768	0	63
      +def			mysqltest_tmp_v	json_depnth	json_depnth	3	10	1	N	32769	0	63
       json_length	json_depnth
       2	3
       #
      @@ -1052,9 +1044,9 @@
       JSON_OBJECT("cond", true) AS j1,
       JSON_OBJECT("cond", COALESCE(true, false)) j2,
       JSON_OBJECT("cond", COALESCE(COALESCE(true, false))) j3;
      -j1	{"cond": true}
      -j2	{"cond": true}
      -j3	{"cond": true}
      +j1	{"cond": 1}
      +j2	{"cond": 1}
      +j3	{"cond": 1}
       CREATE TABLE t1 (a INT);
       INSERT INTO t1 VALUES (1),(2),(3);
       SELECT JSON_OBJECT('x',(SELECT MAX(a)=4 FROM t1));
      
      

      as test ancomment all protocol disabling marked #enable after MDEV-32454 fix

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.