Test sequence-first-next-value.Bug-6743.sql (id ae96662f93e6) (err)
sequence-first-next-value.Bug-6743.stable.out.FILTERED 2019-09-09 20:57:36.246833511 +0200sequence-first-next-value.Bug-6743.test.out.FILTERED 2019-09-09 20:57:36.251833551 +0200
1 Statistics about stdout of test 'sequence-first-next-value.Bug-6743` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stdout of test 'sequence-first-next-value.Bug-6743` in directory 'sql/test/BugTracker-2019`: 1
2 102 lines, 389 words, 1265 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 101 lines, 388 words, 1259 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 102 lines, 389 words, 1265 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 101 lines, 388 words, 1259 chars in lines not matching '^$|^(\| |)#` 3
4 # 237 lines, 953 words, 5313 chars in all lines 4 ! 4 # 194 lines, 744 words, 3831 chars in all lines 4
5 5 5 5
..................
# Listening for UNIX domain connection r
23 # MonetDB/GIS module loaded 23 23 # MonetDB/GIS module loaded 23
24 # SQL catalog created, loading sql scripts once 24 -
25 # loading sql script: 09_like.sql 25 -
26 # loading sql script: 10_math.sql 26 -
27 # loading sql script: 11_times.sql 27 -
28 # loading sql script: 12_url.sql 28 -
29 # loading sql script: 13_date.sql 29 -
30 # loading sql script: 14_inet.sql 30 -
31 # loading sql script: 15_querylog.sql 31 -
32 # loading sql script: 16_tracelog.sql 32 -
33 # loading sql script: 17_temporal.sql 33 -
34 # loading sql script: 18_index.sql 34 -
35 # loading sql script: 20_vacuum.sql 35 -
36 # loading sql script: 21_dependency_views.sql 36 -
37 # loading sql script: 22_clients.sql 37 -
38 # loading sql script: 23_skyserver.sql 38 -
39 # loading sql script: 25_debug.sql 39 -
40 # loading sql script: 26_sysmon.sql 40 -
41 # loading sql script: 27_rejects.sql 41 -
42 # loading sql script: 39_analytics.sql 42 -
43 # loading sql script: 39_analytics_hge.sql 43 -
44 # loading sql script: 40_geom.sql 44 -
45 # loading sql script: 40_json.sql 45 -
46 # loading sql script: 40_json_hge.sql 46 -
47 # loading sql script: 41_md5sum.sql 47 -
48 # loading sql script: 45_uuid.sql 48 -
49 # loading sql script: 46_profiler.sql 49 -
50 # loading sql script: 51_sys_schema_extension.sql 50 -
51 # loading sql script: 60_wlcr.sql 51 -
52 # loading sql script: 72_fits.sql 52 -
53 # loading sql script: 74_netcdf.sql 53 -
54 # loading sql script: 75_lidar.sql 54 -
55 # loading sql script: 75_shp.sql 55 -
56 # loading sql script: 75_storagemodel.sql 56 -
57 # loading sql script: 80_statistics.sql 57 -
58 # loading sql script: 80_udf.sql 58 -
59 # loading sql script: 80_udf_hge.sql 59 -
60 # loading sql script: 85_bam.sql 60 -
61 # loading sql script: 90_generator.sql 61 -
62 # loading sql script: 90_generator_hge.sql 62 -
63 # loading sql script: 99_system.sql 63 -
64 # MonetDB/SQL module loaded 64 24 # MonetDB/SQL module loaded 24
65 65 25 25
66 Ready. 66 -
67 67 -
68 # 11:39:46 > 68 ! 26 # 20:57:36 > 26
69 # 11:39:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-17641" "--port=32076" 69 ! 27 # 20:57:36 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-12878" "--port=30580" 27
70 # 11:39:46 > 70 ! 28 # 20:57:36 > 28
71 71 29 29
..................
# L2 # name
96 % 1 # length 96 53 % 1 # length 53
97 [ 2 ] 97 ! 54 [ 1 ] 54
98 #select next_value_for('sys','seq'); 98 55 #select next_value_for('sys','seq'); 55
..................
# L2 # name
104 % 1 # length 104 61 % 1 # length 61
105 [ 3 ] 105 ! 62 [ 2 ] 62
106 #select get_value_for('sys','seq'); 106 63 #select get_value_for('sys','seq'); 63
..................
# L2 # name
128 % 1 # length 128 85 % 1 # length 85
129 [ 4 ] 129 ! 86 [ 3 ] 86
130 #select get_value_for('sys','seq'); 130 87 #select get_value_for('sys','seq'); 87
..................
# L2 # name
144 % 1 # length 144 101 % 1 # length 101
145 [ 5 ] 145 ! 102 [ 4 ] 102
146 #select get_value_for('sys','seq'); 146 103 #select get_value_for('sys','seq'); 103
..................
# L2 # name
179 % 1 # length 179 136 % 1 # length 136
180 [ 2 ] 180 ! 137 [ 1 ] 137
181 #select next_value_for('sys','seq'); 181 138 #select next_value_for('sys','seq'); 138
..................
# L2 # name
187 % 1 # length 187 144 % 1 # length 144
188 [ 3 ] 188 ! 145 [ 2 ] 145
189 #select get_value_for('sys','seq'); 189 146 #select get_value_for('sys','seq'); 146
..................
# L2 # name
211 % 1 # length 211 168 % 1 # length 168
212 [ 4 ] 212 ! 169 [ 3 ] 169
213 #select get_value_for('sys','seq'); 213 170 #select get_value_for('sys','seq'); 170
..................
# L2 # name
227 % 1 # length 227 184 % 1 # length 184
228 [ 5 ] 228 ! 185 [ 4 ] 185
229 #select get_value_for('sys','seq'); 229 186 #select get_value_for('sys','seq'); 186