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