Test opt_sql_append.sql (id 340fc40864f2) (err)
opt_sql_append.stable.out.Windows.FILTERED 2020-01-15 04:55:23.723910400 +0100opt_sql_append.test.out.FILTERED 2020-01-15 04:55:23.739510400 +0100
1 Statistics about stdout of test 'opt_sql_append` in directory 'monetdb5/extras/mal_optimizer_template`: 1 1 Statistics about stdout of test 'opt_sql_append` in directory 'monetdb5/extras/mal_optimizer_template`: 1
2 49 lines, 234 words, 3031 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 49 lines, 234 words, 3030 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 49 lines, 234 words, 3031 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 49 lines, 234 words, 3030 chars in lines not matching '^$|^(\| |)#` 3
4 # 172 lines, 873 words, 7886 chars in all lines 4 ! 4 # 180 lines, 927 words, 8161 chars in all lines 4
5 5 5 5
..................
#explain copy into ttt from E'a:\\tmp/xy
78 % clob # type 78 80 % clob # type 80
79 % 183 # length 79 ! 81 % 198 # length 81
80 function user.s10_0():void; 80 82 function user.s10_0():void; 82
..................
#explain copy into ttt from 'Z:/tmp/xyz'
135 % clob # type 135 140 % clob # type 140
136 % 182 # length 136 ! 141 % 197 # length 141
137 function user.s26_0():void; 137 142 function user.s26_0():void; 142
..................
#explain copy into ttt from 'Z:/tmp/xyz'
139 X_4:int := sql.mvc(); 139 144 X_4:int := sql.mvc(); 144
140 (X_26:bat[:int], X_27:bat[:int], X_28:bat[:int]) := sql.copy_from(0xXXXXXX:ptr,, "|":str, "\n":str, nil:str, "null":str, "Z:/tmp/xyz":str, -1:lng, 0:lng, 0:int, 0:int, nil:str, 0:int); 140 ! 145 (X_26:bat[:int], X_27:bat[:int], X_28:bat[:int]) := sql.copy_from(0xXXXXXX:ptr, "|":str, "\n":str, nil:str, "null":str, "Z:/tmp/xyz":str, -1:lng, 0:lng, 0:int, 0:int, nil:str, 0:int); 145
141 # the original non-normalized output was: (X_26:bat[:int], X_27:bat[:int], X_28:bat[:int]) := sql.copy_from(0x2e73790:ptr,, "|":str, "\n":str, nil:str, "null":str, "Z:/tmp/xyz":str, -1:lng, 0:lng, 0:int, 0:int, nil:str, 0:int); 141 ! 146 # the original non-normalized output was: (X_26:bat[:int], X_27:bat[:int], X_28:bat[:int]) := sql.copy_from(0x00000000027CE180:ptr, "|":str, "\n":str, nil:str, "null":str, "Z:/tmp/xyz":str, -1:lng, 0:lng, 0:int, 0:int, nil:str, 0:int); 146
142 X_30:int := sql.append(X_4:int, "sys":str, "ttt":str, "a":str, X_26:bat[:int]); 142 147 X_30:int := sql.append(X_4:int, "sys":str, "ttt":str, "a":str, X_26:bat[:int]); 147