Skip to content

sqlite3 does not apply limit? #956

@fuzzy76

Description

@fuzzy76

What happened?

SELECT uuid FROM TMTask WHERE project='BwcQ91hS4C9fQaUZGMWDmT' AND status IN (2,3) ORDER BY stopDate DESC LIMIT 10;

From the query editor returns all rows it can find (806 in my case).

Expected behavior

10 rows, just like I get when I run the query from my terminal:

fuzzy76@Havard-sin-Mac-mini:~/repos/things3export % sqlite3 
SQLite version 3.51.0 2025-06-12 13:14:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open main.sqlite
sqlite> SELECT uuid FROM TMTask WHERE project='BwcQ91hS4C9fQaUZGMWDmT' AND status IN (2,3) ORDER BY stopDate DESC LIMIT 10;
SEF7iW5HMFZmoGoPWLWzVX
KUQxLX5wbTpPrHK368hbJA
VaBWgVbpibp2UNFgXXqkUx
HENVc28D9TLP7nuRFEWsgV
T92seQtp7pZrNprUfFTQUS
3GZ2ooceCBACWrPJpSDoFj
RkMfNi7cfXRhr8Mk1iQRpa
RBqjmfZBcbSYFUHYxm2CP5
VP6LeW7E8RwiBp4iwFQf7J
VVi2pjniPy4fKvFpk5HJro
sqlite>

Database type

SQLite

TablePro version

0.36.0

macOS version & chip

Tahoe 26.4.1 on M2

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions