Cannot execute queries with JOIN operator

[Bas1950]

First of all thanks for the excellent work!
Now my problem is that I cannot get a query executing that has a JOIN. All simple queries run fine!

Example:
when I run Q1:
"SELECT AF.ROWID,AF.NAME FROM AIRFIELDS AF WHERE AF.ROWID = 30"
it calls the callback and returns the row

when I run Q2:
"SELECT AF.ROWID,AF.NAME FROM AIRFIELDS AF INNER JOIN AF_DIST AFD ON AF.ROWID = AFD.AF_ROWID WHERE AF.ROWID = 30"
it does not call the callback.

BTW Q2 runsfine in SQLiteStudio (3.4.13)

Please help

[siara-cc]

Hi, Only reason I can think of is that the result set is quite large, even then it I think it should call back.

Can you try running the query on the sqlite_web_console example which is based on sqlite3_step instead of callback?

[Bas1950]

Hi Arun, thanks for the quick response! The result set has only 50 records, so that should be no problem. I think the problem lies in the config_ext.h or in my Arduino IDE. I encounter more problems: from within the Arduino program * I cannot use any functions like SQRT or POWER. * When I define a trigger, the program crashes All of the above work fine in SQLiteStudio So the problem is either my IDE or the library. I really appreciate your help!! Thanks, Bas van de Pavert From: Arun (Arundale Ramanathan) ***@***.***> Sent: maandag 3 februari 2025 03:01 To: siara-cc/esp32_arduino_sqlite3_lib ***@***.***> Cc: Bas1950 ***@***.***>; Author ***@***.***> Subject: Re: [siara-cc/esp32_arduino_sqlite3_lib] Cannot execute queries with JOIN operator (Issue #100) Hi, Only reason I can think of is that the result set is quite large, even then it I think it should call back. Can you try running the query on the sqlite_console example which is based on sqlite3_step instead of callback? — Reply to this email directly, view it on GitHub <#100 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAPQTFRIT7EHTQLZMFWWLCL2N3EVBAVCNFSM6AAAAABWKY7INWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMRZG4ZDOOBXGY> . You are receiving this because you authored the thread. <https://github.com/notifications/beacon/BAPQTFUKB6RCHEE7PIE76GT2N3EVBA5CNFSM6AAAAABWKY7INWWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTU4XZ3II.gif> Message ID: ***@***.*** ***@***.***> >

[siara-cc]

@Bas1950 You might load the sqlite3_console example given with this lib and run different queries on different tables to figure out what the problem could be.