MySQL Forums
Forum List  »  Views

Creating Views problem in 5.6/5.7
Posted by: Kavitha K P
Date: June 22, 2017 02:12PM

Hi,

In mysql 5.5, I have created a view(slickval) that is created based on other two views(bslick,rslick) in the database . This slickval view has 13 columns . It is running fine in this version. I am copying the same view to a database which uses 5.6 version and the view is not working anymore . I am getting time out error. The same thing happens when I use 5.7 version.

In 5.6/5.7 mysql version, in the view if i reduce the number of columns from 13 to 10 the view runs fine. For some reason, it is not able to take 13 columns which is really odd .

Is there a limitation on the number of columns a view can have in 5.6/5.7 ?

Can someone pls assist ?

Thanks,
Kavitha.

Options: ReplyQuote


Subject
Views
Written By
Posted
Creating Views problem in 5.6/5.7
1048
June 22, 2017 02:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.