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

6468

6y

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

xonya

5149

6y

@JKyll At least 130 persons have had this issue:

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

BillLumbergh

6468

6y

@xonya that's weird, try reinstalling?
0

mlamboms

465

6y

been there done that
4

Cyanide

13911

6y

*sees green text on black*

Oh hey! You are a hacker!
1

xonya

5149

6y

@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

5149

6y

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

BillLumbergh

6468

6y

@xonya it is funny tho
0

FMashiro

3372

6y

It's because of the in clause.

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

C0D4

69514

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