MYSQL添加字段设为为非空后，又修改为可以为null ，怎么查询不到数据了？

Question

SQL语句： alter table user add age int(1) not null;
alter table user modify age int(1) null;
select * from user limit 1;
ERROR 1104 (42000): The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay(数据库中有数据！！)

Answer 1

不太可能出现这种情况，把
select * from user limit 1;
改为
select * from user limit 0,1;