{"action":"created","issue":{"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/10","repository_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg","labels_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/10/comments","events_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/10/events","html_url":"https://github.com/opengeospatial/ets-gpkg12-nsg/issues/10","id":307986760,"number":10,"title":"No Such Function: ST_MinX","user":{"login":"abucklecslt","id":22097392,"avatar_url":"https://avatars1.githubusercontent.com/u/22097392?v=4","gravatar_id":"","url":"https://api.github.com/users/abucklecslt","html_url":"https://github.com/abucklecslt","followers_url":"https://api.github.com/users/abucklecslt/followers","following_url":"https://api.github.com/users/abucklecslt/following{/other_user}","gists_url":"https://api.github.com/users/abucklecslt/gists{/gist_id}","starred_url":"https://api.github.com/users/abucklecslt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abucklecslt/subscriptions","organizations_url":"https://api.github.com/users/abucklecslt/orgs","repos_url":"https://api.github.com/users/abucklecslt/repos","events_url":"https://api.github.com/users/abucklecslt/events{/privacy}","received_events_url":"https://api.github.com/users/abucklecslt/received_events","type":"User","site_admin":false},"labels":[{"id":802103620,"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/labels/question","name":"question","color":"cc317c","default":true},{"id":868097614,"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/labels/status:waiting","name":"status:waiting","color":"e6e6e6","default":false}],"state":"open","locked":false,"assignee":{"login":"jyutzler","id":3401345,"avatar_url":"https://avatars1.githubusercontent.com/u/3401345?v=4","gravatar_id":"","url":"https://api.github.com/users/jyutzler","html_url":"https://github.com/jyutzler","followers_url":"https://api.github.com/users/jyutzler/followers","following_url":"https://api.github.com/users/jyutzler/following{/other_user}","gists_url":"https://api.github.com/users/jyutzler/gists{/gist_id}","starred_url":"https://api.github.com/users/jyutzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jyutzler/subscriptions","organizations_url":"https://api.github.com/users/jyutzler/orgs","repos_url":"https://api.github.com/users/jyutzler/repos","events_url":"https://api.github.com/users/jyutzler/events{/privacy}","received_events_url":"https://api.github.com/users/jyutzler/received_events","type":"User","site_admin":false},"assignees":[{"login":"jyutzler","id":3401345,"avatar_url":"https://avatars1.githubusercontent.com/u/3401345?v=4","gravatar_id":"","url":"https://api.github.com/users/jyutzler","html_url":"https://github.com/jyutzler","followers_url":"https://api.github.com/users/jyutzler/followers","following_url":"https://api.github.com/users/jyutzler/following{/other_user}","gists_url":"https://api.github.com/users/jyutzler/gists{/gist_id}","starred_url":"https://api.github.com/users/jyutzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jyutzler/subscriptions","organizations_url":"https://api.github.com/users/jyutzler/orgs","repos_url":"https://api.github.com/users/jyutzler/repos","events_url":"https://api.github.com/users/jyutzler/events{/privacy}","received_events_url":"https://api.github.com/users/jyutzler/received_events","type":"User","site_admin":false},{"login":"keshav-nangare","id":14732650,"avatar_url":"https://avatars1.githubusercontent.com/u/14732650?v=4","gravatar_id":"","url":"https://api.github.com/users/keshav-nangare","html_url":"https://github.com/keshav-nangare","followers_url":"https://api.github.com/users/keshav-nangare/followers","following_url":"https://api.github.com/users/keshav-nangare/following{/other_user}","gists_url":"https://api.github.com/users/keshav-nangare/gists{/gist_id}","starred_url":"https://api.github.com/users/keshav-nangare/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keshav-nangare/subscriptions","organizations_url":"https://api.github.com/users/keshav-nangare/orgs","repos_url":"https://api.github.com/users/keshav-nangare/repos","events_url":"https://api.github.com/users/keshav-nangare/events{/privacy}","received_events_url":"https://api.github.com/users/keshav-nangare/received_events","type":"User","site_admin":false}],"milestone":null,"comments":10,"created_at":"2018-03-23T11:05:30Z","updated_at":"2018-04-12T21:28:51Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI ran the NSG GeoPackage 2.1 test from the OGC Validation Web Site against a geopackage. The NSG Data Validity test case failed with the following error:\r\n\r\n\"java.sql.SQLException: \r\n[SQLITE_ERROR] SQL error or missing database (no such function: ST_MinX)\"\r\n\r\nI believe it may be an issue with the NSG GeoPackage 2.1 test case. The function ST_MinX() should be supplied when loading the SpatiaLite drivers. Maybe the loading of the SpatiaLite drivers are failing when the test case is ran."},"comment":{"url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/comments/380950121","html_url":"https://github.com/opengeospatial/ets-gpkg12-nsg/issues/10#issuecomment-380950121","issue_url":"https://api.github.com/repos/opengeospatial/ets-gpkg12-nsg/issues/10","id":380950121,"user":{"login":"gtrenum","id":8433389,"avatar_url":"https://avatars3.githubusercontent.com/u/8433389?v=4","gravatar_id":"","url":"https://api.github.com/users/gtrenum","html_url":"https://github.com/gtrenum","followers_url":"https://api.github.com/users/gtrenum/followers","following_url":"https://api.github.com/users/gtrenum/following{/other_user}","gists_url":"https://api.github.com/users/gtrenum/gists{/gist_id}","starred_url":"https://api.github.com/users/gtrenum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtrenum/subscriptions","organizations_url":"https://api.github.com/users/gtrenum/orgs","repos_url":"https://api.github.com/users/gtrenum/repos","events_url":"https://api.github.com/users/gtrenum/events{/privacy}","received_events_url":"https://api.github.com/users/gtrenum/received_events","type":"User","site_admin":false},"created_at":"2018-04-12T21:28:51Z","updated_at":"2018-04-12T21:28:51Z","author_association":"NONE","body":"Please accept my apologies in advance for the length of this comment.\r\n\r\nThe earlier comment \"The function ST_MinX() should be supplied when loading the SpatiaLite drivers. Maybe the loading of the SpatiaLite drivers are failing when the test case is ran.\" Is relevant, but not complete. The ST_Geometry function calls are included in the Spatialite extensions and are not native to SQLite. The NSG and OGC standards for GeoPackages specifically call out the ST_MinX and several other ST_Geometry functions in their tests. However, the test code does not include the Spatialite extensions to the SQLite database and so we would expect all of the ST_Geometry function calls to behave similarly. It is also worth noting that the current NSG test code making the calls to ST_MinX etc. is performing this test on the features. This is the only 'feature' test in the NSG GeoPackage test code.\r\n\r\nThere has been discussion about not wanting the NSG standards to have any GeoPackage tools dependent on the full Spatialite extensions. However, the way the standard is written, it is explicitly dependent on them (see the SQL test statements). Also, while the NSG Standard or GeoPackage explicity calls out SQLite support, is does not explicitly mention Spatialite extensions. The way the GeoPackage test tools are all coded, SQLite is opened in a manner that does not allow extensions. The GeoPackage standards do call out the \"GeoPackage SQLite Configuration\" settings and those settings do not include the settings needed for extensions. This part of the standard should be corrected to allow for extensions if the previously described extensions are really wanted.\r\n\r\nAs far as corrective action is concerned, we see two options; either update the test code to include the Spatialite extensions or write custom extensions/custom code to support the functionality needed to execute the NSG Profile tests.\r\n"}}
{"actor":{"display_login":"gtrenum"}}