Test crash.Bug-3736.sql (id c952acc49888) (err)
crash.Bug-3736.stable.out.FILTERED 2019-12-03 07:16:47.742876570 +0100crash.Bug-3736.test.out.FILTERED 2019-12-03 07:16:47.752877026 +0100
1 Statistics about stdout of test 'crash.Bug-3736` in directory 'sql/test/BugTracker-2015`: 1 1 Statistics about stdout of test 'crash.Bug-3736` in directory 'sql/test/BugTracker-2015`: 1
2 103 lines, 1165 words, 6842 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 89 lines, 1053 words, 6029 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 103 lines, 1165 words, 6842 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 89 lines, 1053 words, 6029 chars in lines not matching '^$|^(\| |)#` 3
4 # 183 lines, 1713 words, 11148 chars in all lines 4 ! 4 # 167 lines, 1543 words, 9847 chars in all lines 4
5 5 5 5
..................
#plan Select b.* FROM open_auctions o, b
105 | | | | | ) [ "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 ] 105 104 | | | | | ) [ "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 ] 104
106 | | | | ) [ "L2"."L2" NOT NULL, "o"."open_auction_id" NOT NULL as "L26"."L26" ] 106 ! 105 | | | | ) [ "L2"."L2" NOT NULL as "L3"."L3", "o"."open_auction_id" NOT NULL as "L30"."L30" ] 105
107 | | | ) [ "b3"."id" NOT NULL HASHCOL = "L2"."L2" NOT NULL, "o"."open_auction_id" NOT NULL =* "L26"."L26" NOT NULL ] 107 ! 106 | | | ) [ "b3"."id" NOT NULL HASHCOL = "L3"."L3" NOT NULL, "o"."open_auction_id" NOT NULL =* "L30"."L30" NOT NULL ] 106
108 | | ) [ "b3"."increase" NOT NULL, "o"."open_auction_id" NOT NULL as "L20"."L20" ] 108 ! 107 | | ) [ "b3"."increase" NOT NULL, "o"."open_auction_id" NOT NULL as "L22"."L22" ] 107
109 | ) [ "o"."open_auction_id" NOT NULL = "L20"."L20" NOT NULL ] 109 ! 108 | ) [ "o"."open_auction_id" NOT NULL = "L22"."L22" NOT NULL ] 108
110 ) [ "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 ] 110 109 ) [ "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 ] 109
..................
#plan Select b.* FROM open_auctions o, b
135 | | | | | | | | ) [ "b2a"."open_auction_id" NOT NULL = "o"."open_auction_id" NOT NULL ] 135 134 | | | | | | | | ) [ "b2a"."open_auction_id" NOT NULL = "o"."open_auction_id" NOT NULL ] 134
136 | | | | | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.max no nil ("b2a"."id" NOT NULL HASHCOL ) NOT NULL as "L4"."L4", "o"."open_auction_id" NOT NULL ] 136 ! 135 | | | | | | | ) [ "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 ] 135
137 | | | | | | ) [ "L4"."L4" NOT NULL, "o"."open_auction_id" NOT NULL as "L51"."L51" ] 137 ! 136 | | | | | | ) [ "L5"."L5" NOT NULL as "L6"."L6", "o"."open_auction_id" NOT NULL as "L53"."L53" ] 136
138 | | | | | ) [ "b2"."id" NOT NULL HASHCOL = "L4"."L4" NOT NULL, "o"."open_auction_id" NOT NULL =* "L51"."L51" NOT NULL ] 138 ! 137 | | | | | ) [ "b2"."id" NOT NULL HASHCOL = "L6"."L6" NOT NULL, "o"."open_auction_id" NOT NULL =* "L53"."L53" NOT NULL ] 137
139 | | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."increase" NOT NULL as "L5"."L5" ] 139 ! 138 | | | | ) [ "o"."open_auction_id" NOT NULL, "b2"."increase" NOT NULL as "L7"."L7" ] 138
140 | | | ) [ "o"."open_auction_id" NOT NULL ] [ sys.zero_or_one("L5"."L5" NOT NULL) NOT NULL as "L6"."L6", "o"."open_auction_id" NOT NULL ] 140 ! 139 | | | ) [ "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 ] 139
141 | | ) [ "L6"."L6" NOT NULL, "o"."open_auction_id" NOT NULL as "L37"."L37" ] 141 ! 140 | | ) [ "L10"."L10" NOT NULL, "o"."open_auction_id" NOT NULL as "L41"."L41" ] 140
142 | ) [ sys.sql_mul("b3"."increase" NOT NULL, double "2") <= "L6"."L6" NOT NULL, "o"."open_auction_id" NOT NULL = "L37"."L37" NOT NULL ] 142 ! 141 | ) [ sys.sql_mul("b3"."increase" NOT NULL, double "2") <= "L10"."L10" NOT NULL, "o"."open_auction_id" NOT NULL = "L41"."L41" NOT NULL ] 141
143 ) [ "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 ] 143 142 ) [ "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 ] 142
144 #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; 144 -
145 % sys.b, sys.b, sys.b, sys.b, sys.b, sys.b # table_name 145 -
146 % id, open_auction_id, date, time, personref, increase # name 146 -
147 % int, varchar, varchar, varchar, varchar, double # type 147 -
148 % 2, 13, 10, 8, 8, 24 # length 148 -
149 [ 11, "open_auction1", "05/21/2001", "08:02:16", "person5", 12 ] 149 -
150 [ 8, "open_auction1", "06/22/1999", "12:43:47", "person19", 15 ] 150 -
151 [ 29, "open_auction5", "07/07/2000", "08:53:00", "person15", 6 ] 151 -
152 [ 30, "open_auction5", "08/06/2001", "10:16:15", "person13", 4.5 ] 152 -
153 [ 31, "open_auction5", "08/23/1999", "08:26:06", "person17", 30 ] 153 -
154 [ 6, "open_auction1", "10/02/2000", "22:48:00", "person4", 15 ] 154 -
155 [ 5, "open_auction1", "11/12/1998", "11:23:38", "person20", 4.5 ] 155 -
156 [ 10, "open_auction1", "11/12/2001", "04:50:27", "person9", 6 ] 156 -
157 [ 9, "open_auction1", "12/02/2001", "13:38:51", "person15", 45 ] 157 -
158 [ 7, "open_auction1", "12/04/1998", "22:29:38", "person23", 1.5 ] 158 -
159 #select * from ( 159 143 #select * from ( 143