[Gambas-bugtracker] Bug #2923: gb.db2 Possible bug in Connection.Exec

[<bugtracker@xxxxxxxxxxxxxx>]

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

Gianluigi GRADASCHI reported a new bug.

Summary
-------

gb.db2 Possible bug in Connection.Exec

Type             : Bug
Priority         : Medium
Gambas version   : Unknown
Product          : Unknown


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

Hi Benoit,

to avoid burdening the bugtracker, I continue to refer to the project here:
http://gambaswiki.org/bugtracker/edit?object=BUG.2915&from=L21haW4
Previously, when creating a new record (for example Minnie), running the btnRegistration subroutine worked, now I get the error: near "LIMIT".
If active: db.Debug, in console I get:
gb.db.sqlite3: BEGIN
gb.db.sqlite3: SELECT MAX(students_id) FROM students; LIMIT 1
gb.db.sqlite3: ROLLBACK

Regards


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

[System]
Gambas=3.19.90 3c3196f (master)
OperatingSystem=Linux
Distribution=Linux Mint 21.3 (Virginia)
Kernel=5.15.0-107-generic
Architecture=x86_64
Cores=16
Memory=32000M
Language=it_IT.UTF-8
Platform=x11
Desktop=CINNAMON
DesktopResolution=96
DesktopScale=7
WidgetTheme=mint-y-aqua
Font=Ubuntu,10
[Programs]
appimage-builder=appimage-builder: 1.1.0
dpkg=Debian "dpkg", programma di gestione dei pacchetti versione 1.21.1 (amd64).
gcc=gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0
git=git version 2.34.1
msgmerge=msgmerge (GNU gettext-tools) 0.21
pngquant=2.12.2 (July 2019)
[Libraries]
Cairo=libcairo.so.2.11600.0
Curl=libcurl.so.4.7.0
DBus=libdbus-1.so.3.19.13
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2404.29
GStreamer=libgstreamer-1.0.so.0.2003.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2404.29
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.118.0.0
QT5=libQt5Core.so.5.15.3
QT6=libQt6Core.so.6.2.4
RSvg=librsvg-2.so.2.48.0
SDL=libSDL2-2.0.so.0.18.2
SQLite3=libsqlite3.so.0.8.6
[Environment]
CINNAMON_VERSION=6.0.4
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.gtk3
GDMSESSION=cinnamon
GDM_LANG=it
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=164921
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK3_MODULES=xapp-gtk3-module
GTK_MODULES=gail:atk-bridge
HOME=/home/<hostname>
LANG=it_IT.UTF-8
LANGUAGE=it_IT.UTF-8
LIBVIRT_DEFAULT_URI=qemu:///system
LOGNAME=<hostname>
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
PWD=/home/<hostname>
QT_ACCESSIBILITY=1
QT_LOGGING_RULES=*.debug=false
QT_QPA_PLATFORMTHEME=qt5ct
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1988,unix/<hostname>:/tmp/.ICE-unix/1988
SHELL=/bin/bash
SHLVL=0
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<hostname>
XAUTHORITY=/home/<hostname>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
XDG_CURRENT_DESKTOP=X-Cinnamon
XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:/home/<hostname>/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
XDG_GREETER_DATA_DIR=/var/lib/lightdm-data/<hostname>
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c2
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
XDG_SESSION_TYPE=x11
XDG_VTNR=7


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