diff options
| author | unknown <igor@rurik.mysql.com> | 2006-03-27 18:28:55 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-03-27 18:28:55 -0800 |
| commit | b0654461dfbde40f8419b0af1f3be17217638bd2 (patch) | |
| tree | 2f3e939f12e45c4e0568bb5cb29eec70675b0ef1 /mysql-test/r/view.result | |
| parent | ce494285fc8e22092d7521e04f161b2cbf46139a (diff) | |
| download | mariadb-git-b0654461dfbde40f8419b0af1f3be17217638bd2.tar.gz | |
Fixed bug #18386.
An invalid assertion in Item_direct_view_ref::eq caused
an assertion abort in the debug version.
mysql-test/r/view.result:
Added a test case for bug #18386.
mysql-test/t/view.test:
Added a test case for bug #18386.
sql/item.cc:
Fixed bug #18386.
An invalid assertion in Item_direct_view_ref::eq caused
an assertion abort in the debug version.
Changed the assertion.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 7678c70bda2..5a5f60e9409 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; |