https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-06-11T15:47:03ZQGIS Issue TrackingQGIS Application - Bug report #18520: Updating a geometry by trigger in geopackage dbhttps://issues.qgis.org/issues/18520?journal_id=902952018-06-11T15:47:03ZAlessandro Pasotti
<ul><li><strong>Pull Request or Patch supplied</strong> changed from <i>Yes</i> to <i>No</i></li><li><strong>Crashes QGIS or corrupts data</strong> changed from <i>Yes</i> to <i>No</i></li></ul> QGIS Application - Bug report #18520: Updating a geometry by trigger in geopackage dbhttps://issues.qgis.org/issues/18520?journal_id=902962018-06-11T15:47:14ZAlessandro Pasotti
<ul><li><strong>Category</strong> changed from <i>Data Provider/SpatiaLite</i> to <i>Data Provider/OGR</i></li></ul> QGIS Application - Bug report #18520: Updating a geometry by trigger in geopackage dbhttps://issues.qgis.org/issues/18520?journal_id=902982018-06-11T16:11:33ZAlessandro Pasotti
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>As Even suggested:</p>
<p>I think I've an idea of what's going wrong. geom = ST_SetStartPoint(geom, NEW.geom) generates a a spatialite geom, not a GPKG one. Should probably be geom = AsGpkg(ST_SetStartPoint(geom, NEW.geom))</p>
<p>Can you check if this fix the issue?</p> QGIS Application - Bug report #18520: Updating a geometry by trigger in geopackage dbhttps://issues.qgis.org/issues/18520?journal_id=907092018-07-05T17:35:07ZEtienne MOROem@sigmoe.fr
<ul><li><strong>Assignee</strong> set to <i>Alessandro Pasotti</i></li></ul><p>The idea was good, but it's not AsGpgk that I should use, but AsGPB, to transform the geometry into a binary geopackage geometry, and then it works well. So, the right code is:<br />geom = AsGPB(ST_SetStartPoint(geom, NEW.geom))<br />Thank you for the idea.</p> QGIS Application - Bug report #18520: Updating a geometry by trigger in geopackage dbhttps://issues.qgis.org/issues/18520?journal_id=918202018-08-17T12:56:25ZAlessandro Pasotti
<ul><li><strong>Resolution</strong> set to <i>invalid</i></li><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li></ul>