Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Problem with table joining order on incremental view refresh. #127

Open
50karol opened this issue Sep 7, 2015 · 2 comments
Open

Problem with table joining order on incremental view refresh. #127

50karol opened this issue Sep 7, 2015 · 2 comments
Labels
bug Flexviews

Comments

@50karol
Copy link

50karol commented Sep 7, 2015

There is a possibility for situation in which you can enable a incremental view, but cannot refresh it due to wrong order of tables being joined and 'unknown column' exception.

I resolved the situation by editing delta.sql file on line 655, originally it ordered the tables by idx, i changed it to mview_join_order ASC, mview_table_id ASC, idx;.

My problem was solved by this, can you confirm if this is a bug.
This was referenced Sep 8, 2015
Closed
Closed
@greenlion
Copy link
Owner

Thanks for the report. I'll add your fix shortly.

@greenlion
Copy link
Owner

TODO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Flexviews
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@greenlion @50karol