Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Works in 5.6 doesn’t work in 5.7

user10647930Mar 16 2017 — edited Mar 17 2017

Hi,

Some of the queries work in 5.6 and but not on 5.7.

Basically the only difference between the two is the parenthesis in the second query around the first select with the LIMIT.

Without parenthesis they work in 5.6 but if i use on 5.7 i am getting error:

ERROR 1221 (HY000): Incorrect usage of UNION and LIMIT

any idea how to get this fixed.

This post has been answered by User9141645-Oracle on Mar 16 2017
Jump to Answer

Comments

Processing

Post Details

Added on Mar 16 2017
2 comments
912 views