[Gambas-bugtracker] Bug #3053: gb.db2 does not write inserted record to sqlite3 database file

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3053&from=L21haW4-

T. Lee DAVIDSON reported a new bug.

Summary
-------

gb.db2 does not write inserted record to sqlite3 database file

Type             : Bug
Priority         : Medium
Gambas version   : 3.20
Product          : SQLite driver


Description
-----------

The result of using a SQL INSERT query to insert one record into a table results in the file on disk not being updated. This is verified by the 'sqlite3' command line utility and a graphical SQLite browser. A re-run of the project also shows that the update was not stored to disk.

A DataSource using a compound SELECT on that table does get updated while the project is running (with DataSource.Update). And, a subsequent attempt to insert the very same record causes a UNIQUE constraint violation due to that attribute on a foreign key of the table. It is almost as if the update is stored only in memory.

The same project works as expected with gb.db on Gambas 3.18.0 on Debian 12.


System information
------------------

[System]
Gambas=3.20.3
OperatingSystem=Linux
Distribution=Manjaro Linux 
Kernel=6.12.28-1-MANJARO
Architecture=x86_64
Cores=6
Memory=15986M
Language=en_US.UTF-8
Platform=x11
Desktop=KDE
DesktopResolution=96
DesktopScale=7
WidgetTheme=breeze
Font=Noto Sans,10
DarkTheme=False
[Programs]
clang=clang version 19.1.7
gcc=gcc (GCC) 15.1.1 20250425
git=git version 2.49.0
msgmerge=msgmerge (GNU gettext-tools) 0.25
[Libraries]
Cairo=libcairo.so.2.11804.4
Curl=libcurl.so.4.8.0
DBus=libdbus-1.so.3.38.3
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2417.32
GStreamer=libgstreamer-1.0.so.0.2601.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2417.32
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.149.0.0
QT5=libQt5Core.so.5.15.16
QT6=libQt6Core.so.6.9.0
RSvg=librsvg-2.so.2.60.0
SDL=libSDL2-2.0.so.0.3200.56
SQLite3=libsqlite3.so.3.49.2
[Environment]
CASROOT=/usr
CSF_DrawPluginDefaults=/usr/share/opencascade/resources/DrawResources
CSF_EXCEPTION_PROMPT=1
CSF_IGESDefaults=/usr/share/opencascade/resources/XSTEPResource
CSF_LANGUAGE=us
CSF_MDTVTexturesDirectory=/usr/share/opencascade/resources/Textures
CSF_MIGRATION_TYPES=/usr/share/opencascade/resources/StdResource/MigrationSheet.txt
CSF_OCCTResourcePath=/usr/share/opencascade/resources
CSF_PluginDefaults=/usr/share/opencascade/resources/StdResource
CSF_SHMessage=/usr/share/opencascade/resources/SHMessage
CSF_STEPDefaults=/usr/share/opencascade/resources/XSTEPResource
CSF_ShadersDirectory=/usr/share/opencascade/resources/Shaders
CSF_StandardDefaults=/usr/share/opencascade/resources/StdResource
CSF_StandardLiteDefaults=/usr/share/opencascade/resources/StdResource
CSF_TObjDefaults=/usr/share/opencascade/resources/StdResource
CSF_TObjMessage=/usr/share/opencascade/resources/TObj
CSF_XCAFDefaults=/usr/share/opencascade/resources/StdResource
CSF_XSMessage=/usr/share/opencascade/resources/XSMessage
CSF_XmlOcafResource=/usr/share/opencascade/resources/XmlOcafResource
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/<user>/1000/bus
DEBUGINFOD_URLS=https://debuginfod.archlinux.org 
DESKTOP_SESSION=plasma
DISPLAY=:0
DRAWDEFAULT=/usr/share/opencascade/resources/DrawResources/DrawDefault
DRAWHOME=/usr/share/opencascade/resources/DrawResources
GB_GUI=gb.qt6
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:<home>/.gtkrc-2.0:<home>/.config/gtkrc-2.0
GTK3_MODULES=xapp-gtk3-module
GTK_MODULES=canberra-gtk-module
GTK_RC_FILES=/etc/gtk/gtkrc:<home>/.gtkrc:<home>/.config/gtkrc
HOME=<home>
ICEAUTHORITY=/run/<user>/1000/iceauth_EbVRtc
INVOCATION_ID=8e54947be57d47b591cbf336bd03b501
JOURNAL_STREAM=9:13701
KDE_APPLICATIONS_AS_SCOPE=1
KDE_FULL_SESSION=true
KDE_SESSION_UID=1000
KDE_SESSION_VERSION=6
LANG=en_US.UTF-8
LANGUAGE=en_US.UTF-8
LC_ADDRESS=en_US.UTF-8
LC_IDENTIFICATION=en_US.UTF-8
LC_MEASUREMENT=en_US.UTF-8
LC_MONETARY=en_US.UTF-8
LC_NAME=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_PAPER=en_US.UTF-8
LC_TELEPHONE=en_US.UTF-8
LC_TIME=en_US.UTF-8
LOGNAME=<user>
MAIL=/var/spool/mail/<user>
MANAGERPID=823
MEMORY_PRESSURE_WATCH=/sys/fs/cgroup/<user>.slice/<user>-1000.slice/<user>@1000.service/session.slice/plasma-plasmashell.service/memory.pressure
MEMORY_PRESSURE_WRITE=c29tZSAyMDAwMDAgMjAwMDAwMAA=
MMGT_CLEAR=1
MOTD_SHOWN=pam
PAM_KWALLET5_LOGIN=/run/<user>/1000/kwallet5.socket
PATH=<home>/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/bin:/var/lib/flatpak/exports/bin:/usr/lib/jvm/default/bin:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl:<home>/.nimble/bin
PWD=<home>
QT_AUTO_SCREEN_SCALE_FACTOR=0
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_LOGGING_RULES=*.debug=false
QT_WAYLAND_RECONNECT=1
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/945,unix/<hostname>:/tmp/.ICE-unix/945
SHELL=/bin/bash
SYSTEMD_EXEC_PID=969
TZ=:/etc/localtime
USER=<user>
XAUTHORITY=/tmp/xauth_QmmfhO
XDG_CONFIG_DIRS=<home>/.config/kdedefaults:/etc/xdg:/usr/share/manjaro-kde-settings/xdg
XDG_CURRENT_DESKTOP=KDE
XDG_DATA_DIRS=<home>/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
XDG_MENU_PREFIX=plasma-
XDG_RUNTIME_DIR=/run/<user>/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/free<hostname>/DisplayManager/Seat0
XDG_SESSION_CLASS=<user>
XDG_SESSION_DESKTOP=KDE
XDG_SESSION_ID=2
XDG_SESSION_PATH=/org/free<hostname>/DisplayManager/Session1
XDG_SESSION_TYPE=x11
XDG_VTNR=2


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----