Test disallow_duplicate_column_aliases.Bug-6723.sql (id fe8055a86502) (out)
disallow_duplicate_column_aliases.Bug-6723.stable.err.FILTERED 2019-09-12 12:36:39.077173370 +0200disallow_duplicate_column_aliases.Bug-6723.test.err.FILTERED 2019-09-12 12:36:39.079173388 +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, 129 words, 1251 chars in all lines 4
5 5 5 5
..................
# 41 lines, 242 words,
8 8 8 8
9 # 13:22:42 > 9 ! 9 # 12:36:38 > 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 # 12:36:38 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=32" "--set" "mapi_open=true" "--set" "mapi_port=37210" "--set" "mapi_usock=/var/tmp/mtest-22380/.s.monetdb.37210" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/fe8055a86502-1-1-3/tests/sql/dbfarm/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10
11 # 13:22:42 > 11 ! 11 # 12:36:38 > 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 #main thread:!ERROR:MALException:client.quit:Server stopped 15
+ 16 16
+ 17 # 12:36:39 > 17
+ 18 # 12:36:39 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-22380" "--port=37210" 18
+ 19 # 12:36:39 > 19
12 12 20 20
13 13 ! 21 #~ MAPI = (monetdb) /var/tmp/mtest-22380/.s.monetdb.37210 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) /var/tmp/mtest-22380/.s.monetdb.37210 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