Skip to content

Instantly share code, notes, and snippets.

@do-aki

do-aki/test-sql

Created November 8, 2016 08:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save do-aki/928a3f5c29178d9cf06d0c9223fe11dd to your computer and use it in GitHub Desktop.
Save do-aki/928a3f5c29178d9cf06d0c9223fe11dd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test-sql
# スレッドA,B 生成前に実行
> create table t1( id int not null auto_increment, hoge varchar(255) not null, primary key(id) )engine=innodb;
> insert into t1 values (1, "hoge");
スレッドA
> drop table t1;
> create table t1( id int not null auto_increment, primary key(id) )engine=innodb;
> insert into t1 values (1);
スレッドB
> select * from t1 where id = 1;
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hoge' in 'field list' <- タイミングによって発生?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment