Test python-loader-string.Bug-6759.py (id 11f022e6b68c) (err)
python-loader-string.Bug-6759.stable.out.FILTERED 2019-09-20 02:29:51.175257300 +0200python-loader-string.Bug-6759.test.out.FILTERED 2019-09-20 02:29:51.175257300 +0200
1 Statistics about stdout of test 'python-loader-string.Bug-6759` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stdout of test 'python-loader-string.Bug-6759` in directory 'sql/test/BugTracker-2019`: 1
2 22 lines, 87 words, 631 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 9 lines, 30 words, 293 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 22 lines, 87 words, 631 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 9 lines, 30 words, 293 chars in lines not matching '^$|^(\| |)#` 3
4 # 100 lines, 488 words, 3658 chars in all lines 4 ! 4 # 36 lines, 152 words, 1208 chars in all lines 4
5 5 5 5
..................
# _emit.emit(json.loads('{"col1":
16 #};CREATE TABLE tbl FROM LOADER json_loader();SELECT * FROM tbl; 16 16 #};CREATE TABLE tbl FROM LOADER json_loader();SELECT * FROM tbl; 16
17 #CREATE LOADER json_loader() LANGUAGE PYTHON { 17 -
18 # import json 18 -
19 # _emit.emit(json.loads('{"col1": ["apple", "peer"], "col2": ["orange", "banana nananana"]}')) 19 -
20 #};CREATE TABLE tbl FROM LOADER json_loader();SELECT * FROM tbl; 20 -
21 #CREATE LOADER json_loader() LANGUAGE PYTHON { 21 -
22 # import json 22 -
23 # _emit.emit(json.loads('{"col1": ["apple", "peer"], "col2": ["orange", "banana nananana"]}')) 23 -
24 #};CREATE TABLE tbl FROM LOADER json_loader();SELECT * FROM tbl; 24 -
25 % sys.tbl, sys.tbl # table_name 25 -
26 % col1, col2 # name 26 -
27 % clob, clob # type 27 -
28 % 5, 15 # length 28 -
29 [ "apple", "orange" ] 29 -
30 [ "peer", "banana nananana" ] 30 -
31 START TRANSACTION; 31 17 START TRANSACTION; 17
..................
#};CREATE TABLE tbl FROM LOADER json_loa
37 }; 37 23 }; 23
38 CREATE TABLE "sys"."tbl" ( 38 -
39 "col1" CHARACTER LARGE OBJECT, 39 -
40 "col2" CHARACTER LARGE OBJECT 40 -
41 ); 41 -
42 COPY 2 RECORDS INTO "sys"."tbl" FROM stdin USING DELIMITERS E'\t',E'\n','"'; 42 -
43 "apple" "orange" 43 -
44 "peer" "banana nananana" 44 -
45 COMMIT; 45 24 COMMIT; 24