diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-09-24 19:30:20 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-09-24 19:30:20 -0400 |
| commit | 2d9e4e66981844fec25185660f9164b49fc58126 (patch) | |
| tree | 3ce78e3ce7a515bd5c583a459bec1fdd3e7e6a35 /mysql-test/t/user_var.test | |
| parent | f46ca5fbe905caa7efb3f3cafdbdcc7c0f83a2b0 (diff) | |
| download | mariadb-git-2d9e4e66981844fec25185660f9164b49fc58126.tar.gz | |
fixed bug #1194
(changes in Item_func_set_user_var::update, ::val, ::val_str, ::val_int)
mysql-test/r/user_var.result:
added tests for bug #1194
mysql-test/t/user_var.test:
added tests for bug #1194
Diffstat (limited to 'mysql-test/t/user_var.test')
| -rw-r--r-- | mysql-test/t/user_var.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index f5f91a8a680..1e466c149bb 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -23,3 +23,22 @@ select @a:=10, @b:=1, @a > @b, @a < @b; select @a:="10", @b:="1", @a > @b, @a < @b; select @a:=10, @b:=2, @a > @b, @a < @b; select @a:="10", @b:="2", @a > @b, @a < @b; + +# Fixed bug #1194 +select @a:=1; +select @a, @a:=1; + +create table t1 (id int); +insert into t1 values (1); +select @c:=0; +update t1 SET id=(@c:=@c+1); +select @c; +select @c:=0; +update t1 set id=(@c:=@c+1); +select @c; +select @c:=0; +select @c:=@c+1; +drop table t1; + +# just fof fun :) +select @a:=10, @b:=2, @a>@b, @a:="10", @b:="2", @a>@b, @a:=10, @b:=2, @a>@b, @a:="10", @b:="2", @a>@b;
\ No newline at end of file |