Changeset: 452b642d7615 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/452b642d7615
Modified Files:
sql/test/nested/Tests/jdocs.test
Branch: nested
Log Message:
Adds (commented out) test case for jdocs
diffs (35 lines):
diff --git a/sql/test/nested/Tests/jdocs.test b/sql/test/nested/Tests/jdocs.test
--- a/sql/test/nested/Tests/jdocs.test
+++ b/sql/test/nested/Tests/jdocs.test
@@ -26,6 +26,23 @@ insert into fljdocs select cast('{"name"
statement ok
insert into fljdocs select
cast('{"name":"test_two","id":43,"actions":[{"elem":{"key":"tic","val":20}},
{"elem":{"key":"tac","val":21}}] }' as json)
+## CRASH
+#query TIT nosort jsondata
+#select jd.name, jd.id, act.elem from fljdocs, unnest(jd.actions) act
+#----
+#test_one
+#42
+#("ping",10)
+#test_one
+#42
+#("pong",11)
+#test_two
+#43
+#("tic",20)
+#test_two
+#43
+#("tac",21)
+
query TITI nosort jsondata
select jd.name, jd.id, act.elem.key, act.elem.val from fljdocs,
unnest(jd.actions) act
----
@@ -57,6 +74,7 @@ insert into wljdocs select cast('{"name"
statement ok
insert into wljdocs select
cast('{"name":"test_two","id":43,"actions":{"list":[{"elem":{"key":"tic","val":20}},
{"elem":{"key":"tac","val":21}}] }}' as json)
+## CRASH
#query TITI nosort jsondata
#select jd.name, jd.id, act.list.elem.key, act.list.elem.val from fljdocs,
unnest(jd.actions.list) act
#----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
