diff options
| author | igor@rurik.mysql.com <> | 2005-06-23 11:22:30 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-06-23 11:22:30 -0700 |
| commit | 268110b34b18019e4cb45794de22353efceaa5d3 (patch) | |
| tree | 11a7803101cbf7b5a82af191b7a2e86927f5aab1 /mysql-test/t/func_str.test | |
| parent | 0a5223bf8a218ee685f4aa320ec1f140f6a65ec7 (diff) | |
| parent | 1c348f48a9a37f5b79944d668867aae3f66b5359 (diff) | |
| download | mariadb-git-268110b34b18019e4cb45794de22353efceaa5d3.tar.gz | |
Manual merge
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 728f0e2c084..e6bf9f81dd0 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -529,3 +529,17 @@ DROP TABLE t1, t2; # select 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); + +# +# Bug #10124: access by integer index with a string key that is not a number +# + +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; +SELECT * FROM t1, t2 WHERE num=substring(str from 1 for 6); + +DROP TABLE t1,t2; |