Skip to content

Disk I/O error with GROUP BY clause #28

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
Vinayaksma opened this issue Jul 1, 2024 · 0 comments
Open

Disk I/O error with GROUP BY clause #28

Vinayaksma opened this issue Jul 1, 2024 · 0 comments

Comments

@Vinayaksma
Copy link

@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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant