Random records not showing any items

[dotancohen]

Consider this table:

mysql> select * from users;
+----+-------+----------------------------------+-------+---------+
| id | login | password                         | type  | type_id |
+----+-------+----------------------------------+-------+---------+
| 48 | uriel | 76419c58730d9f35de7ac538c2fd6737 | admin |    NULL |
| 49 | inbal | 76419c58730d9f35de7ac538c2fd6737 | admin |    NULL |
+----+-------+----------------------------------+-------+---------+
2 rows in set (0.00 sec)

The current Squeal code consistently shows:

   Some random records
   -------------------
No records returned!

[dotancohen]

Here is another:

mysql> select id from iso;
+----+
| id |
+----+
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
+----+
7 rows in set (0.00 sec)

Squeal shows:

   Some random records
   -------------------
No records returned!

[dotancohen]

The random records feature is broken if the IDs are not sequential. In a table with records of ID 10, 20, 30, 40, etc almost no records are ever found.