[Gambas-user] [Gambas Bug Tracker] Bug #1088: sqllite result Overflow

[bugtracker at ...3416...]

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

hakan UNVER reported a new bug.

Summary
-------

sqllite result Overflow

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


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

This code line :
   usorgu = "SELECT * FROM hs_call WHERE CALL_STATUS = '2' OR CALL_STATUS = '3' OR CALL_STATUS = '9' AND ROOM = '" & room & "' AND CALL_TYPE = 'C' OR CALL_TYPE = 'Z'  OR CALL_TYPE = 'R' AND CALL_CODE = '" & code & "'"
          Debug usorgu
          rs_update = CFnc.MyConn.Exec(usorgu)
catch
debug Error.text

I get This Error

Debug Log :
FrmMain.update_record.590: SELECT * FROM hs_call WHERE CALL_STATUS = '2' OR CALL_STATUS = '3' OR CALL_STATUS = '9' AND ROOM = '1383' AND CALL_TYPE = 'C' OR CALL_TYPE = 'Z'  OR CALL_TYPE = 'R' AND CALL_CODE = '0'
FrmMain.update_record.634: Overflow

if I use short Query string is Ok no problem..


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

[System]
Gambas=3.9.2
OperatingSystem=Linux
Kernel=4.4.0-62-generic
Architecture=x86_64
Distribution=Linux Mint 18.1 Serena
Desktop=CINNAMON
Theme=Gtk
Language=en_US.UTF-8
Memory=5764M

[Libraries]
Cairo=libcairo.so.2.11502.0
Curl=libcurl.so.4.4.0
DBus=libdbus-1.so.3.14.6
GStreamer=libgstreamer-0.10.so.0.30.0
GStreamer=libgstreamer-1.0.so.0.802.0
GTK+2=libgtk-x11-2.0.so.0.2400.30
GTK+3=libgtk-3.so.0.1800.9
OpenGL=libGL.so.1.2.0
Poppler=libpoppler.so.58.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.5.1
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
CINNAMON_VERSION=3.2.6
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-Izsym8Vgti,guid=c7fd160b6ebc9bfcf41af72958afd379
DEFAULTS_PATH=/usr/share/gconf/cinnamon.default.path
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.qt4
GDMSESSION=cinnamon
GDM_XSERVER_LOCATION=local
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=2009
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=1
HOME=<home>
LANG=en_US.UTF-8
LC_ADDRESS=tr_TR.UTF-8
LC_IDENTIFICATION=tr_TR.UTF-8
LC_MEASUREMENT=tr_TR.UTF-8
LC_MONETARY=tr_TR.UTF-8
LC_NAME=tr_TR.UTF-8
LC_NUMERIC=tr_TR.UTF-8
LC_PAPER=tr_TR.UTF-8
LC_TELEPHONE=tr_TR.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=en_US.UTF-8
MDM_XSERVER_LOCATION=local
PATH=<home>/bin:<home>/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_QPA_PLATFORMTHEME=qgnomeplatform
QT_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1532,unix/<hostname>:/tmp/.ICE-unix/1532
SHELL=/bin/bash
SSH_AGENT_PID=1601
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=8
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
XDG_CURRENT_DESKTOP=X-Cinnamon
XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:/usr/local/share/:/usr/share/:/usr/share/mdm/
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SESSION_COOKIE=5ab3c275b7304ed3b8aeef9ffcc37eb4-1487917944.855606-545540223
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=8