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?
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?