Skip to content

SQLite, empty result when text data is huge (>100kb) #231

@D00mch

Description

@D00mch

What I do

select data from health_record where type = 'HeartRateRecord' limit 1;

Image

Result

Nothing, as on the screen.

Expected result

The folded text of the 'data' that is in the DB
data.json

Logs

Only “returned successfully“ in logs

Logs
2025/09/14 18:46:07 [info]: calling method "DbeeCreateConnection"
2025/09/14 18:46:07 [info]: method "DbeeCreateConnection" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeCreateConnection"
2025/09/14 18:46:07 [info]: method "DbeeCreateConnection" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeCreateConnection"
2025/09/14 18:46:07 [info]: method "DbeeCreateConnection" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetCurrentConnection"
2025/09/14 18:46:07 [info]: method "DbeeGetCurrentConnection" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetCurrentConnection"
2025/09/14 18:46:07 [info]: method "DbeeGetCurrentConnection" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetConnections"
2025/09/14 18:46:07 [info]: method "DbeeGetConnections" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:07 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:07 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetConnections"
2025/09/14 18:46:07 [info]: method "DbeeGetConnections" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:07 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetConnections"
2025/09/14 18:46:07 [info]: method "DbeeGetConnections" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:07 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:07 [info]: calling method "DbeeGetConnections"
2025/09/14 18:46:07 [info]: method "DbeeGetConnections" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeGetCurrentConnection"
2025/09/14 18:46:12 [info]: method "DbeeGetCurrentConnection" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeConnectionExecute"
2025/09/14 18:46:12 [info]: method "DbeeConnectionExecute" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:12 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeCallDisplayResult"
2025/09/14 18:46:12 [info]: method "DbeeCallDisplayResult" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:12 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:12 [info]: calling method "DbeeConnectionGetCalls"
2025/09/14 18:46:12 [info]: method "DbeeConnectionGetCalls" returned successfully
2025/09/14 18:46:16 [info]: calling method "DbeeGetConnections"
2025/09/14 18:46:16 [info]: method "DbeeGetConnections" returned successfully

More info

If I do something like this:

select count(type), * from health_record group by type;

I get empy result. If I get all the fields except of 'data', I get several rows. There are no problems when data is smaller:

System info

macOs 15.6.1
nvim-dbee dda5176

nvim --version
NVIM v0.11.2
Build type: Release
LuaJIT 2.1.1748459687
Run "nvim -V1 -v" for more info

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions