[Qgis-user] SQL Logging in the debugging/development panel - SpatiaLite

[Alessandro Pasotti]

Hi,

Johannes, can you please file a bug report?

On Tue, Oct 11, 2022 at 4:30 PM Johannes Echterhoff via Qgis-user
<qgis-user at lists.osgeo.org> wrote:
>
> Hello,
>
>
>
> Today I tried the SQL logging in the debugging/development panel (a feature introduced through QEP https://github.com/qgis/QGIS-Enhancement-Proposals/issues/242). The database I’m using is a SpatiaLite one. My QGIS version is 3.26.3.
>
>
>
> Should the SQL logging in this case also cover addition of features? Reviewing the statement log produced while adding a feature, I could not find any INSERT statement, just a whole range of SELECT statements and two save point related messages. When I add a feature into a PostgreSQL-based layer instead, the log does contain an INSERT statement.
>
>
>
> The reason I am asking this question is that I am trying to find a way to debug editing features in a SpatiaLite-based layer. We have had the behavior that upon saving a new feature, it completely vanished, without any error message in QGIS – so I’d like to understand which commands were sent to the SQLite database.
>
>
>
> Best regards,
>
> Johannes
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it