diff options
| author | unknown <wax@kishkin.ru> | 2004-09-16 00:47:45 +0600 |
|---|---|---|
| committer | unknown <wax@kishkin.ru> | 2004-09-16 00:47:45 +0600 |
| commit | 7d94788c1ad489f57f339066396259941e05d577 (patch) | |
| tree | c716748cbe263336273d57ccd7f7d711218b425f /mysql-test/t/insert.test | |
| parent | a3c22ae7d2d719e6e4ba052056c1dba316390985 (diff) | |
| download | mariadb-git-7d94788c1ad489f57f339066396259941e05d577.tar.gz | |
WL#964
porting mysql_test_run on Linux and Windows
client/mysqltest.c:
added windows code
mysql-test/Makefile.am:
added code of creating make file
mysql-test/r/fulltext.result:
added FORMAT() for compatible with Windows version
mysql-test/r/fulltext_cache.result:
added FORMAT()
mysql-test/r/fulltext_multi.result:
added FORMAT()
mysql-test/r/fulltext_order_by.result:
added FORMAT()
mysql-test/r/type_float.result:
added --replace-result
mysql-test/t/fulltext.test:
added FORMAT()
mysql-test/t/fulltext_cache.test:
added FORMAT()
mysql-test/t/fulltext_multi.test:
added FORMAT()
mysql-test/t/fulltext_order_by.test:
added FORMAT()
mysql-test/t/innodb.test:
added --replace-result
mysql-test/t/insert.test:
added --replace_result
mysql-test/t/type_float.test:
added --replace-result
mysql-test/t/variables.test:
added --replace_result
Diffstat (limited to 'mysql-test/t/insert.test')
| -rw-r--r-- | mysql-test/t/insert.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/insert.test b/mysql-test/t/insert.test index fd728c453aa..b03b77f0be8 100644 --- a/mysql-test/t/insert.test +++ b/mysql-test/t/insert.test @@ -97,46 +97,57 @@ create table t1(number int auto_increment primary key, original_value varchar(50 set @value= "aa"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= "1aa"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= "aa1"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= "1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= "-1e+1111111111a"; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= 1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= -1e+1111111111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= 1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= -1e+111; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= 1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() set @value= -1; insert into t1 values(null,@value,@value,@value,@value,@value,@value,@value,@value,@value); +--replace_result e-0 e- e+0 e+ --query_vertical select * from t1 where number =last_insert_id() drop table t1; |