summaryrefslogtreecommitdiff
path: root/mysql-test/r/variables.result
blob: adf8100f052f23a3c84c794ef41ae5af366d6d77 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
@test	@`select`	@TEST	@not_used
1	2	3	NULL
@test_int	@test_double	@test_string	@test_string2	@select
10	1e-10	abcdeghi	abcdefghij	NULL
@test_int	@test_double	@test_string	@test_string2
hello	hello	hello	hello
@test_int	@test_double	@test_string	@test_string2
hellohello	hellohello	hellohello	hellohello
@test_int	@test_double	@test_string	@test_string2
NULL	NULL	NULL	NULL
@t1:=(@t2:=1)+@t3:=4	@t1	@t2	@t3
5	5	1	4
@t5
1.23456
@min_cid:=min(c_id)	@max_cid:=max(c_id)
1	4
c_id	c_name	c_country
1	Bozo	USA
4	Mr. Floppy	GB
c_id	c_name	c_country
1	Bozo	USA
4	Mr. Floppy	GB
c_id	c_name	c_country
1	Bozo	USA
4	Mr. Floppy	GB
@@VERSION=version()
1
last_insert_id(345)
345
@@IDENTITY	last_insert_id()
345	345
@@IDENTITY
345