Menu
▾
▴
#2727 incorrect number of found records(keyword BINARY)
works-for-me
5
2013-06-11
2008-07-25
No
Reproduce it this way:
- open a database table
- hit the SQL button on the top bar
- enter a query like "SELECT * FROM `yourtable` WHERE binary 1"
In the result, you get all the record, but on the top you have:
"Showing rows 0 - 0 (1 total, Query took 0.0011 sec)"
i.e. the number of found records is incorrect.
Note that this doesn't happen without the "binary"
Logged In: YES
user_id=210714
Originator: NO
Ok, and is there a good reason why you used this syntax?
Logged In: YES
user_id=955945
Originator: YES
The form of the query I put in the bug report is the simplest in order to reproduce the bug.
The problem is when you use something like:
SELECT * FROM `yourtable` WHERE binary field= "some text"
Cannot reproduce with 3.1.1.
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).