You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2022/11/30 01:53:24 UTC
[doris] branch master updated: [bug](jsonb) fix INSERT/CAST NULL to JSONB (#14682)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 4faca56819 [bug](jsonb) fix INSERT/CAST NULL to JSONB (#14682)
4faca56819 is described below
commit 4faca56819832ad346c4419c189cc6f1c48117a7
Author: Kang <kx...@gmail.com>
AuthorDate: Wed Nov 30 09:53:16 2022 +0800
[bug](jsonb) fix INSERT/CAST NULL to JSONB (#14682)
Add NULL -> JSONB in implicitCastMap to support INSERT/CAST NULL to JSONB.
---
.../org/apache/doris/catalog/PrimitiveType.java | 1 +
.../data/jsonb_p0/test_jsonb_load_and_function.out | 528 ++++++++++++++-------
.../jsonb_p0/test_jsonb_load_and_function.groovy | 4 +-
3 files changed, 357 insertions(+), 176 deletions(-)
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
index 273e658316..c951a481f5 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
@@ -116,6 +116,7 @@ public enum PrimitiveType {
builder.put(NULL_TYPE, CHAR);
builder.put(NULL_TYPE, VARCHAR);
builder.put(NULL_TYPE, STRING);
+ builder.put(NULL_TYPE, JSONB);
builder.put(NULL_TYPE, BITMAP); //TODO(weixiang):why null type can cast to bitmap?
builder.put(NULL_TYPE, TIME);
builder.put(NULL_TYPE, TIMEV2);
diff --git a/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out b/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
index e7d9b65b2e..d834c24dcd 100644
--- a/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
+++ b/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
@@ -38,7 +38,8 @@
16 [null,true,false,100,6.18,"abc"]
17 [{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
-26 {"k1":"v1","k2":200}
+26 \N
+27 {"k1":"v1","k2":200}
-- !select --
1 \N \N
@@ -59,7 +60,8 @@
16 [null,true,false,100,6.18,"abc"] [null,true,false,100,6.18,"abc"]
17 [{"k1":"v41","k2":400},1,"a",3.14] [{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
-26 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+26 \N \N
+27 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
-- !select --
1 \N \N
@@ -80,7 +82,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} "v31"
-26 {"k1":"v1","k2":200} "v1"
+26 \N \N
+27 {"k1":"v1","k2":200} "v1"
-- !select --
1 \N \N
@@ -101,7 +104,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 300
-26 {"k1":"v1","k2":200} 200
+26 \N \N
+27 {"k1":"v1","k2":200} 200
-- !select --
1 \N \N
@@ -122,7 +126,8 @@
16 [null,true,false,100,6.18,"abc"] null
17 [{"k1":"v41","k2":400},1,"a",3.14] {"k1":"v41","k2":400}
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -143,7 +148,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] 1
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -164,7 +170,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] "a"
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -185,7 +192,8 @@
16 [null,true,false,100,6.18,"abc"] 100
17 [{"k1":"v41","k2":400},1,"a",3.14] 3.14
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -206,7 +214,8 @@
16 [null,true,false,100,6.18,"abc"] 6.18
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -227,7 +236,8 @@
16 [null,true,false,100,6.18,"abc"] "abc"
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -248,7 +258,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -269,7 +280,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -290,7 +302,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} [{"k1":"v41","k2":400},1,"a",3.14]
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -311,7 +324,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v41","k2":400}
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -332,7 +346,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 1
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -353,7 +368,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} "a"
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -374,7 +390,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 3.14
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -395,7 +412,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -416,7 +434,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -437,7 +456,8 @@
16 [null,true,false,100,6.18,"abc"] [null,true,false,100,6.18,"abc"]
17 [{"k1":"v41","k2":400},1,"a",3.14] [{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
-26 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+26 \N \N
+27 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
-- !select --
1 \N \N
@@ -458,7 +478,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} v31
-26 {"k1":"v1","k2":200} v1
+26 \N \N
+27 {"k1":"v1","k2":200} v1
-- !select --
1 \N \N
@@ -479,7 +500,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 300
-26 {"k1":"v1","k2":200} 200
+26 \N \N
+27 {"k1":"v1","k2":200} 200
-- !select --
1 \N \N
@@ -500,7 +522,8 @@
16 [null,true,false,100,6.18,"abc"] null
17 [{"k1":"v41","k2":400},1,"a",3.14] {"k1":"v41","k2":400}
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -521,7 +544,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] 1
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -542,7 +566,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] a
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -563,7 +588,8 @@
16 [null,true,false,100,6.18,"abc"] 100
17 [{"k1":"v41","k2":400},1,"a",3.14] 3.14
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -584,7 +610,8 @@
16 [null,true,false,100,6.18,"abc"] 6.18
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -605,7 +632,8 @@
16 [null,true,false,100,6.18,"abc"] abc
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -626,7 +654,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -647,7 +676,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -668,7 +698,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} [{"k1":"v41","k2":400},1,"a",3.14]
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -689,7 +720,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v41","k2":400}
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -710,7 +742,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 1
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -731,7 +764,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} a
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -752,7 +786,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 3.14
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -773,7 +808,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -794,7 +830,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -815,7 +852,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -836,7 +874,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -857,7 +896,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 300
-26 {"k1":"v1","k2":200} 200
+26 \N \N
+27 {"k1":"v1","k2":200} 200
-- !select --
1 \N \N
@@ -878,7 +918,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -899,7 +940,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] 1
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -920,7 +962,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -941,7 +984,8 @@
16 [null,true,false,100,6.18,"abc"] 100
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -962,7 +1006,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -983,7 +1028,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1004,7 +1050,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1025,7 +1072,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1046,7 +1094,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1067,7 +1116,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1088,7 +1138,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 1
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1109,7 +1160,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1130,7 +1182,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1151,7 +1204,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1172,7 +1226,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1193,7 +1248,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1214,7 +1270,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1235,7 +1292,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 300
-26 {"k1":"v1","k2":200} 200
+26 \N \N
+27 {"k1":"v1","k2":200} 200
-- !select --
1 \N \N
@@ -1256,7 +1314,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1277,7 +1336,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] 1
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1298,7 +1358,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1319,7 +1380,8 @@
16 [null,true,false,100,6.18,"abc"] 100
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1340,7 +1402,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1361,7 +1424,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1382,7 +1446,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1403,7 +1468,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1424,7 +1490,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1445,7 +1512,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1466,7 +1534,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 1
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1487,7 +1556,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1508,7 +1578,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1529,7 +1600,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1550,7 +1622,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1571,7 +1644,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1592,7 +1666,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1613,7 +1688,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 300.0
-26 {"k1":"v1","k2":200} 200.0
+26 \N \N
+27 {"k1":"v1","k2":200} 200.0
-- !select --
1 \N \N
@@ -1634,7 +1710,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1655,7 +1732,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] 1.0
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1676,7 +1754,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1697,7 +1776,8 @@
16 [null,true,false,100,6.18,"abc"] 100.0
17 [{"k1":"v41","k2":400},1,"a",3.14] 3.14
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1718,7 +1798,8 @@
16 [null,true,false,100,6.18,"abc"] 6.18
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1739,7 +1820,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1760,7 +1842,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1781,7 +1864,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1802,7 +1886,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1823,7 +1908,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1844,7 +1930,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 1.0
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1865,7 +1952,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1886,7 +1974,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 3.14
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1907,7 +1996,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1928,7 +2018,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1949,7 +2040,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1970,7 +2062,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -1991,7 +2084,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2012,7 +2106,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2033,7 +2128,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2054,7 +2150,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2075,7 +2172,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2096,7 +2194,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2117,7 +2216,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2138,7 +2238,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2159,7 +2260,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2180,7 +2282,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2201,7 +2304,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2222,7 +2326,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2243,7 +2348,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2264,7 +2370,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2285,7 +2392,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2306,7 +2414,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2327,7 +2436,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2348,7 +2458,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2369,7 +2480,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2390,7 +2502,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2411,7 +2524,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2432,7 +2546,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2453,7 +2568,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2474,7 +2590,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2495,7 +2612,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2516,7 +2634,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2537,7 +2656,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2558,7 +2678,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2579,7 +2700,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2600,7 +2722,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2621,7 +2744,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2642,7 +2766,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2663,7 +2788,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2684,7 +2810,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -2705,7 +2832,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] true
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} true
+26 \N \N
+27 {"k1":"v1","k2":200} true
-- !select --
1 \N \N
@@ -2726,7 +2854,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} true
+26 \N \N
+27 {"k1":"v1","k2":200} true
-- !select --
1 \N \N
@@ -2747,7 +2876,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} true
+26 \N \N
+27 {"k1":"v1","k2":200} true
-- !select --
1 \N \N
@@ -2768,7 +2898,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] true
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2789,7 +2920,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] true
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2810,7 +2942,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] true
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2831,7 +2964,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] true
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2852,7 +2986,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2873,7 +3008,8 @@
16 [null,true,false,100,6.18,"abc"] true
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2894,7 +3030,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2915,7 +3052,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2936,7 +3074,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2957,7 +3096,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2978,7 +3118,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -2999,7 +3140,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -3020,7 +3162,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -3041,7 +3184,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -3062,7 +3206,8 @@
16 [null,true,false,100,6.18,"abc"] false
17 [{"k1":"v41","k2":400},1,"a",3.14] false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
-26 {"k1":"v1","k2":200} false
+26 \N \N
+27 {"k1":"v1","k2":200} false
-- !select --
1 \N \N
@@ -3083,7 +3228,8 @@
16 [null,true,false,100,6.18,"abc"] array
17 [{"k1":"v41","k2":400},1,"a",3.14] array
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} object
-26 {"k1":"v1","k2":200} object
+26 \N \N
+27 {"k1":"v1","k2":200} object
-- !select --
1 \N \N
@@ -3104,7 +3250,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} string
-26 {"k1":"v1","k2":200} string
+26 \N \N
+27 {"k1":"v1","k2":200} string
-- !select --
1 \N \N
@@ -3125,7 +3272,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} int
-26 {"k1":"v1","k2":200} int
+26 \N \N
+27 {"k1":"v1","k2":200} int
-- !select --
1 \N \N
@@ -3146,7 +3294,8 @@
16 [null,true,false,100,6.18,"abc"] null
17 [{"k1":"v41","k2":400},1,"a",3.14] object
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3167,7 +3316,8 @@
16 [null,true,false,100,6.18,"abc"] bool
17 [{"k1":"v41","k2":400},1,"a",3.14] int
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3188,7 +3338,8 @@
16 [null,true,false,100,6.18,"abc"] bool
17 [{"k1":"v41","k2":400},1,"a",3.14] string
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3209,7 +3360,8 @@
16 [null,true,false,100,6.18,"abc"] int
17 [{"k1":"v41","k2":400},1,"a",3.14] double
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3230,7 +3382,8 @@
16 [null,true,false,100,6.18,"abc"] double
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3251,7 +3404,8 @@
16 [null,true,false,100,6.18,"abc"] string
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3272,7 +3426,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3293,7 +3448,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3314,7 +3470,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} array
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3335,7 +3492,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} object
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3356,7 +3514,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} int
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3377,7 +3536,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} string
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3398,7 +3558,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} double
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3419,7 +3580,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3440,7 +3602,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3461,7 +3624,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3482,7 +3646,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3503,7 +3668,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3524,7 +3690,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3545,7 +3712,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3566,7 +3734,8 @@
16 [null,true,false,100,6.18,"abc"] [null,true,false,100,6.18,"abc"]
17 [{"k1":"v41","k2":400},1,"a",3.14] [{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
-26 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+26 \N \N
+27 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
-- !select --
1 \N \N
@@ -3587,7 +3756,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3608,7 +3778,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3629,7 +3800,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3650,7 +3822,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3671,7 +3844,8 @@
16 [null,true,false,100,6.18,"abc"] \N
17 [{"k1":"v41","k2":400},1,"a",3.14] \N
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 {"k1":"v1","k2":200} \N
+26 \N \N
+27 {"k1":"v1","k2":200} \N
-- !select --
1 \N \N
@@ -3692,7 +3866,11 @@
16 [null,true,false,100,6.18,"abc"] [null,true,false,100,6.18,"abc"]
17 [{"k1":"v41","k2":400},1,"a",3.14] [{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
-26 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+26 \N \N
+27 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+
+-- !select --
+\N
-- !select --
null
diff --git a/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy b/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
index 2535f375ef..07e75ee26b 100644
--- a/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
+++ b/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
@@ -89,7 +89,8 @@ suite("test_jsonb_load_and_function", "p0") {
qt_select "SELECT * FROM ${testTable} ORDER BY id"
// insert into 1 row and then check result
- sql """INSERT INTO ${testTable} VALUES(26, '{"k1":"v1", "k2": 200}')"""
+ sql """INSERT INTO ${testTable} VALUES(26, NULL)"""
+ sql """INSERT INTO ${testTable} VALUES(27, '{"k1":"v1", "k2": 200}')"""
qt_select "SELECT * FROM ${testTable} ORDER BY id"
// jsonb_extract
@@ -326,6 +327,7 @@ suite("test_jsonb_load_and_function", "p0") {
qt_select "SELECT id, j, CAST(CAST(j AS DOUBLE) AS JSONB) FROM ${testTable} ORDER BY id"
qt_select "SELECT id, j, CAST(CAST(j AS STRING) AS JSONB) FROM ${testTable} ORDER BY id"
+ qt_select """SELECT CAST(NULL AS JSONB)"""
qt_select """SELECT CAST('null' AS JSONB)"""
qt_select """SELECT CAST('true' AS JSONB)"""
qt_select """SELECT CAST('false' AS JSONB)"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org