diff options
| author | unknown <gshchepa/uchum@host.loc> | 2008-02-13 19:37:05 +0400 |
|---|---|---|
| committer | unknown <gshchepa/uchum@host.loc> | 2008-02-13 19:37:05 +0400 |
| commit | 22e2762640a401a71604c2fdb1a3a3454b79de80 (patch) | |
| tree | d93b2a137a6235824590b1871d219fee4827c6f6 /mysql-test/r/select.result | |
| parent | 7a43d720245d1d9999ebf7d064063ed873eea60d (diff) | |
| parent | 7a290b55f7691b2518cb1d83da252e07376954f6 (diff) | |
| download | mariadb-git-22e2762640a401a71604c2fdb1a3a3454b79de80.tar.gz | |
Merge host.loc:/home/uchum/work/5.0-opt-gca
into host.loc:/home/uchum/work/5.1-opt-gca
mysql-test/r/select.result:
Auto merged
mysql-test/t/select.test:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/sql_acl.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 2f305f6ec5d..e56c1629a64 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -4313,6 +4313,12 @@ SELECT * FROM t1 WHERE c1 > NULL + 1; c1 DROP TABLE t1; +CREATE TABLE t1 (a VARCHAR(10) NOT NULL PRIMARY KEY); +INSERT INTO t1 (a) VALUES ('foo0'), ('bar0'), ('baz0'); +SELECT * FROM t1 WHERE a IN (CONCAT('foo', 0), 'bar'); +a +foo0 +DROP TABLE t1; End of 5.0 tests create table t1(a INT, KEY (a)); INSERT INTO t1 VALUES (1),(2),(3),(4),(5); |