Test the query with
EXPLAIN to check
whether you can find something that is obviously wrong. See
Section 7.2.1, “Optimizing Queries with
Select only those columns that are used in the
Remove one table at a time from the query until it returns
some rows. If the tables are large, it's a good idea to use
LIMIT 10 with the query.
SELECT for the column that should
have matched a row against the table that was last removed
from the query.
If you are comparing
DOUBLE columns with numbers that have
decimals, you can't use equality (
comparisons. This problem is common in most computer
languages because not all floating-point values can be
stored with exact precision. In some cases, changing the
FLOAT to a
fixes this. See Section A.5.8, “Problems with Floating-Point Comparisons”.
If you still can't figure out what's wrong, create a minimal
test that can be run with
mysql test <
query.sql that shows your problems. You can create
a test file by dumping the tables with mysqldump
query.sql. Open the file in an editor, remove some
insert lines (if there are more than needed to demonstrate
the problem), and add your
statement at the end of the file.
Verify that the test file demonstrates the problem by
executing these commands:
mysqladmin create test2
mysql test2 < query.sql
Attach the test file to a bug report, which you can file
using the instructions in Section 1.8, “How to Report Bugs or Problems”.