search

siara-cc / esp32_arduino_sqlite3_lib

Sqlite3 Arduino library for ESP32
Apache License 2.0
350 stars 66 forks source link

Delete Limit issue "parser stack overflow" #74

Open 41linea45 opened 11 months ago

41linea45 commented 11 months ago

DELETE FROM HISTORYWHERE ID IN (SELECT ID FROM HISTORY WHERE ID LIMIT 1 ) SQL error: parser stack overflow Time taken:2444

Hello, Firstly thank you for amazing library.

I tried delete and limit in sql. it gives error. Normally, this sql command works in sqlite studio. How can i use delete and limit in sql command? Thanks for advance.

outcastdreamer commented 8 months ago

I also have questions regarding this error "Parser stack overflow". What queries or operations are causing this error to occur? I believe the queries that cause this error should be mentioned under the "Limitations" section of the documentation. Also any workaround to it if possible. Amazing library still! It has made file handling redundant in my project!