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
Field | Original Value | New Value |
---|---|---|
Affects Version/s | 10.3.7 [ 23005 ] |
Component/s | Views [ 10111 ] |
Labels | need_feedback |
Labels | need_feedback |
Assignee | Alice Sherepa [ alice ] |
Attachment | 16420.sql [ 45720 ] |
Assignee | Alice Sherepa [ alice ] | Oleksandr Byelkin [ sanja ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 10.3 [ 22126 ] |
Affects Version/s | 10.3 [ 22126 ] |
Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Link |
This issue relates to |
Link |
This issue is duplicated by |
Link |
This issue relates to |
Assignee | Igor Babaev [ igor ] | Oleksandr Byelkin [ sanja ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
Fix Version/s | 10.3.8 [ 23113 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 87723 ] | MariaDB v4 [ 154482 ] |