https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-07-15T23:31:11ZQGIS Issue TrackingQGIS Application - Bug report #19419: QGIS 3.2 crashes when preparing a QSqlQuery with PyQGIShttps://issues.qgis.org/issues/19419?journal_id=908702018-07-15T23:31:11ZJürgen Fischerjef@norbit.de
<ul><li><strong>Assignee</strong> set to <i>Jürgen Fischer</i></li></ul> QGIS Application - Bug report #19419: QGIS 3.2 crashes when preparing a QSqlQuery with PyQGIShttps://issues.qgis.org/issues/19419?journal_id=908722018-07-16T06:35:41ZJochen Schwarzejochen.schwarze@live.unigis.net
<ul></ul><p>seems to work at first sight when using QSQLITE driver instead of QSPATIALITE but this does of course not work when geometry involved in queries:</p>
<p><code>>>>db = QSqlDatabase.addDatabase('QSPATIALITE')</code><br /><code>>>>db.setDatabaseName('C:\\tmp\\test.sqlite')</code><br /><code>>>>db.open()</code><br /><code>True</code><br /><code>q = QSqlQuery('select some_int, geometry from test', db)</code><br /><code>>>>while q.next():</code><br /> <code>>>>... print(q.value(0), q.value(1))</code><br /><code>>>>q.lastError().text()</code><br /><code>'no such table: test Unable to execute statement'</code></p> QGIS Application - Bug report #19419: QGIS 3.2 crashes when preparing a QSqlQuery with PyQGIShttps://issues.qgis.org/issues/19419?journal_id=908752018-07-16T20:42:34ZJürgen Fischerjef@norbit.de
<ul><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>Applied in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/6551913aa499b02f4b6de1090cd350abe0bce16d" title="qspatialite: 'update' qt5 port (fixes #19419)">qgis|6551913aa499b02f4b6de1090cd350abe0bce16d</a>.</p>