re: MySQL 4.03 and merge tables: bug with BETWEEN

2002-10-01 Thread Egor Egorov
Tac, Friday, September 27, 2002, 10:34:46 PM, you wrote: T> We're having a problem with a huge merge table and BETWEEN. The same query T> in MySQL 3, using an identical (binary) copy of the database, takes a T> fraction of a second, in MySQL 4.03 it runs without stopping. T> The query is a simp

MySQL 4.03 and merge tables: bug with BETWEEN

2002-09-27 Thread Tac
We're having a problem with a huge merge table and BETWEEN. The same query in MySQL 3, using an identical (binary) copy of the database, takes a fraction of a second, in MySQL 4.03 it runs without stopping. The query is a simple "Select * from my_merge_table where my_code BETWEEN '2026676653' AN