[Commits] 4baa323: Postreview

Oleksandr Byelkin sanja at mariadb.com
Wed Sep 28 15:41:59 EEST 2016


revision-id: 4baa32314b2f25e2f5a2ecbd0be1c7b5b766b590 (mariadb-10.1.17-15-g4baa323)
parent(s): 5a215bae7d77eb6bd9d51e3e7fc6d94b6959d27d
committer: Oleksandr Byelkin
timestamp: 2016-09-28 14:41:58 +0200
message:

Postreview

---
 mysql-test/r/having.result | 8 ++++++++
 mysql-test/t/having.test   | 4 ++++
 2 files changed, 12 insertions(+)

diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result
index ab90f88..7fdec5a 100644
--- a/mysql-test/r/having.result
+++ b/mysql-test/r/having.result
@@ -719,5 +719,13 @@ SELECT i, COUNT(*) FROM t1 GROUP BY i HAVING i<>0 AND 1;
 i	COUNT(*)
 1	1
 2	1
+SELECT i-1 A, COUNT(*) FROM t1 GROUP BY i HAVING A AND 1;
+A	COUNT(*)
+1	1
+CREATE VIEW v1 as select i, i-1 as A from t1;
+SELECT A, COUNT(*) FROM v1 GROUP BY i HAVING A AND 1;
+A	COUNT(*)
+1	1
+DROP VIEW v1;
 DROP TABLE t1;
 End of 10.1 tests
diff --git a/mysql-test/t/having.test b/mysql-test/t/having.test
index 4e939c4..f826fef 100644
--- a/mysql-test/t/having.test
+++ b/mysql-test/t/having.test
@@ -751,6 +751,10 @@ DROP TABLE t1,t2;
 CREATE TABLE t1 (i INT);
 INSERT INTO t1 VALUES (1),(2);
 SELECT i, COUNT(*) FROM t1 GROUP BY i HAVING i<>0 AND 1;
+SELECT i-1 A, COUNT(*) FROM t1 GROUP BY i HAVING A AND 1;
+CREATE VIEW v1 as select i, i-1 as A from t1;
+SELECT A, COUNT(*) FROM v1 GROUP BY i HAVING A AND 1;
+DROP VIEW v1;
 DROP TABLE t1;
 
 --echo End of 10.1 tests


More information about the commits mailing list