diff options
Diffstat (limited to 'mysql-test/main/user_var.result')
-rw-r--r-- | mysql-test/main/user_var.result | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/mysql-test/main/user_var.result b/mysql-test/main/user_var.result index 36c518d00e9..a5837996c19 100644 --- a/mysql-test/main/user_var.result +++ b/mysql-test/main/user_var.result @@ -368,13 +368,18 @@ select @rownum := @rownum + 1 as row, from t1 order by score desc; drop table t1; create table t1(b bigint); -insert into t1 (b) values (10), (30), (10); +insert into t1 (b) values (10), (30), (10), (10); +set @var := 0; +explain select if(b=@var, 999, b) , @var := b from t1 order by b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort set @var := 0; select if(b=@var, 999, b) , @var := b from t1 order by b; if(b=@var, 999, b) @var := b 10 10 -999 10 30 30 +999 10 +999 10 drop table t1; create temporary table t1 (id int); insert into t1 values (2), (3), (3), (4); |