Changeset: e255a5fa7c7f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e255a5fa7c7f
Modified Files:
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
Branch: sq2default
Log Message:
approved output
diffs (128 lines):
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
@@ -74,67 +74,57 @@ join (
| table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as "b"."id",
"bidder"."open_auction_id" NOT NULL as "b"."open_auction_id", "bidder"."date"
NOT NULL as "b"."date", "bidder"."time" NOT NULL as "b"."time",
"bidder"."personref" NOT NULL as "b"."personref", "bidder"."increase" NOT NULL
as "b"."increase", "bidder"."%TID%" NOT NULL as "b"."%TID%" ] COUNT
) [ "o"."open_auction_id" NOT NULL = "b"."open_auction_id" NOT NULL ]
REF 2 (2)
-group by (
+join (
+| & REF 1 ,
| project (
-| | & REF 1
-| ) [ "o"."open_auction_id" NOT NULL ]
-) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT NULL ]
-REF 3 (2)
+| | group by (
+| | | project (
+| | | | join (
+| | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as "b3"."id",
"bidder"."increase" NOT NULL as "b3"."increase" ] COUNT ,
+| | | | | project (
+| | | | | | group by (
+| | | | | | | join (
+| | | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b3a"."id", "bidder"."open_auction_id" NOT NULL as "b3a"."open_auction_id" ]
COUNT ,
+| | | | | | | | group by (
+| | | | | | | | | project (
+| | | | | | | | | | & REF 1
+| | | | | | | | | ) [ "o"."open_auction_id" NOT NULL ]
+| | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id"
NOT NULL ]
+| | | | | | | ) [ "b3a"."open_auction_id" NOT NULL = !!!FREE!!!
"o"."open_auction_id" NOT NULL ]
+| | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.min no nil ("b3a"."id"
NOT NULL HASHCOL ) NOT NULL as "%1"."%1", "o"."open_auction_id" NOT NULL ]
+| | | | | ) [ "o"."open_auction_id" NOT NULL, "%1"."%1" NOT NULL ]
+| | | | ) [ "b3"."id" NOT NULL HASHCOL = "%1"."%1" NOT NULL ]
+| | | ) [ "o"."open_auction_id" NOT NULL, "b3"."increase" NOT NULL as
"%2"."%2" ]
+| | ) [ "o"."open_auction_id" NOT NULL ] [ sys.zero_or_one("%2"."%2" NOT NULL)
NOT NULL as "%3"."%3", "o"."open_auction_id" NOT NULL ]
+| ) [ "%3"."%3" NOT NULL, "o"."open_auction_id" NOT NULL as "%25"."%25" ]
+) [ "o"."open_auction_id" NOT NULL = "%25"."%25" NOT NULL ]
project (
-| join (
-| | & REF 1 ,
-| | project (
-| | | semijoin (
-| | | | project (
-| | | | | crossproduct (
-| | | | | | & REF 2 ,
-| | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as "b3"."id",
"bidder"."increase" NOT NULL as "b3"."increase" ] COUNT
-| | | | | ) [ ]
-| | | | ) [ "o"."open_auction_id" NOT NULL, "b3"."id" NOT NULL HASHCOL ,
"b3"."increase" NOT NULL ],
-| | | | project (
-| | | | | group by (
+| select (
+| | join (
+| | | & REF 2 ,
+| | | project (
+| | | | group by (
+| | | | | project (
| | | | | | join (
-| | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b3a"."id", "bidder"."open_auction_id" NOT NULL as "b3a"."open_auction_id" ]
COUNT ,
-| | | | | | | & REF 2
-| | | | | | ) [ "b3a"."open_auction_id" NOT NULL = "o"."open_auction_id" NOT
NULL ]
-| | | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.min no nil ("b3a"."id"
NOT NULL HASHCOL ) NOT NULL as "L2"."L2", "o"."open_auction_id" NOT NULL ]
-| | | | ) [ "L2"."L2" NOT NULL as "L3"."L3", "o"."open_auction_id" NOT NULL as
"L30"."L30" ]
-| | | ) [ "b3"."id" NOT NULL HASHCOL = "L3"."L3" NOT NULL,
"o"."open_auction_id" NOT NULL =* "L30"."L30" NOT NULL ]
-| | ) [ "b3"."increase" NOT NULL, "o"."open_auction_id" NOT NULL as
"L22"."L22" ]
-| ) [ "o"."open_auction_id" NOT NULL = "L22"."L22" NOT NULL ]
-) [ "o"."id" NOT NULL HASHCOL , "o"."open_auction_id" NOT NULL, "o"."initial"
NOT NULL, "o"."reserve" NOT NULL, "o"."aktuell" NOT NULL, "o"."privacy" NOT
NULL, "o"."itemref" NOT NULL, "o"."seller" NOT NULL, "o"."quantity" NOT NULL,
"o"."type" NOT NULL, "o"."start" NOT NULL, "o"."ende" NOT NULL, "o"."%TID%" NOT
NULL, "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date"
NOT NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT
NULL, "b"."%TID%" NOT NULL, "b3"."increase" NOT NULL ]
-REF 4 (2)
-group by (
-| project (
-| | & REF 3
-| ) [ "o"."open_auction_id" NOT NULL ]
-) [ "o"."open_auction_id" NOT NULL ] [ "o"."open_auction_id" NOT NULL ]
-project (
-| semijoin (
-| | & REF 3 ,
-| | project (
-| | | group by (
-| | | | project (
-| | | | | semijoin (
-| | | | | | project (
-| | | | | | | crossproduct (
-| | | | | | | | & REF 4 ,
-| | | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b2"."id", "bidder"."increase" NOT NULL as "b2"."increase" ] COUNT
-| | | | | | | ) [ ]
-| | | | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."id" NOT NULL HASHCOL ,
"b2"."increase" NOT NULL ],
-| | | | | | project (
-| | | | | | | group by (
-| | | | | | | | join (
-| | | | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b2a"."id", "bidder"."open_auction_id" NOT NULL as "b2a"."open_auction_id" ]
COUNT ,
-| | | | | | | | | & REF 4
-| | | | | | | | ) [ "b2a"."open_auction_id" NOT NULL = "o"."open_auction_id"
NOT NULL ]
-| | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.max no nil
("b2a"."id" NOT NULL HASHCOL ) NOT NULL as "L5"."L5", "o"."open_auction_id" NOT
NULL ]
-| | | | | | ) [ "L5"."L5" NOT NULL as "L6"."L6", "o"."open_auction_id" NOT
NULL as "L53"."L53" ]
-| | | | | ) [ "b2"."id" NOT NULL HASHCOL = "L6"."L6" NOT NULL,
"o"."open_auction_id" NOT NULL =* "L53"."L53" NOT NULL ]
-| | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."increase" NOT NULL as
"L7"."L7" ]
-| | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.zero_or_one("L7"."L7" NOT
NULL) NOT NULL as "L10"."L10", "o"."open_auction_id" NOT NULL ]
-| | ) [ "L10"."L10" NOT NULL, "o"."open_auction_id" NOT NULL as "L41"."L41" ]
-| ) [ sys.sql_mul("b3"."increase" NOT NULL, double "2") <= "L10"."L10" NOT
NULL, "o"."open_auction_id" NOT NULL = "L41"."L41" NOT NULL ]
+| | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b2"."id", "bidder"."increase" NOT NULL as "b2"."increase" ] COUNT ,
+| | | | | | | project (
+| | | | | | | | group by (
+| | | | | | | | | join (
+| | | | | | | | | | table(sys.bidder) [ "bidder"."id" NOT NULL HASHCOL as
"b2a"."id", "bidder"."open_auction_id" NOT NULL as "b2a"."open_auction_id" ]
COUNT ,
+| | | | | | | | | | group by (
+| | | | | | | | | | | project (
+| | | | | | | | | | | | & REF 2
+| | | | | | | | | | | ) [ "o"."open_auction_id" NOT NULL ]
+| | | | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [
"o"."open_auction_id" NOT NULL ]
+| | | | | | | | | ) [ "b2a"."open_auction_id" NOT NULL = !!!FREE!!!
"o"."open_auction_id" NOT NULL ]
+| | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.max no nil
("b2a"."id" NOT NULL HASHCOL ) NOT NULL as "%4"."%4", "o"."open_auction_id" NOT
NULL ]
+| | | | | | | ) [ "o"."open_auction_id" NOT NULL, "%4"."%4" NOT NULL ]
+| | | | | | ) [ "b2"."id" NOT NULL HASHCOL = "%4"."%4" NOT NULL ]
+| | | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."increase" NOT NULL as
"%5"."%5" ]
+| | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.zero_or_one("%5"."%5" NOT
NULL) NOT NULL as "%6"."%6", "o"."open_auction_id" NOT NULL ]
+| | | ) [ "%6"."%6" NOT NULL, "o"."open_auction_id" NOT NULL as "%46"."%46" ]
+| | ) [ "o"."open_auction_id" NOT NULL = "%46"."%46" NOT NULL ]
+| ) [ sys.sql_mul("%3"."%3" NOT NULL, double "2") <= "%6"."%6" NOT NULL ]
) [ "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date" NOT
NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT NULL ]
#Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min(b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX(b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
% sys.b, sys.b, sys.b, sys.b, sys.b, sys.b # table_name
@@ -160,7 +150,7 @@ project (
#) t
#where b3_increase * 2 <= b2_increase
#order by date, time;
-% sys.t, sys.t, sys.t, sys.t, sys.t, sys.t, .t, .t # table_name
+% .t, .t, .t, .t, .t, .t, .t, .t # table_name
% id, open_auction_id, date, time, personref, increase,
b3_increase, b2_increase # name
% int, varchar, varchar, varchar, varchar,
double, double, double # type
% 2, 13, 10, 8, 8, 24, 24, 24 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
