Repository navigation
The list of available functions in the current SQL engine #34
Description
Please allow me to create one more issue.
I was trying the ExecuteSQL endpoint yesterday and found the following script not working:
SELECT * FROM ( SELECT *, 3440.065 * 2 * ASIN( SQRT( POWER(SIN(RADIANS(navaid_latitude - 21.77) / 2), 2) + COS(RADIANS(21.77)) * COS(RADIANS(navaid_latitude)) * POWER(SIN(RADIANS(navaid_longitude + 72.27) / 2), 2) ) ) AS distance_nm FROM tbl_d_vhfnavaids ) AS t WHERE distance_nm <= 200 ORDER BY distance_nm ASC LIMIT 5;
Description: Get a list of navaids based on the input location, and then order the navaids based on the distance. And finally limit it by 5 records.
According to my test, it seems that some of the SQLite functions used here are not supported in the wasm.
Is it possible to provide a list of supported functions?
Activity
pepperoni505 commentedon Nov 24, 2025
Hi,
It looks like we actually didn't have the math functions enabled in the bundled SQLite version. We have corrected that in #35. I tested your statement on my end and it works now.
As for a thorough list, we don't really have a nice way of getting that aside from looking at the build flags in this file.
Please let us know if you notice any other missing functions, as it is likely we just need to enable them.
/ Jack
pepperoni505 commentedon Dec 8, 2025
Hi @Kuailun,
Following up on this, did our fix resolve your issue?
Kuailun commentedon Dec 30, 2025
Yeap it is good now. Thanks!
Sorry for the late response.