diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-11-02 17:29:31 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-11-02 17:29:31 +0200 |
| commit | 6d9ad5db3a9dd558ae136717acfc884683a33975 (patch) | |
| tree | a07c8a51589cbdcaa1a8c323a2f8fa27b3a3fa9f /mysql-test/r/subselect.result | |
| parent | 8b7ba1cfa32ea51801961308c80838f4fe05a7a0 (diff) | |
| parent | 5fe5142694df34c8dbd6b50d130c935126e9f558 (diff) | |
| download | mariadb-git-6d9ad5db3a9dd558ae136717acfc884683a33975.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 5d462ec2961..29bba54b55a 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -1486,3 +1486,10 @@ ERROR 42S22: Unknown column 't1.s2' in 'group statement' select count(*) from t2 group by t1.s2; ERROR 42S02: Unknown table 't1' in group statement drop table t1, t2; +CREATE TABLE t1(COLA FLOAT NOT NULL,COLB FLOAT NOT NULL,COLC VARCHAR(20) DEFAULT NULL,PRIMARY KEY (COLA, COLB)); +CREATE TABLE t2(COLA FLOAT NOT NULL,COLB FLOAT NOT NULL,COLC CHAR(1) NOT NULL,PRIMARY KEY (COLA)); +INSERT INTO t1 VALUES (1,1,'1A3240'), (1,2,'4W2365'); +INSERT INTO t2 VALUES (100, 200, 'C'); +SELECT DISTINCT COLC FROM t1 WHERE COLA = (SELECT COLA FROM t2 WHERE COLB = 200 AND COLC ='C' LIMIT 1); +COLC +DROP TABLE t1, t2; |