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 [...]
Can you Trust CHECK TABLE ?
September 11, 2008 By 6 Comments
Take a look at this: 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 | [...]
