null+****@clear*****
null+****@clear*****
2011年 6月 18日 (土) 16:59:33 JST
Kouhei Sutou 2011-06-18 07:59:33 +0000 (Sat, 18 Jun 2011)
New Revision: f09a00ccf2c1ee4c222959f3f12e11377fbdc54e
Log:
[wrapper][insert][test] set primary key.
Modified files:
test/sql/r/insert_wrapper.result
test/sql/t/insert_wrapper.test
Modified: test/sql/r/insert_wrapper.result (+11 -11)
===================================================================
--- test/sql/r/insert_wrapper.result 2011-06-18 07:38:06 +0000 (47030f3)
+++ test/sql/r/insert_wrapper.result 2011-06-18 07:59:33 +0000 (93c05bf)
@@ -1,65 +1,65 @@
drop table if exists t1, t2, t3;
-create table t1 (c1 tinyint) COMMENT = 'engine "innodb"';
+create table t1 (c1 tinyint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
c1
1
drop table t1;
-create table t1 (c1 smallint) COMMENT = 'engine "innodb"';
+create table t1 (c1 smallint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
c1
1
drop table t1;
-create table t1 (c1 mediumint) COMMENT = 'engine "innodb"';
+create table t1 (c1 mediumint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
c1
1
drop table t1;
-create table t1 (c1 int) COMMENT = 'engine "innodb"';
+create table t1 (c1 int primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
c1
1
drop table t1;
-create table t1 (c1 bigint) COMMENT = 'engine "innodb"';
+create table t1 (c1 bigint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
c1
1
drop table t1;
-create table t1 (c1 float) COMMENT = 'engine "innodb"';
+create table t1 (c1 float primary key) COMMENT = 'engine "innodb"';
insert into t1 values(0.5);
select * from t1;
c1
0.5
drop table t1;
-create table t1 (c1 double) COMMENT = 'engine "innodb"';
+create table t1 (c1 double primary key) COMMENT = 'engine "innodb"';
insert into t1 values(0.5);
select * from t1;
c1
0.5
drop table t1;
-create table t1 (c1 date) COMMENT = 'engine "innodb"';
+create table t1 (c1 date primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010/03/26");
select * from t1;
c1
2010-03-26
drop table t1;
-create table t1 (c1 time) COMMENT = 'engine "innodb"';
+create table t1 (c1 time primary key) COMMENT = 'engine "innodb"';
insert into t1 values("11:22:33");
select * from t1;
c1
11:22:33
drop table t1;
-create table t1 (c1 year) COMMENT = 'engine "innodb"';
+create table t1 (c1 year primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010");
select * from t1;
c1
2010
drop table t1;
-create table t1 (c1 datetime) COMMENT = 'engine "innodb"';
+create table t1 (c1 datetime primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010/03/26 11:22:33");
select * from t1;
c1
Modified: test/sql/t/insert_wrapper.test (+11 -11)
===================================================================
--- test/sql/t/insert_wrapper.test 2011-06-18 07:38:06 +0000 (dc1d944)
+++ test/sql/t/insert_wrapper.test 2011-06-18 07:59:33 +0000 (50d48e9)
@@ -22,57 +22,57 @@ drop table if exists t1, t2, t3;
--enable_warnings
# data types
-create table t1 (c1 tinyint) COMMENT = 'engine "innodb"';
+create table t1 (c1 tinyint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
drop table t1;
-create table t1 (c1 smallint) COMMENT = 'engine "innodb"';
+create table t1 (c1 smallint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
drop table t1;
-create table t1 (c1 mediumint) COMMENT = 'engine "innodb"';
+create table t1 (c1 mediumint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
drop table t1;
-create table t1 (c1 int) COMMENT = 'engine "innodb"';
+create table t1 (c1 int primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
drop table t1;
-create table t1 (c1 bigint) COMMENT = 'engine "innodb"';
+create table t1 (c1 bigint primary key) COMMENT = 'engine "innodb"';
insert into t1 values(1);
select * from t1;
drop table t1;
-create table t1 (c1 float) COMMENT = 'engine "innodb"';
+create table t1 (c1 float primary key) COMMENT = 'engine "innodb"';
insert into t1 values(0.5);
select * from t1;
drop table t1;
-create table t1 (c1 double) COMMENT = 'engine "innodb"';
+create table t1 (c1 double primary key) COMMENT = 'engine "innodb"';
insert into t1 values(0.5);
select * from t1;
drop table t1;
-create table t1 (c1 date) COMMENT = 'engine "innodb"';
+create table t1 (c1 date primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010/03/26");
select * from t1;
drop table t1;
-create table t1 (c1 time) COMMENT = 'engine "innodb"';
+create table t1 (c1 time primary key) COMMENT = 'engine "innodb"';
insert into t1 values("11:22:33");
select * from t1;
drop table t1;
-create table t1 (c1 year) COMMENT = 'engine "innodb"';
+create table t1 (c1 year primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010");
select * from t1;
drop table t1;
-create table t1 (c1 datetime) COMMENT = 'engine "innodb"';
+create table t1 (c1 datetime primary key) COMMENT = 'engine "innodb"';
insert into t1 values("2010/03/26 11:22:33");
select * from t1;
drop table t1;