diff options
| author | bell@sanja.is.com.ua <> | 2003-06-28 17:04:26 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2003-06-28 17:04:26 +0300 |
| commit | ebc2976f9461ce264713a5222913280357eb7cef (patch) | |
| tree | 522096fa91c61fc5e243742bfb5e703d81dd7aa1 /mysql-test/t/subselect.test | |
| parent | 08f8ab59173fd1727a216c6f9eb5a35c02b7f8a2 (diff) | |
| download | mariadb-git-ebc2976f9461ce264713a5222913280357eb7cef.tar.gz | |
fixed bug #745
(resolving fields of reduced subselect)
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 0c3c5cfda18..980fafe12ac 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -763,3 +763,5 @@ CREATE TABLE `t1` ( INSERT INTO t1 (id,pseudo,email) VALUES (1,'test','test'),(2,'test1','test1'); SELECT pseudo as a, pseudo as b FROM t1 GROUP BY (SELECT a) ORDER BY (SELECT id*1); drop table if exists t1; + +(SELECT 1 as a) UNION (SELECT 1) ORDER BY (SELECT a+0); |