[Gambas-bugtracker] Bug #3018: gb.DB2 error on Fixed Columns

[<bugtracker@xxxxxxxxxxxxxx>]

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

Omar MORENO reported a new bug.

Summary
-------

gb.DB2 error on Fixed Columns

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


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

When queries are run with calculated or fixed fields, an error is generated indicating that the field is unknown.
Examples:

With SQLite:

  ResSqlite = ConnSqlite.Exec("SELECT *, 'X' as 'DataX' FROM clientes")

Then we want to display the data from the DataX field:

  ResSqlite.MoveFirst()
  Message.Info(ResSqlite["DataX"])

Everything is 100% correct.

But in MariaDB:

  ResMariaDB = ModSql.ConnMariaDB.Exec("SELECT *, " 
              "CASE nombre WHEN 'omoreno' THEN 'USUARIO' "
              "ELSE 'LENGUAJE' END AS 'DataX' FROM clientes")

Then we want to display the data from the DataX field:

  ResMariaDB.MoveFirst()
  Message.Info(ResMariaDB["DataX"])

Here, the error message is generated: Unknown Field: 'DataX'.
Looking at the program interruption, you can see that MariaDB's fixed fields are marked with a period:

See attached images.

Thank you for your possible answers.


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

[System]
Gambas=3.20.2 972c02e (master)
OperatingSystem=Linux
Distribution=Ubuntu 24.04.2 LTS (Noble Numbat)
Kernel=6.11.0-21-generic
Architecture=x86_64
Cores=8
Memory=13896M
Language=es_PA.UTF-8
Platform=wayland
Desktop=UBUNTU
DesktopResolution=96
DesktopScale=8
WidgetTheme=yaru
Font=Ubuntu Sans,11
DarkTheme=False
[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
QT6=libQt6Core.so.6.4.2
RSvg=librsvg-2.so.2.50.0
SDL=libSDL2-2.0.so.0.3000.0
SQLite3=libsqlite3.so.0.8.6
[Environment]
CLUTTER_DISABLE_MIPMAPPED_TEXT=1
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=4236
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=221d81998b5b49ba9a51655d273df69e
JOURNAL_STREAM=9:25802
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=3036
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=<home>/.cargo/bin:/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/3275,unix/<hostname>:/tmp/.ICE-unix/3275
SHELL=/bin/bash
SHLVL=0
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
SYSTEMD_EXEC_PID=3305
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WAYLAND_DISPLAY=wayland-0
XAUTHORITY=/run/user/1000/.mutter-Xwaylandauth.GECQ42
XDG_ACTIVATION_TOKEN=gnome-shell/Gambas 3/3305-0-<hostname>_TIME95649
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 ]----