Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.7, 10.3(EOL)
-
None
Description
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.
Attachments
Issue Links
- is duplicated by
-
MDEV-16472 column aliases no longer available in joins
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
3d 17h 48m | 1 |
|
1d 10h 27m | 1 |
|
2d 4h 52m | 1 |
|
11h 59m | 1 |
|
36d 6h | 1 |