Test disallow_duplicate_column_aliases.Bug-6723.sql (id 7a4f3daf6d73) (err)
disallow_duplicate_column_aliases.Bug-6723.stable.out.FILTERED 2020-03-26 23:01:11.221802040 +0100disallow_duplicate_column_aliases.Bug-6723.test.out.FILTERED 2020-03-26 23:01:11.222802024 +0100
1 Statistics about stdout of test 'disallow_duplicate_column_aliases.Bug-6723` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stdout of test 'disallow_duplicate_column_aliases.Bug-6723` in directory 'sql/test/BugTracker-2019`: 1
2 1 lines, 8 words, 107 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 21 lines, 114 words, 479 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 107 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 21 lines, 114 words, 479 chars in lines not matching '^$|^(\| |)#` 3
4 # 29 lines, 145 words, 1291 chars in all lines 4 ! 4 # 40 lines, 201 words, 904 chars in all lines 4
5 5 5 5
..................
# 29 lines, 145 words,
8 8 8 8
9 # 13:22:42 > 9 ! 9 # 23:01:11 > 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 # 23:01:11 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-1768" "--port=35116" 10
11 # 13:22:42 > 11 ! 11 # 23:01:11 > 11
12 12 ! 12 12
13 # MonetDB 5 server v11.33.4 (hg id: 0e77729ef717+) 13 ! 13 #select 1 as T, 2 as T; 13
14 # This is an unreleased version 14 ! 14 % ., . # table_name 14
15 # Serving database 'mTests_sql_test_BugTracker-2019', using 4 threads 15 ! 15 # .L2, .L4 # table_name 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers 16 ! 16 % t, t # name 16
17 # Found 31.305 GiB available main-memory. 17 ! 17 % tinyint, tinyint # type 17
18 # Copyright (c) 1993 - July 2008 CWI. 18 ! 18 % 1, 1 # length 18
19 # Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved 19 ! 19 [ 1, 2 ] 19
20 # Visit https://www.monetdb.org/ for further information 20 ! 20 #with wa as (select 1 as T, 2 as T) select wa.* from wa; 20
21 # Listening for connection requests on mapi:monetdb://catskill.da.cwi.nl:33477/ 21 ! 21 % .wa, .wa # table_name 21
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-15745/.s.monetdb.33477 22 ! 22 % t, t # name 22
23 # MonetDB/GIS module loaded 23 ! 23 % tinyint, tinyint # type 23
24 # MonetDB/SQL module loaded 24 ! 24 % 1, 1 # length 24
25 25 ! 25 [ 1, 1 ] 25
26 # 13:22:43 > 26 ! 26 #select 1,2,3 as "L2"; 26
27 # 13:22:43 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-15745" "--port=33477" 27 ! 27 % ., ., . # table_name 27
28 # 13:22:43 > 28 ! 28 # .L2, .L4, .L6 # table_name 28
29 29 ! 29 % L, L, L # name 29
30 30 ! 30 # L2, L4, L2 # name 30
31 # 13:22:43 > 31 ! 31 % tinyint, tinyint, tinyint # type 31
32 # 13:22:43 > "Done." 32 ! 32 % 1, 1, 1 # length 32
33 # 13:22:43 > 33 ! 33 [ 1, 2, 3 ] 33
+ 34 #with wa as (select 1,2,3 as "L2") select wa.* from wa; 34
+ 35 % .wa, .wa, .wa # table_name 35
+ 36 % L, L, L # name 36
+ 37 # L2, L4, L2 # name 37
+ 38 % tinyint, tinyint, tinyint # type 38
+ 39 % 1, 1, 1 # length 39
+ 40 [ 1, 2, 1 ] 40
+ 41 41
+ 42 # 23:01:11 > 42
+ 43 # 23:01:11 > "Done." 43
+ 44 # 23:01:11 > 44
34 34 45 45