Test cte-union.Bug-6755.sql (id 3c6cbe78e1fe) (out)
cte-union.Bug-6755.stable.err.FILTERED 2019-09-08 13:22:26.222282900 +0200cte-union.Bug-6755.test.err.FILTERED 2019-09-08 13:22:26.222282900 +0200
+ 1 Statistics about stderr of test 'cte-union.Bug-6755` in directory 'sql/test/BugTracker-2019`: 1
+ 2 22 lines, 108 words, 755 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 22 lines, 108 words, 755 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 40 lines, 161 words, 1231 chars in all lines 4
+ 5 5
+ 6 stderr of test 'cte-union.Bug-6755` in directory 'sql/test/BugTracker-2019` itself: 6
+ 7 7
+ 8 8
+ 9 # 13:22:25 > 9
+ 10 # 13:22:25 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32499" "--forcemito" "--dbpath=C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" 10
+ 11 # 13:22:25 > 11
+ 12 12
+ 13 could not find L22.Carrier 13
+ 14 L17.Carrier 14
+ 15 Assertion failed: s, file .\..\..\..\..\sql\backends\monet5\rel_bin.c, line 730 15
+ 16 16
+ 17 Aborted 17
+ 18 18
+ 19 # 13:22:26 > 19
+ 20 # 13:22:26 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=32499" 20
+ 21 # 13:22:26 > 21
+ 22 22
+ 23 #~ MAPI = monetdb@WIN2K12R2:32499 23
+ 24 ACTION= read_line 24
+ 25 QUERY = WITH t1 AS ( 25
+ 26 SELECT "Carrier", CAST (FLOOR("CRSDepTime"%2400/100) AS INT) AS "Hour", 26
+ 27 CAST(AVG("ArrDelay") AS DECIMAL(8,2)) AS "PredictedArrDelay" 27
+ 28 FROM ontime 28
+ 29 WHERE "Year" = 2007 AND "Month" = 10 AND "DayofMonth" = 24 29
+ 30 GROUP BY "Carrier", "Hour" 30
+ 31 ), 31
+ 32 t2 AS ( 32
+ 33 SELECT t."Carrier", tmp.* 33
+ 34 FROM tmp, (SELECT DISTINCT "Carrier" FROM t1) AS t 34
+ 35 ) 35
+ 36 SELECT "Carrier", "Hour", SUM("PredictedArrDelay") 36
+ 37 FROM (SELECT * FROM t1 UNION SELECT * FROM t2) AS t 37
+ 38 GROUP BY "Carrier", "Hour" 38
+ 39 ORDER BY "Carrier", "Hour"; 39
+ 40 ERROR = !Connection terminated during read line 40
+ 41 41
+ 42 # 13:22:26 > 42
+ 43 # 13:22:26 > "Done." 43
+ 44 # 13:22:26 > 44
+ 45 45