diff options
| author | unknown <igor@rurik.mysql.com> | 2006-03-27 20:26:57 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-03-27 20:26:57 -0800 |
| commit | 73970addd82584a9ec6ad4c95ba5d54dfe0f640c (patch) | |
| tree | 3721360f95317332cd8b5bc6cacbcfe625a6afdc /mysql-test | |
| parent | effd72a9eaeb71f354636099506121dcd84f6b15 (diff) | |
| parent | 6da39a4c1f1aa3cae7dea28ec349bc3c8e80bc69 (diff) | |
| download | mariadb-git-73970addd82584a9ec6ad4c95ba5d54dfe0f640c.tar.gz | |
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into rurik.mysql.com:/home/igor/mysql-5.1
include/mysql.h:
Auto merged
mysql-test/lib/mtr_timer.pl:
Auto merged
scripts/make_binary_distribution.sh:
Auto merged
sql-common/client.c:
Auto merged
sql/ha_innodb.cc:
Auto merged
storage/ndb/src/kernel/blocks/backup/Backup.cpp:
Auto merged
storage/ndb/src/ndbapi/NdbTransaction.cpp:
Auto merged
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/view.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/view.test | 14 |
2 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index c02e4e1f7c8..ab33b54bd2a 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2553,3 +2553,12 @@ a b 3 3 drop view v2, v1; drop table t1; +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (1), (2); +CREATE VIEW v1 AS SELECT SQRT(a) my_sqrt FROM t1; +SELECT my_sqrt FROM v1 ORDER BY my_sqrt; +my_sqrt +1 +1.4142135623731 +DROP VIEW v1; +DROP TABLE t1; diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index eb7940158ff..3e4797af8ef 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -2404,3 +2404,17 @@ update v2 set b=3 where a=2; select * from v2; drop view v2, v1; drop table t1; + +# +# Bug #18386: select from view over a table with ORDER BY view_col clause +# given view_col is not an image of any column from the base table + +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (1), (2); + +CREATE VIEW v1 AS SELECT SQRT(a) my_sqrt FROM t1; + +SELECT my_sqrt FROM v1 ORDER BY my_sqrt; + +DROP VIEW v1; +DROP TABLE t1; |