Hi!
>>>>> "Andrew" == Andrew Sitnikov <sitnikov@stripped> writes:
Andrew> Hello ,
smc> Can you try 3.23.9 and see if it has the same problem ??
Andrew> 3.22.22
Andrew> SELECT count(id) FROM tblRecords WHERE body REGEXP '[[:<:]]12' or body
> REGEXP '[[:<:]]pay';
Andrew> +-----------+
Andrew> | count(id) |
Andrew> +-----------+
Andrew> | 3987 |
Andrew> +-----------+
Andrew> 1 row in set (15.58 sec)
<cut>
Andrew> 3.23.9
Andrew> SELECT count(id) FROM tblRecords WHERE body REGEXP '[[:<:]]12' or body
> REGEXP '[[:<:]]pay';
Andrew> +-----------+
Andrew> | count(id) |
Andrew> +-----------+
Andrew> | 3988 |
Andrew> +-----------+
Andrew> 1 row in set (1 min 11.11 sec)
Andrew> Interesting also value of count() :)
I am now running this on my 3.23.11 version:
mysql> select count(*) from tblRecords where body regexp '[[:<:]]12' or body REGEXP
> '[[:<:]]pay';
+----------+
| count(*) |
+----------+
| 3987 |
+----------+
1 row in set (4.21 sec)
What do you get when doing:
mysql> show table status like "tblRecords";
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length
| Index_length | Data_free | Auto_increment | Create_time | Update_time |
Check_time | Create_options | Comment |
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+
| tblRecords | MyISAM | Dynamic | 3987 | 5296 | 21117172 | 2147483647
| 49152 | 0 | 3988 | 2000-02-07 18:36:55 | 2000-02-07 18:36:56 |
NULL | | |
+------------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+
Any change to get an account on your computer so that we can login
onto your site and test this there?
Did you compile MySQL 3.22 and 3.23 with the same options and the same
compiler?
Regards,
Monty
