https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-10-08T14:34:29ZQGIS Issue TrackingQGIS Application - Bug report #20047: SQL queries on virtual layers frequently crashes QGIShttps://issues.qgis.org/issues/20047?journal_id=940452018-10-08T14:34:29ZAlessandro Pasotti
<ul><li><strong>Subject</strong> changed from <i>dbmanager</i> to <i>SQL queries on virtual layers frequently crashes QGIS</i></li></ul> QGIS Application - Bug report #20047: SQL queries on virtual layers frequently crashes QGIShttps://issues.qgis.org/issues/20047?journal_id=940462018-10-08T14:35:22ZAlessandro Pasotti
<ul><li><strong>Duplicates</strong> <i><a class="issue tracker-1 status-5 priority-5 priority- closed" href="/issues/20029">Bug report #20029</a>: SQL query including "row_number" on a virtual layer crashes QGIS</i> added</li></ul> QGIS Application - Bug report #20047: SQL queries on virtual layers frequently crashes QGIShttps://issues.qgis.org/issues/20047?journal_id=940572018-10-08T20:46:58ZNyall Dawson
<ul></ul><p>If anyone's looking into this, here's my findings:<br />- it's windows only<br />- the exception thrown in sqlite when the expression is invalid is not caught, despite there being code in place to catch this. I've seen this before with msvc builds - it just decides not to catch for some reason.</p>
<p>No idea on how to fix this though!</p> QGIS Application - Bug report #20047: SQL queries on virtual layers frequently crashes QGIShttps://issues.qgis.org/issues/20047?journal_id=940902018-10-09T09:38:43ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>duplicate</i></li><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li></ul><p>see also <a class="issue tracker-1 status-5 priority-5 priority- closed" href="https://issues.qgis.org/issues/20029" title="SQL query including "row_number" on a virtual layer crashes QGIS (Closed)">#20029</a> (edited)</p> QGIS Application - Bug report #20047: SQL queries on virtual layers frequently crashes QGIShttps://issues.qgis.org/issues/20047?journal_id=946412018-10-23T08:44:25ZHugo Mercierhugo.mercier@oslandia.com
<ul></ul><p>Nyall Dawson wrote:</p>
<blockquote>
<p>- the exception thrown in sqlite when the expression is invalid is not caught, despite there being code in place to catch this. I've seen this before with msvc builds - it just decides not to catch for some reason.</p>
</blockquote>
<p>It reminds me of C++ exceptions that are not caught when crossing DLL boundaries and when .exe/.dll are compiled against different versions of the runtime ... don't know if this is related.</p>
<p>I'll try to find details about the exact exception that is not caught</p>