Test rapi06.sql (id 0177627dc2e1) (err)
rapi06.stable.out.FILTERED 2019-09-20 20:11:42.000000000 +0200rapi06.test.out.FILTERED 2019-09-20 20:11:42.000000000 +0200
1 Statistics about stdout of test 'rapi06` in directory 'sql/backends/monet5`: 1 1 Statistics about stdout of test 'rapi06` in directory 'sql/backends/monet5`: 1
2 13 lines, 58 words, 229 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 119 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 13 lines, 58 words, 229 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 119 chars in lines not matching '^$|^(\| |)#` 3
4 # 89 lines, 408 words, 2965 chars in all lines 4 ! 4 # 27 lines, 131 words, 1162 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
26 26 24 24
27 # SQL catalog created, loading sql scripts once 27 ! 25 25
28 # loading sql script: 09_like.sql 28 ! 26 ! Server not ready; skipping attempt to start client! 26
29 # loading sql script: 10_math.sql 29 ! 27 27
30 # loading sql script: 11_times.sql 30 ! 28 28
31 # loading sql script: 12_url.sql 31 ! 29 # 20:11:42 > 29
32 # loading sql script: 13_date.sql 32 ! 30 # 20:11:42 > "Done." 30
33 # loading sql script: 14_inet.sql 33 ! 31 # 20:11:42 > 31
34 # loading sql script: 15_querylog.sql 34 -
35 # loading sql script: 16_tracelog.sql 35 -
36 # loading sql script: 17_compress.sql 36 -
37 # loading sql script: 18_dictionary.sql 37 -
38 # loading sql script: 19_cluster.sql 38 -
39 # loading sql script: 20_vacuum.sql 39 -
40 # loading sql script: 21_dependency_functions.sql 40 -
41 # loading sql script: 22_clients.sql 41 -
42 # loading sql script: 23_skyserver.sql 42 -
43 # loading sql script: 24_zorder.sql 43 -
44 # loading sql script: 25_debug.sql 44 -
45 # loading sql script: 26_sysmon.sql 45 -
46 # loading sql script: 39_analytics.sql 46 -
47 # loading sql script: 40_geom.sql 47 -
48 # loading sql script: 46_gsl.sql 48 -
49 # loading sql script: 75_storagemodel.sql 49 -
50 # loading sql script: 80_statistics.sql 50 -
51 # loading sql script: 80_udf.sql 51 -
52 # loading sql script: 99_system.sql 52 -
53 53 -
54 # 16:43:00 > 54 -
55 # 16:43:00 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-25899" "--port=31453" 55 -
56 # 16:43:00 > 56 -
57 57 -
58 #START TRANSACTION; 58 -
59 #CREATE TABLE rval(groupcol integer,datacol integer); 59 -
60 #INSERT INTO rval VALUES (1,42), (1,84), (2,42), (2,21); 60 -
61 [ 4 ] 61 -
62 #CREATE AGGREGATE aggrmedian(arg1 integer) RETURNS double LANGUAGE R { 62 -
63 # if (exists("arg2")) { 63 -
64 # return(aggregate(arg1, by=list(arg2), FUN=median)$x) 64 -
65 # } else { 65 -
66 # return(median(arg1)) 66 -
67 # } 67 -
68 # 68 -
69 #}; 69 -
70 #SELECT aggrmedian(datacol) FROM rval; 70 -
71 % sys. # table_name 71 -
72 # sys.L4 # table_name 72 -
73 % L # name 73 -
74 # L3 # name 74 -
75 % int # type 75 -
76 % 2 # length 76 -
77 [ 42 ] 77 -
78 #SELECT groupcol,aggrmedian(datacol) FROM rval GROUP BY groupcol; 78 -
79 % sys.rval, sys. # table_name 79 -
80 # sys.rval, sys.L4 # table_name 80 -
81 % groupcol, L # name 81 -
82 # groupcol, L3 # name 82 -
83 % int, int # type 83 -
84 % 1, 2 # length 84 -
85 [ 1, 63 ] 85 -
86 [ 2, 31 ] 86 -
87 #DROP AGGREGATE aggrmedian; 87 -
88 #DROP TABLE rval; 88 -
89 #ROLLBACK; 89 -
90 90 -
91 # 16:43:01 > 91 -
92 # 16:43:01 > "Done." 92 -
93 # 16:43:01 > 93 -
94 94 32 32