diff options
| author | unknown <igor@rurik.mysql.com> | 2005-06-23 11:22:30 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-06-23 11:22:30 -0700 |
| commit | e3cfd4ef0cda7cd46940454ab82f1a509d21cb92 (patch) | |
| tree | 11a7803101cbf7b5a82af191b7a2e86927f5aab1 /mysql-test/r/func_str.result | |
| parent | 85a7014de65c2475462852d253d9d6331572c107 (diff) | |
| parent | d9a7e4e0dc2abb92f3328104f6b3394c25c355e3 (diff) | |
| download | mariadb-git-e3cfd4ef0cda7cd46940454ab82f1a509d21cb92.tar.gz | |
Manual merge
mysql-test/r/func_str.result:
Auto merged
mysql-test/t/func_str.test:
Auto merged
sql/item_subselect.cc:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 1c6a4393dfc..92ec76fb024 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -800,3 +800,14 @@ field(0,NULL,1,0) field("",NULL,"bar","") field(0.0,NULL,1.0,0.0) select field(NULL,1,2,NULL), field(NULL,1,2,0); field(NULL,1,2,NULL) field(NULL,1,2,0) 0 0 +CREATE TABLE t1 (str varchar(20) PRIMARY KEY); +CREATE TABLE t2 (num int primary key); +INSERT INTO t1 VALUES ('notnumber'); +INSERT INTO t2 VALUES (0), (1); +SELECT * FROM t1, t2 WHERE num=str; +str num +notnumber 0 +SELECT * FROM t1, t2 WHERE num=substring(str from 1 for 6); +str num +notnumber 0 +DROP TABLE t1,t2; |