Test systemfunctions.sql (id c952acc49888) (err)
systemfunctions.stable.out.int128.FILTERED 2019-12-03 07:37:35.499520628 +0100systemfunctions.test.out.FILTERED 2019-12-03 07:37:35.729531097 +0100
1 Statistics about stdout of test 'systemfunctions` in directory 'sql/test/sys-schema`: 1 1 Statistics about stdout of test 'systemfunctions` in directory 'sql/test/sys-schema`: 1
2 5471 lines, 42576 words, 260045 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5475 lines, 42612 words, 260289 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5471 lines, 42576 words, 260045 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5475 lines, 42612 words, 260289 chars in lines not matching '^$|^(\| |)#` 3
4 # 5503 lines, 42757 words, 261434 chars in all lines 4 ! 4 # 5510 lines, 42806 words, 261813 chars in all lines 4
5 5 5 5
..................
# sys.L1, sys.L2, sys.L3, sys.L4,
5006 [ "sys", "stopsession", 0, "int", "create procedure sys.stopsession(\"sessionid\" int)\n external name clients.stopsession;" ] 5006 5009 [ "sys", "stopsession", 0, "int", "create procedure sys.stopsession(\"sessionid\" int)\n external name clients.stopsession;" ] 5009
5007 [ "sys", "storage", 0, "varchar", "create function sys.\"storage\"()\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024), \n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] 5007 ! 5010 [ "sys", "storage", 0, "varchar", "create function sys.\"storage\"()\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024), \n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name sql.\"storage\";" ] 5010
5008 [ "sys", "storage", 1, "varchar", "" ] 5008 5011 [ "sys", "storage", 1, "varchar", "" ] 5011
..................
# sys.L1, sys.L2, sys.L3, sys.L4,
5023 [ "sys", "storage", 16, "bigint", "" ] 5023 5026 [ "sys", "storage", 16, "bigint", "" ] 5026
[ "sys", "storage", + 5027 [ "sys", "storage", 17, "boolean", "" ] 5027
5024 0, "varchar", "create function sys.\"storage\"(sname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] 5024 ! 5028 [ "sys", "storage", 0, "varchar", "create function sys.\"storage\"(sname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name sql.\"storage\";" ] 5028
5025 [ "sys", "storage", 1, "varchar", "" ] 5025 5029 [ "sys", "storage", 1, "varchar", "" ] 5029
..................
# sys.L1, sys.L2, sys.L3, sys.L4,
5040 [ "sys", "storage", 16, "bigint", "" ] 5040 5044 [ "sys", "storage", 16, "bigint", "" ] 5044
5041 [ "sys", "storage", 17, "varchar", "" ] 5041 ! 5045 [ "sys", "storage", 17, "boolean", "" ] 5045
[ "sys", "storage", + 5046 [ "sys", "storage", 18, "varchar", "" ] 5046
5042 0, "varchar", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] 5042 ! 5047 [ "sys", "storage", 0, "varchar", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name sql.\"storage\";" ] 5047
5043 [ "sys", "storage", 1, "varchar", "" ] 5043 5048 [ "sys", "storage", 1, "varchar", "" ] 5048
..................
# sys.L1, sys.L2, sys.L3, sys.L4,
5058 [ "sys", "storage", 16, "bigint", "" ] 5058 5063 [ "sys", "storage", 16, "bigint", "" ] 5063
5059 [ "sys", "storage", 17, "varchar", "" ] 5059 ! 5064 [ "sys", "storage", 17, "boolean", "" ] 5064
5060 [ "sys", "storage", 18, "varchar", "" ] 5060 5065 [ "sys", "storage", 18, "varchar", "" ] 5065
[ "sys", "storage", + 5066 [ "sys", "storage", 19, "varchar", "" ] 5066
5061 0, "varchar", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint\n)\nexternal name sql.\"storage\";" ] 5061 ! 5067 [ "sys", "storage", 0, "varchar", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname varchar(1024))\nreturns table (\n \"schema\" varchar(1024),\n \"table\" varchar(1024),\n \"column\" varchar(1024),\n \"type\" varchar(1024),\n \"mode\" varchar(15),\n location varchar(1024),\n \"count\" bigint,\n typewidth int,\n columnsize bigint,\n heapsize bigint,\n hashes bigint,\n phash boolean,\n \"imprints\" bigint,\n sorted boolean,\n revsorted boolean,\n \"unique\" boolean,\n orderidx bigint,\n compressed boolean\n)\nexternal name sql.\"storage\";" ] 5067
5062 [ "sys", "storage", 1, "varchar", "" ] 5062 5068 [ "sys", "storage", 1, "varchar", "" ] 5068
..................
# sys.L1, sys.L2, sys.L3, sys.L4,
5077 [ "sys", "storage", 16, "bigint", "" ] 5077 5083 [ "sys", "storage", 16, "bigint", "" ] 5083
5078 [ "sys", "storage", 17, "varchar", "" ] 5078 ! 5084 [ "sys", "storage", 17, "boolean", "" ] 5084
5079 [ "sys", "storage", 18, "varchar", "" ] 5079 5085 [ "sys", "storage", 18, "varchar", "" ] 5085
5080 [ "sys", "storage", 19, "varchar", "" ] 5080 5086 [ "sys", "storage", 19, "varchar", "" ] 5086
+ 5087 [ "sys", "storage", 20, "varchar", "" ] 5087
5081 [ "sys", "str_to_date", 0, "date", "create function str_to_date(s string, format string) returns date\n external name mtime.\"str_to_date\";" ] 5081 5088 [ "sys", "str_to_date", 0, "date", "create function str_to_date(s string, format string) returns date\n external name mtime.\"str_to_date\";" ] 5088