[Gambas-bugtracker] Bug #2977: Empty Result object

[<bugtracker@xxxxxxxxxxxxxx>]

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

Omar MORENO reported a new bug.

Summary
-------

Empty Result object

Type             : Bug
Priority         : Medium
Gambas version   : 3.19
Product          : Database component


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

MariaDB Database 10.11.8
Test table:

CREATE TABLE `clientes` (
  `id`        int(11)      NOT NULL AUTO_INCREMENT,
  `nombre`    varchar(100) DEFAULT NULL,
  `direccion` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

The Result object has empty data when the Returning parameter of the Create method of the connection property is triggered

Dim Res as Result
Res = Conn.Create(“clientes”, True, True)
…
Res.Update()

But using the Exec method, the Result does have the data:

Res = Conn.Exec(“INSERT INTO clientes ”
                             “(nombre, direccion) VALUES (&1, &2)”
                             “RETURNING id, nombre;”, “omoreno”,“World”)


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

[System]
Gambas=3.19.5
OperatingSystem=Linux
Distribution=Ubuntu 24.04.1 LTS (Noble Numbat)
Kernel=6.8.0-51-generic
Architecture=x86_64
Cores=4
Memory=7639M
Language=es_PA.UTF-8
Platform=wayland
Desktop=UBUNTU
DesktopResolution=96
DesktopScale=8
WidgetTheme=yaru
Font=Ubuntu Sans,11
[Programs]
dpkg=Programa de gestión de paquetes de Debian `dpkg' versión 1.22.6 (amd64).
gcc=gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0
msgmerge=msgmerge (GNU gettext-tools) 0.21
rpmbuild=RPM version 4.18.2
[Libraries]
Cairo=libcairo.so.2.11800.0
Curl=libcurl.so.4.8.0
DBus=libdbus-1.so.3.32.4
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2409.32
GStreamer=libgstreamer-1.0.so.0.2402.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2409.32
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.134.0.0
QT5=libQt5Core.so.5.15.13
RSvg=librsvg-2.so.2.50.0
SDL=libSDL2-2.0.so.0.3000.0
SQLite 3=libsqlite3.so.0.8.6
[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DEBUGINFOD_URLS=https://debuginfod.ubuntu.com 
DESKTOP_SESSION=ubuntu
DISPLAY=:0
DOTNET_BUNDLE_EXTRACT_BASE_DIR=<home>/.cache/dotnet_bundle_extract
GB_GUI=gb.gtk3
GDMSESSION=ubuntu
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=4743
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GNOME_SETUP_DISPLAY=:1
GNOME_SHELL_SESSION_MODE=ubuntu
GSM_SKIP_SSH_AGENT_WORKAROUND=true
GTK_MODULES=gail:atk-bridge
HOME=<home>
IM_CONFIG_PHASE=1
INVOCATION_ID=b8df0a2d926144deb6dcbe40b220e70b
JOURNAL_STREAM=8:20815
LANG=es_PA.UTF-8
LANGUAGE=es_PA.UTF-8
LC_ADDRESS=es_PA.UTF-8
LC_ALL=es_PA.UTF-8
LC_IDENTIFICATION=es_PA.UTF-8
LC_MEASUREMENT=es_PA.UTF-8
LC_MONETARY=es_PA.UTF-8
LC_NAME=es_PA.UTF-8
LC_NUMERIC=es_PA.UTF-8
LC_PAPER=es_PA.UTF-8
LC_TELEPHONE=es_PA.UTF-8
LC_TIME=es_PA.UTF-8
LOGNAME=<user>
MANAGERPID=2852
MEMORY_PRESSURE_WATCH=/sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/org.gnome.Shell@wayland.service/memory.pressure
MEMORY_PRESSURE_WRITE=c29tZSAyMDAwMDAgMjAwMDAwMAA=
PAPERSIZE=letter
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/snap/bin:<home>/.dotnet/tools
PWD=<home>
QTWEBENGINE_DICTIONARIES_PATH=/usr/share/hunspell-bdic/
QT_ACCESSIBILITY=1
QT_IM_MODULE=ibus
QT_LOGGING_RULES=*.debug=false
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/3086,unix/<hostname>:/tmp/.ICE-unix/3086
SHELL=/bin/bash
SHLVL=0
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
SYSTEMD_EXEC_PID=3121
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WAYLAND_DISPLAY=wayland-0
XAUTHORITY=/run/user/1000/.mutter-Xwaylandauth.0RU7Y2
XDG_ACTIVATION_TOKEN=gnome-shell/Gambas 3/3121-3-<hostname>_TIME809723
XDG_CONFIG_DIRS=/etc/xdg/xdg-ubuntu:/etc/xdg
XDG_CURRENT_DESKTOP=ubuntu:GNOME
XDG_DATA_DIRS=/usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/:/var/lib/snapd/desktop
XDG_MENU_PREFIX=gnome-
XDG_RUNTIME_DIR=/run/user/1000
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=ubuntu
XDG_SESSION_TYPE=wayland
XMODIFIERS=@im=ibus
_=/usr/bin/gnome-session


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