Posted by peter |
How would you expect AUTO_INCREMENT to work with MERGE tables ? Assuming INSERT_METHOD=LAST is used I would expect it to work same as in case insertion happens to the last table… which does not seems to be the case. Alternatively I would expect AUTO_INCREMENT to be based off the maximum value across all tables, respecting AUTO_INCREMENT set for the Merge Table itself. Neither of these expectations really true:
[read more...]
Posted by peter |
Take a look at this:
SQL:
-
mysql> repair TABLE a3;
-
+---------+--------+----------+----------+
-
| TABLE | Op | Msg_type | Msg_text |
-
+---------+--------+----------+----------+
-
| test.a3 | repair | STATUS | OK |
-
+---------+--------+----------+----------+
-
1 row IN SET (0.10 sec)
-
-
mysql> SELECT * FROM a3 ORDER BY i;
-
+------------+
-
| i |
-
+------------+
-
| 2147483648 |
-
| 11 |
-
| 13 |
-
| 14 |
-
| 2147483647 |
-
+------------+
-
5 rows IN SET (0.00 sec)
The sort order is obviously wrong while CHECK TABLE is not reporting any error
[read more...]
Posted by
peter @ 4:24 pm ::
myisam ::
del.icio.us
digg