Skip to content

Disk I/O error with GROUP BY clause #28

@Vinayaksma

Description

@Vinayaksma

@siara-cc
I am encountering an I/O disk error when executing queries with a GROUP BY clause, especially when there is a large amount of data involved. After reviewing the issue list for the andrino library, I found that this problem has already been addressed and resolved, as detailed in siara-cc/esp32_arduino_sqlite3_lib#81. The resolution involved ensuring the creation of a temporary file if it was not created initially.

I kindly request that the same fix be implemented for the idf-sqlite3 library.

Additionally, I have noticed that the SQLite3 version in the idf-sqlite3 library is "3.25.2", which is significantly outdated compared to the version used in the andrino-sqlite3 library ("3.43.2"). Please update the SQLite3 version in the idf-sqlite3 library to the latest version.

Thank you for your attention to these matters. I look forward to your response.

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