Thursday, January 20, 2022

[FIXED] Why parenthesis around a SELECT change the results?

Issue

So, I have this Query:

SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%'

From which, the results are these:

enter image description here

If I place parenthesis around the Query like this:

(SELECT id, name FROM artist WHERE artist.name LIKE '%feat.%')

From which, the results are these:

enter image description here

The results change! Why? It's not like there is some kind of Order of Operations. It's one SELECT alone sitting there.


Would you like to reproduce it? Here's the link to the database's data and schema.

DB Schema and Data


Solution

Seems like it's a phpmyadmin 4.6.3 bug since it's not something else.



Answered By - Eksapsy

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.