Test disallow_duplicate_column_aliases.Bug-6723.sql (id 7617234e528d) (out)
disallow_duplicate_column_aliases.Bug-6723.stable.err.FILTERED 2019-09-21 04:19:14.128785300 +0200disallow_duplicate_column_aliases.Bug-6723.test.err.FILTERED 2019-09-21 04:19:14.144385300 +0200
1 Statistics about stderr of test 'disallow_duplicate_column_aliases.Bug-6723` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stderr of test 'disallow_duplicate_column_aliases.Bug-6723` in directory 'sql/test/BugTracker-2019`: 1
2 19 lines, 159 words, 843 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 7 lines, 51 words, 319 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 19 lines, 159 words, 843 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 7 lines, 51 words, 319 chars in lines not matching '^$|^(\| |)#` 3
4 # 41 lines, 242 words, 1715 chars in all lines 4 ! 4 # 28 lines, 123 words, 1063 chars in all lines 4
5 5 5 5
..................
# 13:22:42 >
12 12 20 20
13 13 ! 21 #~ MAPI = monetdb@LAB03:33969 21
14 # 13:22:43 > 14 -
15 # 13:22:43 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-15745" "--port=33477" 15 -
16 # 13:22:43 > 16 -
17 17 -
18 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 18 -
19 QUERY = select 1 as T, 2 as T; 19 -
20 ERROR = !SELECT: Duplicate column name or alias 'T' not allowed 20 -
21 CODE = 42000 21 -
22 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 22 -
23 QUERY = select a.* from (select 1 as T, 2 as T) a; 23 22 QUERY = select a.* from (select 1 as T, 2 as T) a; 22
24 ERROR = !SELECT: Duplicate column name or alias 'T' not allowed 24 ! 23 ERROR = !SELECT: Duplicate column name 'a.t' 23
25 CODE = 42000 25 -
26 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 26 -
27 QUERY = with wa as (select 1 as T, 2 as T) select wa.* from wa; 27 -
28 ERROR = !SELECT: Duplicate column name or alias 'T' not allowed 28 -
29 CODE = 42000 29 24 CODE = 42000 24
30 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 30 ! 25 #~ MAPI = monetdb@LAB03:33969 25
31 QUERY = select 1,2,3 as "L2"; 31 -
32 ERROR = !SELECT: Duplicate column name or alias 'L2' not allowed 32 -
33 CODE = 42000 33 -
34 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 34 -
35 QUERY = select a.* from (select 1,2,3 as "L2") a; 35 26 QUERY = select a.* from (select 1,2,3 as "L2") a; 26
36 ERROR = !SELECT: Duplicate column name or alias 'L2' not allowed 36 ! 27 ERROR = !SELECT: Duplicate column name 'a.L2' 27
37 CODE = 42000 37 -
38 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 38 -
39 QUERY = with wa as (select 1,2,3 as "L2") select wa.* from wa; 39 -
40 ERROR = !SELECT: Duplicate column name or alias 'L2' not allowed 40 -
41 CODE = 42000 41 28 CODE = 42000 28