Test sequence-restart-with-null.Bug-2648.sql (id 257bc073dc33) (err)
sequence-restart-with-null.Bug-2648.stable.out.FILTERED 2019-12-02 20:25:35.675047900 +0100sequence-restart-with-null.Bug-2648.test.out.FILTERED 2019-12-02 20:25:36.720249700 +0100
1 Statistics about stdout of test 'sequence-restart-with-null.Bug-2648` in directory 'sql/test/BugTracker-2010`: 1 1 Statistics about stdout of test 'sequence-restart-with-null.Bug-2648` in directory 'sql/test/BugTracker-2010`: 1
2 11 lines, 46 words, 216 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 153 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 11 lines, 46 words, 216 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 153 chars in lines not matching '^$|^(\| |)#` 3
4 # 50 lines, 233 words, 1893 chars in all lines 4 ! 4 # 26 lines, 119 words, 950 chars in all lines 4
5 5 5 5
..................
# SQL catalog created, loading sql scrip
26 26 24 24
27 # 20:20:11 > 27 ! 25 ! Server not ready; skipping attempt to start client! 25
28 # 20:20:11 > mclient -lsql -ftest -i -e --host=volund --port=34184 28 -
29 # 20:20:11 > 29 -
30 30 26 26
31 #create sequence testseq_2648 as integer start with 1; 31 -
32 #create table testtbl_2648 (id integer); 32 -
33 #select next value for testseq_2648; 33 -
34 % . # table_name 34 -
35 # .L2 # table_name 35 -
36 % L # name 36 -
37 # L2 # name 37 -
38 % bigint # type 38 -
39 % 1 # length 39 -
40 [ 1 ] 40 -
41 #alter sequence testseq_2648 restart with (select max(id) from testtbl_2648); 41 -
42 #select next value for testseq_2648; 42 -
43 % . # table_name 43 -
44 # .L2 # table_name 44 -
45 % L # name 45 -
46 # L2 # name 46 -
47 % bigint # type 47 -
48 % 1 # length 48 -
49 [ 2 ] 49 -
50 #drop table testtbl_2648; 50 -
51 51 27 27