-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.3, 10.3.7
-
Fix Version/s: 10.3.8
-
Component/s: Views
-
Labels:None
After upgrade MariaDB from 10.1.15 to 10.3.7 one view stop working:
CREATE OR REPLACE VIEW first_view AS SELECT o.order_pk FROM second_view AS o LEFT JOIN third_view AS d ON o.order_pk=d.order_pk;
Now return
Unknown column 'd.order_pk' in 'on clause'
If i change LEFT JOIN to RIGHT JOIN no errors.
I have 10.1.15 in the same cluster and this view works fine.
- is duplicated by
-
MDEV-16472 column aliases no longer available in joins
-
- Closed
-