Re: Difference between two SQL queries

[laptop alias]

?

I cannot replicate this behaviour...

mysql> SELECT version();
+------------------+
| version()        |
+------------------+
| 5.1.30-community |
+------------------+
1 row in set (0.01 sec)

mysql> SELECT * FROM ints x INNER JOIN ints y LIMIT 12;
+---+---+
| i | i |
+---+---+
| 0 | 0 |
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
| 7 | 0 |
| 8 | 0 |
| 9 | 0 |
| 0 | 1 |
| 1 | 1 |
+---+---+
12 rows in set (0.00 sec)

mysql>