diff options
| author | unknown <ibabaev@bk-internal.mysql.com> | 2007-04-02 03:53:21 +0200 |
|---|---|---|
| committer | unknown <ibabaev@bk-internal.mysql.com> | 2007-04-02 03:53:21 +0200 |
| commit | 516b8b2137e27661960372c8bf5f757ffb2f2883 (patch) | |
| tree | 7865e75f26fbc8845dd0663f1ba4584f748c7e99 /mysql-test/r | |
| parent | 60f62fa9ffec2dcd054e47223963275c8999fe77 (diff) | |
| parent | 6494ce8356ba6c7d5b387894dcff0adefc5f4a43 (diff) | |
| download | mariadb-git-516b8b2137e27661960372c8bf5f757ffb2f2883.tar.gz | |
Merge bk-internal.mysql.com:/data0/bk/mysql-5.1
into bk-internal.mysql.com:/data0/bk/mysql-5.1-opt
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/row.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index 08d457f7ad7..26d616df2f3 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -306,3 +306,16 @@ a b a b c 1 1 1 2 1 1 2 1 2 1 DROP TABLE t1,t2; +CREATE TABLE t1( +a int, b int, c int, d int, e int, f int, g int, h int, +PRIMARY KEY (a,b,c,d,e,f,g) +); +INSERT INTO t1 VALUES (1,2,3,4,5,6,7,99); +SELECT h FROM t1 WHERE (a,b,c,d,e,f,g)=(1,2,3,4,5,6,7); +h +99 +SET @x:= (SELECT h FROM t1 WHERE (a,b,c,d,e,f,g)=(1,2,3,4,5,6,7)); +SELECT @x; +@x +99 +DROP TABLE t1; |