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/r/user_var.result | |
| 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/r/user_var.result')
| -rw-r--r-- | mysql-test/r/user_var.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index 67e55acb29b..d94ab6f57c3 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -42,3 +42,35 @@ select @a:=10, @b:=2, @a > @b, @a < @b; select @a:="10", @b:="2", @a > @b, @a < @b; @a:="10" @b:="2" @a > @b @a < @b 10 2 0 1 +select @a:=1; +@a:=1 +1 +select @a, @a:=1; +@a @a:=1 +1 1 +create table t1 (id int); +insert into t1 values (1); +select @c:=0; +@c:=0 +0 +update t1 SET id=(@c:=@c+1); +select @c; +@c +1 +select @c:=0; +@c:=0 +0 +update t1 set id=(@c:=@c+1); +select @c; +@c +1 +select @c:=0; +@c:=0 +0 +select @c:=@c+1; +@c:=@c+1 +1 +drop table t1; +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; +@a:=10 @b:=2 @a>@b @a:="10" @b:="2" @a>@b @a:=10 @b:=2 @a>@b @a:="10" @b:="2" @a>@b +10 2 1 10 2 0 10 2 1 10 2 0 |