mysql:2193
From: <takeshi@xxxxxxxxxx>
Date: Tue, 13 Jun 2000 09:57:23 +0900
Subject: [mysql 02193] Re: Delete と Insert がひどく遅い
とみたさんの示された、間違った SELECT クエリに対する振る舞いが レコード数によって違うバグを修正するパッチです。 3.23.19 のソースに入る予定です。 *** /my/monty/master/mysql-3.23.15-alpha/sql/sql_select.cc Sat May 6 18:21:49 2000 --- ./sql_select.cc Mon Jun 12 17:00:11 2000 *************** *** 1104,1110 **** stat[0].key_dependent|=used_tables; if (value->const_item()) stat[0].const_keys |= field->key_start; ! if (!eq_func) return; } } --- 1096,1109 ---- stat[0].key_dependent|=used_tables; if (value->const_item()) stat[0].const_keys |= field->key_start; ! /* ! We can't reliable use and indexes when comparing a string index to a ! number. cmp_type() is checked to allow compare of dates to numbers ! */ ! if (!eq_func || ! field->result_type() == STRING_RESULT && ! value->result_type() != STRING_RESULT && ! field->cmp_type() != value->result_type()) return; } }
2178 2000-06-09 20:20 [hironobus <hironobus] Delete と Insert がひどく遅い 2179 2000-06-10 01:36 ┣["Y. Tsutsui" <tutui@] 2180 2000-06-10 03:55 ┣[Yasuhiro Hayase <hay] 2184 2000-06-10 16:21 ┃┗["MINOHATA Norio" <mi] 2185 2000-06-10 17:03 ┃ ┗["Y. Tsutsui" <tutui@] 2186 2000-06-10 17:52 ┃ ┗["MINOHATA Norio" <mi] 2187 2000-06-10 18:13 ┃ ┗["Y. Tsutsui" <tutui@] 2191 2000-06-11 23:31 ┃ ┗[とみたまさひろ <tomm] 2192 2000-06-12 19:32 ┃ ┣[<takeshi@xxxxxxxxxx>] -> 2193 2000-06-13 09:57 ┃ ┗[<takeshi@xxxxxxxxxx>] 2181 2000-06-10 10:37 ┣[<takeshi@xxxxxxxxxx>] 2182 2000-06-10 12:21 ┃┗["Y. Tsutsui" <tutui@] 2183 2000-06-10 14:07 ┃ ┗[<takeshi@xxxxxxxxxx>] 2189 2000-06-10 21:22 ┗[Hironobu SUZUKI <hir] Re: Delete とUPDATEがひどく遅い