{"action":"created","issue":{"url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/1","labels_url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/1/comments","events_url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/1/events","html_url":"https://github.com/opengeospatial/ets-sfs11/issues/1","id":100782164,"number":1,"title":"SFSQL 1.1 Compliance Test Suite - Types and Functions T40, T49 and T50 queries do not return expected result.","user":{"login":"telmessos","id":13782813,"avatar_url":"https://avatars.githubusercontent.com/u/13782813?v=3","gravatar_id":"","url":"https://api.github.com/users/telmessos","html_url":"https://github.com/telmessos","followers_url":"https://api.github.com/users/telmessos/followers","following_url":"https://api.github.com/users/telmessos/following{/other_user}","gists_url":"https://api.github.com/users/telmessos/gists{/gist_id}","starred_url":"https://api.github.com/users/telmessos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telmessos/subscriptions","organizations_url":"https://api.github.com/users/telmessos/orgs","repos_url":"https://api.github.com/users/telmessos/repos","events_url":"https://api.github.com/users/telmessos/events{/privacy}","received_events_url":"https://api.github.com/users/telmessos/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/opengeospatial/ets-sfs11/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-13T14:26:13Z","updated_at":"2015-09-08T10:49:39Z","closed_at":null,"body":"I created a database using the schemas given (Replaced some parts of them with PostGIS versions.)\r\n\r\nI executed the queries one by one. Most of them works fine. But T40 does not return the expected result. \r\n\r\nAnd queries T49 and T50 which are st_union and SymmetricDifference functions returns requested result plus the geometries of the selected two objects. \r\n\r\nPlease see the database schema follows https://gist.github.com/telmessos/5f194c7d9c9cf49c256f"},"comment":{"url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/comments/138515151","html_url":"https://github.com/opengeospatial/ets-sfs11/issues/1#issuecomment-138515151","issue_url":"https://api.github.com/repos/opengeospatial/ets-sfs11/issues/1","id":138515151,"user":{"login":"telmessos","id":13782813,"avatar_url":"https://avatars.githubusercontent.com/u/13782813?v=3","gravatar_id":"","url":"https://api.github.com/users/telmessos","html_url":"https://github.com/telmessos","followers_url":"https://api.github.com/users/telmessos/followers","following_url":"https://api.github.com/users/telmessos/following{/other_user}","gists_url":"https://api.github.com/users/telmessos/gists{/gist_id}","starred_url":"https://api.github.com/users/telmessos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/telmessos/subscriptions","organizations_url":"https://api.github.com/users/telmessos/orgs","repos_url":"https://api.github.com/users/telmessos/repos","events_url":"https://api.github.com/users/telmessos/events{/privacy}","received_events_url":"https://api.github.com/users/telmessos/received_events","type":"User","site_admin":false},"created_at":"2015-09-08T10:49:39Z","updated_at":"2015-09-08T10:49:39Z","body":"It seems to be a problem about the difference between OpenGIS Within function and PostGIS ST_Within function.\r\n\r\nOpenGIS Within Function\r\nWithin(A:B):Integer — Returns 1 (TRUE) if this B is ‘spatially within’ A.\r\n\r\nPostGIS ST_Within Function\r\nboolean ST_Within(geometry A, geometry B); Returns true if the geometry A is completely inside geometry B\r\n\r\nSo the order of the geometry must be opposite in these two functions.\r\n\r\n@bermud if it is ok for you I'll close the question."}}