I tried to use solution posted here, but ST_Distance in the Virtual Layer query doesn't work properly in Qgis (v3.2) on Mac, the result is showing blank while the same script is working properly in QGIS (v3.4) on Windows.
Here is my test script for virtual layer:
WITH distances AS( SELECT s.id site_id, a.Mem_ID mem_id, ST_Distance( s.geometry, a.geometry ) dist FROM site_a27 s CROSS JOIN A27_re a ) SELECT * FROM distances
table for site_a27:
table for A27_re:
Mem_ID,Response_X,Response_Y 19960126000178,121.312175,24.987227 19960129000943,121.302705,24.978186 19960131001647,121.303628,24.957379 19960131002543,121.300855,24.984292 19960203000247,121.296974,24.968484
How do I solve this in QGIS on Mac?