diff options
| author | bell@sanja.is.com.ua <> | 2002-11-11 10:49:41 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2002-11-11 10:49:41 +0200 |
| commit | 063ffd2d6702ee08a47efa48a75f0cc1e0cfe34c (patch) | |
| tree | fd9d0554ea576b579ddefeaa6efd8a371a36ae00 /mysql-test | |
| parent | 46a74ce73bc3d7fd5ea50a865046331a7a04c00c (diff) | |
| download | mariadb-git-063ffd2d6702ee08a47efa48a75f0cc1e0cfe34c.tar.gz | |
prevent using expernal fields in derived tables
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 4eaacfe66f7..0d3617b7512 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -240,4 +240,6 @@ SELECT numeropost,maxnumrep FROM forumconthardwarefr7 WHERE exists (SELECT 1 FRO numeropost maxnumrep 43506 2 40143 1 +SELECT (SELECT 1) as a FROM (SELECT 1 FROM forumconthardwarefr7 HAVING a=1); +Unknown column 'a' in 'having clause' drop table forumconthardwarefr7, searchconthardwarefr7; diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 12df155bc7f..93ad115155e 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -137,5 +137,7 @@ CREATE TABLE `searchconthardwarefr7` ( INSERT INTO searchconthardwarefr7 (mot,topic,date,pseudo) VALUES ('joce','40143','2002-10-22','joce'), ('joce','43506','2002-10-22','joce'); SELECT numeropost,maxnumrep FROM forumconthardwarefr7 WHERE exists (SELECT 1 FROM searchconthardwarefr7 WHERE (mot='joce') AND date >= '2002-10-21' AND forumconthardwarefr7.numeropost = searchconthardwarefr7.topic) ORDER BY maxnumrep DESC LIMIT 0, 20; +-- error 1054 +SELECT (SELECT 1) as a FROM (SELECT 1 FROM forumconthardwarefr7 HAVING a=1); drop table forumconthardwarefr7, searchconthardwarefr7;
\ No newline at end of file |