mysql - This is one of the most unexpected, silly and ridiculous behaviors of MySQL: it doesn't support LIMIT in sub-queries, ho - devRant

Ranter

Comments

0

BillLumbergh

6359

7y

Never had that issue, did you check the docs?
4

xonya

5080

7y

@JKyll At least 130 persons have had this issue:

https://stackoverflow.com/questions...
0

BillLumbergh

6359

7y

@xonya that's weird, try reinstalling?
0

mlamboms

459

7y

been there done that
4

Cyanide

13590

7y

*sees green text on black*

Oh hey! You are a hacker!
1

xonya

5080

7y

@Cyanide I have to be honest: I use that color scheme only on the terminal; on the editor I use the light theme. ¯\_(ツ)_/¯
3

xonya

5080

7y

@JKyll It's the same also in production server. It's a known issue. I found it funny though.
1

BillLumbergh

6359

7y

@xonya it is funny tho
0

FMashiro

3331

7y

It's because of the in clause.

Also, it seems weird to limit instead of filter to get a range...
2

C0D4

66902

6y

Been down that road before, then when you need to do sorting on that sub select, mariaDB goes Nope, you got to limit that shit! 😓

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service