diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-06-27 06:40:24 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-06-27 06:40:24 +0300 |
| commit | 5768f4a34ed7218c61ed34cf5b76eee66b715224 (patch) | |
| tree | a506fecb9ce71aff561f0d60c7b0f65893d70874 /mysql-test/t/select_safe.test | |
| parent | c2cb9b97be721d07e9cb2a27076c8beaf22f304b (diff) | |
| download | mariadb-git-5768f4a34ed7218c61ed34cf5b76eee66b715224.tar.gz | |
Fixed testcase after last changes
Diffstat (limited to 'mysql-test/t/select_safe.test')
| -rw-r--r-- | mysql-test/t/select_safe.test | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/t/select_safe.test b/mysql-test/t/select_safe.test index 049a35aa355..206f911d028 100644 --- a/mysql-test/t/select_safe.test +++ b/mysql-test/t/select_safe.test @@ -4,7 +4,7 @@ drop table if exists t1; SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=4, SQL_MAX_JOIN_SIZE=9; -create table t1 (a int auto_increment primary key, b char(20), key(b)); +create table t1 (a int auto_increment primary key, b char(20)); insert into t1 values(1,"test"); SELECT SQL_BUFFER_RESULT * from t1; update t1 set b="a" where a=1; @@ -36,13 +36,14 @@ delete from t1 where a+0=1 limit 2; # Test SQL_BIG_SELECTS +alter table t1 add key b (b); SET MAX_JOIN_SIZE=2; SELECT @@MAX_JOIN_SIZE, @@SQL_BIG_SELECTS; insert into t1 values (null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"); --error 1104 -SELECT * from t1; +SELECT * from t1 order by a; SET SQL_BIG_SELECTS=1; -SELECT * from t1; +SELECT * from t1 order by a; SET MAX_JOIN_SIZE=2; --error 1104 SELECT * from t1; |