Test disallow_duplicate_column_aliases.Bug-6723.sql (id 66579176a253) (out)
disallow_duplicate_column_aliases.Bug-6723.stable.err.FILTERED 2019-09-21 08:05:27.909728700 +0200disallow_duplicate_column_aliases.Bug-6723.test.err.FILTERED 2019-09-21 08:05:27.909728700 +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 # 27 lines, 118 words, 980 chars in all lines 4
5 5 5 5
..................
# 13:22:42 >
12 12 19 19
13 13 ! 20 #~ MAPI = monetdb@LAB03:37000 20
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 21 QUERY = select a.* from (select 1 as T, 2 as T) a; 21
24 ERROR = !SELECT: Duplicate column name or alias 'T' not allowed 24 ! 22 ERROR = !SELECT: Duplicate column name 'a.t' 22
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 23 CODE = 42000 23
30 #~ MAPI = (monetdb) /var/tmp/mtest-15745/.s.monetdb.33477 30 ! 24 #~ MAPI = monetdb@LAB03:37000 24
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 25 QUERY = select a.* from (select 1,2,3 as "L2") a; 25
36 ERROR = !SELECT: Duplicate column name or alias 'L2' not allowed 36 ! 26 ERROR = !SELECT: Duplicate column name 'a.L2' 26
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 27 CODE = 42000 27