Test sequence-first-next-value.Bug-6743.sql (id f56b8f83e70a) (err)
sequence-first-next-value.Bug-6743.stable.out.FILTERED 2019-09-11 19:59:08.555562700 +0200sequence-first-next-value.Bug-6743.test.out.FILTERED 2019-09-11 19:59:08.555562700 +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 # 193 lines, 728 words, 3573 chars in all lines 4
5 5 5 5
..................
# Listening for UNIX domain connection r
23 # MonetDB/GIS module loaded 23 22 # MonetDB/GIS module loaded 22
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 23 # MonetDB/SQL module loaded 23
65 65 24 24
66 Ready. 66 -
67 67 -
68 # 11:39:46 > 68 ! 25 # 19:59:08 > 25
69 # 11:39:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-17641" "--port=32076" 69 ! 26 # 19:59:08 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=34813" 26
70 # 11:39:46 > 70 ! 27 # 19:59:08 > 27
71 71 28 28
..................
# L2 # name
96 % 1 # length 96 52 % 1 # length 52
97 [ 2 ] 97 ! 53 [ 1 ] 53
98 #select next_value_for('sys','seq'); 98 54 #select next_value_for('sys','seq'); 54
..................
# L2 # name
104 % 1 # length 104 60 % 1 # length 60
105 [ 3 ] 105 ! 61 [ 2 ] 61
106 #select get_value_for('sys','seq'); 106 62 #select get_value_for('sys','seq'); 62
..................
# L2 # name
128 % 1 # length 128 84 % 1 # length 84
129 [ 4 ] 129 ! 85 [ 3 ] 85
130 #select get_value_for('sys','seq'); 130 86 #select get_value_for('sys','seq'); 86
..................
# L2 # name
144 % 1 # length 144 100 % 1 # length 100
145 [ 5 ] 145 ! 101 [ 4 ] 101
146 #select get_value_for('sys','seq'); 146 102 #select get_value_for('sys','seq'); 102
..................
# L2 # name
179 % 1 # length 179 135 % 1 # length 135
180 [ 2 ] 180 ! 136 [ 1 ] 136
181 #select next_value_for('sys','seq'); 181 137 #select next_value_for('sys','seq'); 137
..................
# L2 # name
187 % 1 # length 187 143 % 1 # length 143
188 [ 3 ] 188 ! 144 [ 2 ] 144
189 #select get_value_for('sys','seq'); 189 145 #select get_value_for('sys','seq'); 145
..................
# L2 # name
211 % 1 # length 211 167 % 1 # length 167
212 [ 4 ] 212 ! 168 [ 3 ] 168
213 #select get_value_for('sys','seq'); 213 169 #select get_value_for('sys','seq'); 169
..................
# L2 # name
227 % 1 # length 227 183 % 1 # length 183
228 [ 5 ] 228 ! 184 [ 4 ] 184
229 #select get_value_for('sys','seq'); 229 185 #select get_value_for('sys','seq'); 185