Test disallow_duplicate_column_aliases.Bug-6723.sql (id d2a25d02ca50) (out)
disallow_duplicate_column_aliases.Bug-6723.stable.err.FILTERED 2019-09-08 22:23:41.366165884 +0200disallow_duplicate_column_aliases.Bug-6723.test.err.FILTERED 2019-09-08 22:23:41.371165925 +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, 124 words, 1160 chars in all lines 4
5 5 5 5
..................
# 41 lines, 242 words,
8 8 8 8
9 # 13:22:42 > 9 ! 9 # 22:23:40 > 9
10 # 13:22:42 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33477" "--set" "mapi_usock=/var/tmp/mtest-15745/.s.monetdb.33477" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch1/dinther/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10 ! 10 # 22:23:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=32" "--set" "mapi_open=true" "--set" "mapi_port=32108" "--set" "mapi_usock=/var/tmp/mtest-817/.s.monetdb.32108" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/d2a25d02ca50-1-1-3/tests/sql/dbfarm/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10
11 # 13:22:42 > 11 ! 11 # 22:23:40 > 11
+ 12 12
+ 13 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: Duplicate column name 'a.t' 13
+ 14 #client2:!ERROR:ParseException:SQLparser:42000!SELECT: Duplicate column name 'a.L2' 14
+ 15 15
+ 16 # 22:23:41 > 16
+ 17 # 22:23:41 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-817" "--port=32108" 17
+ 18 # 22:23:41 > 18
12 12 19 19
13 13 ! 20 #~ MAPI = (monetdb) /var/tmp/mtest-817/.s.monetdb.32108 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) /var/tmp/mtest-817/.s.monetdb.32108 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