Test wlr20.py (id f56b8f83e70a) (err)
wlr20.stable.out.FILTERED 2019-09-11 21:51:33.552233600 +0200wlr20.test.out.FILTERED 2019-09-11 21:51:33.552233600 +0200
1 Statistics about stdout of test 'wlr20` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr20` in directory 'sql/test/wlcr`: 1
2 21 lines, 100 words, 396 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 28 lines, 87 words, 1099 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 21 lines, 100 words, 396 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 28 lines, 87 words, 1099 chars in lines not matching '^$|^(\| |)#` 3
4 # 57 lines, 247 words, 1926 chars in all lines 4 ! 4 # 91 lines, 377 words, 3531 chars in all lines 4
5 5 5 5
..................
# MonetDB/GIS module loaded
24 # MonetDB/SQL module loaded 24 54 # MonetDB/SQL module loaded 54
25 #call replicate('mTests_sql_test_wlcr',1); 25 ! 55 #replay log file:C:\monettesting\f56b8f83e70a-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000000 55
26 #Waiting for replay scheduler to stop 26 ! 56 #run tlimit tag 2019-09-12T02:51:27.000 56
27 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 27 ! 57 function user.wlr():void; 57
28 #select * from tmp; 28 ! 58 wlr.transaction(0:lng, "2019-09-12T02:51:27.000":str, "monetdb":str); 58
29 % sys.tmp, sys.tmp # table_name 29 ! 59 wlr.catalog("create table tmp0(i int, s string);":str); 59
30 % i, s # name 30 ! 60 wlr.commit(); 60
31 % int, clob # type 31 ! 61 end user.wlr; 61
32 % 1, 0 # length 32 ! 62 #replay log file:C:\monettesting\f56b8f83e70a-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000001 62
+ 63 #run tlimit tag 2019-09-12T02:51:27.000 63
+ 64 function user.wlr():void; 64
+ 65 wlr.transaction(1:lng, "2019-09-12T02:51:27.000":str, "monetdb":str); 65
+ 66 wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 66
+ 67 wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 67
+ 68 wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 68
+ 69 wlr.commit(); 69
+ 70 end user.wlr; 70
+ 71 #replay log file:C:\monettesting\f56b8f83e70a-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\\mTests_sql_test_wlcr_000000000002 71
+ 72 #run tlimit tag 2019-09-12T02:51:27.000 72
+ 73 function user.wlr():void; 73
+ 74 wlr.transaction(2:lng, "2019-09-12T02:51:27.000":str, "monetdb":str); 74
+ 75 wlr.catalog("drop table tmp0;":str); 75
+ 76 wlr.commit(); 76
+ 77 end user.wlr; 77
+ 78 function user.SQLstatement():void; 78
+ 79 wlr.catalog("create table tmp(i int, s string);":str); 79
+ 80 wlr.commit(); 80
+ 81 end user.SQLstatement; 81
+ 82 function user.SQLstatement():void; 82
+ 83 wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 83
+ 84 wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 84
+ 85 wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 85
+ 86 wlr.commit(); 86
+ 87 end user.SQLstatement; 87
33 #call replicate('mTests_sql_test_wlcr',2); 33 88 #call replicate('mTests_sql_test_wlcr',2); 88
34 #Waiting for replay scheduler to stop 34 ! 89 #Waiting for replay scheduler to stop at 89
35 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000001 35 -
36 #select * from tmp; 36 -
37 % sys.tmp, sys.tmp # table_name 37 -
38 % i, s # name 38 -
39 % int, clob # type 39 -
40 % 1, 5 # length 40 -
41 [ 1, "hello" ] 41 -
42 [ 2, "world" ] 42 -
43 #call replicate('mTests_sql_test_wlcr',4); 43 90 #call replicate('mTests_sql_test_wlcr',4); 90
44 #Waiting for replay scheduler to stop 44 ! 91 #Waiting for replay scheduler to stop at 91
45 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000002 45 ! 92 92
46 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs//mTests_sql_test_wlcr_000000000003 46 ! 93 # 21:51:33 > 93
47 #select * from tmp; 47 ! 94 # 21:51:33 > "Done." 94
48 % sys.tmp, sys.tmp # table_name 48 ! 95 # 21:51:33 > 95
49 % i, s # name 49 -
50 % int, clob # type 50 -
51 % 1, 5 # length 51 -
52 [ 1, "hello" ] 52 -
53 [ 2, "world" ] 53 -
54 [ 3, "blah" ] 54 -
55 [ 4, "bloh" ] 55 -
56 [ 5, "red" ] 56 -
57 [ 6, "fox" ] 57 -
58 58 -
59 # 13:22:30 > 59 -
60 # 13:22:30 > "Done." 60 -
61 # 13:22:30 > 61 -
62 62 96 96