I created a polygon using Iso-Area as polygons algorithm in QGIS. I have a point's coordinates and added it as a vector layer into QGIS. It is shown on the map that the point lies within the polygon. Then I wanted to create a dummy variable that indicates that the point lies inside the polygon. Using what I found in the following link I created a Virtual Layer by applying this query (
'A' is the point layer and
'B' is the polygon layer):
SELECT A.*, st_within(A.geometry, B.geometry) AS dummy FROM A, B
But the value of the created dummy variable is
0, while the point is inside the polygon. What is the solution?