Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2.5
-
None
Description
A view that has an ifnull around a window function results in error 1356 on querying. A view without the ifnull works and the select with ifnull works.
Test case:
create table t1(dt datetime);
|
insert into t1 values ('2017-05-17'), ('2017-05-18');
|
create view v1 as select dt, lead(dt) over (order by dt) from t1;
|
create view v2 as select dt, ifnull(lead(dt) over (order by dt), '9999-12-31 12:00:00') from t1;
|
|
select * from v1;
|
+---------------------+-----------------------------+
|
| dt | lead(dt) over (order by dt) |
|
+---------------------+-----------------------------+
|
| 2017-05-17 00:00:00 | 2017-05-18 00:00:00 |
|
| 2017-05-18 00:00:00 | NULL |
|
+---------------------+-----------------------------+
|
2 rows in set (0.00 sec)
|
|
select * from v2;
|
ERROR 1356 (HY000): View 'genesis.v2' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
|
|
select dt, ifnull(lead(dt) over (order by dt), '9999-12-31 12:00:00') from t1;
|
+---------------------+------------------------------------------------------------+
|
| dt | ifnull(lead(dt) over (order by dt), '9999-12-31 12:00:00') |
|
+---------------------+------------------------------------------------------------+
|
| 2017-05-17 00:00:00 | 2017-05-18 00:00:00 |
|
| 2017-05-18 00:00:00 | 9999-12-31 12:00:00 |
|
+---------------------+------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|
|
Attachments
Issue Links
- relates to
-
MDEV-12851 Window functions with is null function in query crashes server
- Closed