b***@gambaswiki.org
2017-06-18 09:32:26 UTC
http://gambaswiki.org/bugtracker/edit?object=BUG.1122&from=L21haW4-
Bruce BRUEN reported a new bug.
Summary
-------
SQL syntax highlighter does not respect continued (multiline) strings
Type : Bug
Priority : Low
Gambas version : 3.9.90 (TRUNK)
Product : GUI components
Description
-----------
SQL string literals can continue over multiple lines without any special treatment as the string is terminated by the first occurrence of the string delimiter used. For example, the SQL source file may contain:
COMMENT ON TABLE jockey_stats IS 'At the moment this table contains the crosstabulated monthly figures for the jockey over the last 12 months. It is created by an involved query that is run daily.
The column names need changing (desperatley)';
The string is totally delimited by the ' character pair and any CR/LF are ignored.
The SQL syntax highlighter does not respect that convention and treats everything after the "... run daily." as more of the same string.
System information
------------------
[System]
Gambas=3.9.90 r8135
OperatingSystem=Linux
Kernel=4.1.15-pclos1
Architecture=x86
Distribution=PCLinuxOS
Desktop=LXDE
Theme=Gtk
Language=en_AU.UTF-8
Memory=1005M
[Libraries]
Cairo=libcairo.so.2.11400.6
Curl=libcurl.so.3.0.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.603.0
GTK+2=libgtk-x11-2.0.so.0.2400.26
GTK+3=libgtk-3.so.0.1400.14
OpenGL=libGL.so.1.2.0
OpenGL=libGL.so.173.14.39
OpenGL=libGL.so.96.43.23
Poppler=libpoppler.so.13.0.0
Poppler=libpoppler.so.19.0.0
Poppler=libpoppler.so.46.0.0
Poppler=libpoppler.so.54.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.4.2
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6
[Environment]
BROWSER=/usr/bin/www-browser
CANBERRA_DRIVER=pulse
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-6AOFReU3eQ,guid=967e3250abf3a8a11787da3259458417
DESKTOP_SESSION=LXDE
DISPLAY=:0
GB_GUI=gb.qt4
GCONF_TMPDIR=/tmp
GDMSESSION=04LXDE
GDM_XSERVER_LOCATION=local
GIT_PAGER=less -FRS
GPG_AGENT_INFO=/tmp/gpg-5uywEs/S.gpg-agent:3147:1
GTK_MODULES=canberra-gtk-module
GUILE_LOAD_PATH=/usr/share
G_FILENAME_ENCODING=@locale
HISTCONTROL=ignoredups
HISTSIZE=1000
HOME=<home>
HOSTNAME=<hostname>
INPUTRC=/etc/inputrc
LANG=en_AU.UTF-8
LANGUAGE=en_AU:en_GB:en
LC_ADDRESS=en_AU.UTF-8
LC_COLLATE=en_AU.UTF-8
LC_CTYPE=en_AU.UTF-8
LC_IDENTIFICATION=en_AU.UTF-8
LC_MEASUREMENT=en_AU.UTF-8
LC_MESSAGES=en_AU.UTF-8
LC_MONETARY=en_AU.UTF-8
LC_NAME=en_AU.UTF-8
LC_NUMERIC=en_AU.UTF-8
LC_PAPER=en_AU.UTF-8
LC_SOURCED=1
LC_TELEPHONE=en_AU.UTF-8
LC_TIME=en_AU.UTF-8
LESS=-MM
LESSCHARSET=utf-8
LESSKEY=/etc/.less
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=<user>
LS_COLORS=
MAIL=/var/spool/mail/<user>
MDV_MENU_STYLE=discovery
META_CLASS=desktop
NLSPATH=/usr/share/locale/%l/%N
PATH=/bin:/usr/bin:/usr/local/bin:/usr/games:/usr/lib/qt4/bin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:<home>/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/sbin:/usr/lib/kde4/libexec
PKG_CONFIG_PATH=/usr/lib/pkgconfig
PWD=<home>
PYTHONDONTWRITEBYTECODE=1
PYTHONSTARTUP=/etc/pythonrc.py
QT4DOCDIR=/usr/share/doc/qt4
QT5DOCDIR=/usr/share/doc/qt5
QTDIR=/usr/lib/qt4
QTDIR5=/usr/lib/qt5
QTINC=/usr/lib/qt3/include
QTLIB=/usr/lib
QT_PLUGIN_PATH=/usr/lib/qt4/plugins/:/usr/lib/kde4/plugins/:/usr/lib64/kde4/plugins:/usr/lib/kde4/plugins
QT_XFT=0
SAL_USE_VCLPLUGIN=gtk
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=3091
SSH_ASKPASS=/usr/lib/ssh/ssh-askpass
SSH_AUTH_SOCK=<home>/tmp/ssh-ARhV7y8AZBzn/agent.3083
TMP=<home>/tmp
TMPDIR=<home>/tmp
TZ=:/etc/localtime
USER=<user>
WINDOWPATH=8
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/discovery:/etc/xdg
XDG_CONFIG_HOME=<home>/.config
XDG_CURRENT_DESKTOP=LXDE
XDG_DATA_DIRS=/usr/local/share:/usr/share/gdm:/var/lib/menu-xdg:/usr/share:/usr/share/gdm/
XDG_MENU_PREFIX=lxde-
XDG_SESSION_COOKIE=82ab6c261883e9ffe2a80b674b7b435e-1497728016.181950-1353101201
XMODIFIERS=@im=none
_=/usr/bin/gambas3
_LXSESSION_PID=2617
Bruce BRUEN reported a new bug.
Summary
-------
SQL syntax highlighter does not respect continued (multiline) strings
Type : Bug
Priority : Low
Gambas version : 3.9.90 (TRUNK)
Product : GUI components
Description
-----------
SQL string literals can continue over multiple lines without any special treatment as the string is terminated by the first occurrence of the string delimiter used. For example, the SQL source file may contain:
COMMENT ON TABLE jockey_stats IS 'At the moment this table contains the crosstabulated monthly figures for the jockey over the last 12 months. It is created by an involved query that is run daily.
The column names need changing (desperatley)';
The string is totally delimited by the ' character pair and any CR/LF are ignored.
The SQL syntax highlighter does not respect that convention and treats everything after the "... run daily." as more of the same string.
System information
------------------
[System]
Gambas=3.9.90 r8135
OperatingSystem=Linux
Kernel=4.1.15-pclos1
Architecture=x86
Distribution=PCLinuxOS
Desktop=LXDE
Theme=Gtk
Language=en_AU.UTF-8
Memory=1005M
[Libraries]
Cairo=libcairo.so.2.11400.6
Curl=libcurl.so.3.0.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.603.0
GTK+2=libgtk-x11-2.0.so.0.2400.26
GTK+3=libgtk-3.so.0.1400.14
OpenGL=libGL.so.1.2.0
OpenGL=libGL.so.173.14.39
OpenGL=libGL.so.96.43.23
Poppler=libpoppler.so.13.0.0
Poppler=libpoppler.so.19.0.0
Poppler=libpoppler.so.46.0.0
Poppler=libpoppler.so.54.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.4.2
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6
[Environment]
BROWSER=/usr/bin/www-browser
CANBERRA_DRIVER=pulse
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-6AOFReU3eQ,guid=967e3250abf3a8a11787da3259458417
DESKTOP_SESSION=LXDE
DISPLAY=:0
GB_GUI=gb.qt4
GCONF_TMPDIR=/tmp
GDMSESSION=04LXDE
GDM_XSERVER_LOCATION=local
GIT_PAGER=less -FRS
GPG_AGENT_INFO=/tmp/gpg-5uywEs/S.gpg-agent:3147:1
GTK_MODULES=canberra-gtk-module
GUILE_LOAD_PATH=/usr/share
G_FILENAME_ENCODING=@locale
HISTCONTROL=ignoredups
HISTSIZE=1000
HOME=<home>
HOSTNAME=<hostname>
INPUTRC=/etc/inputrc
LANG=en_AU.UTF-8
LANGUAGE=en_AU:en_GB:en
LC_ADDRESS=en_AU.UTF-8
LC_COLLATE=en_AU.UTF-8
LC_CTYPE=en_AU.UTF-8
LC_IDENTIFICATION=en_AU.UTF-8
LC_MEASUREMENT=en_AU.UTF-8
LC_MESSAGES=en_AU.UTF-8
LC_MONETARY=en_AU.UTF-8
LC_NAME=en_AU.UTF-8
LC_NUMERIC=en_AU.UTF-8
LC_PAPER=en_AU.UTF-8
LC_SOURCED=1
LC_TELEPHONE=en_AU.UTF-8
LC_TIME=en_AU.UTF-8
LESS=-MM
LESSCHARSET=utf-8
LESSKEY=/etc/.less
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=<user>
LS_COLORS=
MAIL=/var/spool/mail/<user>
MDV_MENU_STYLE=discovery
META_CLASS=desktop
NLSPATH=/usr/share/locale/%l/%N
PATH=/bin:/usr/bin:/usr/local/bin:/usr/games:/usr/lib/qt4/bin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:/usr/lib/qt5/bin:/usr/bin:/usr/sbin:/usr/lib/kde4/libexec:/bin:/sbin:/usr/X11R6/bin:/usr/games:/usr/local/bin:/usr/local/sbin:<home>/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/sbin:/usr/lib/kde4/libexec
PKG_CONFIG_PATH=/usr/lib/pkgconfig
PWD=<home>
PYTHONDONTWRITEBYTECODE=1
PYTHONSTARTUP=/etc/pythonrc.py
QT4DOCDIR=/usr/share/doc/qt4
QT5DOCDIR=/usr/share/doc/qt5
QTDIR=/usr/lib/qt4
QTDIR5=/usr/lib/qt5
QTINC=/usr/lib/qt3/include
QTLIB=/usr/lib
QT_PLUGIN_PATH=/usr/lib/qt4/plugins/:/usr/lib/kde4/plugins/:/usr/lib64/kde4/plugins:/usr/lib/kde4/plugins
QT_XFT=0
SAL_USE_VCLPLUGIN=gtk
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=3091
SSH_ASKPASS=/usr/lib/ssh/ssh-askpass
SSH_AUTH_SOCK=<home>/tmp/ssh-ARhV7y8AZBzn/agent.3083
TMP=<home>/tmp
TMPDIR=<home>/tmp
TZ=:/etc/localtime
USER=<user>
WINDOWPATH=8
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/discovery:/etc/xdg
XDG_CONFIG_HOME=<home>/.config
XDG_CURRENT_DESKTOP=LXDE
XDG_DATA_DIRS=/usr/local/share:/usr/share/gdm:/var/lib/menu-xdg:/usr/share:/usr/share/gdm/
XDG_MENU_PREFIX=lxde-
XDG_SESSION_COOKIE=82ab6c261883e9ffe2a80b674b7b435e-1497728016.181950-1353101201
XMODIFIERS=@im=none
_=/usr/bin/gambas3
_LXSESSION_PID=2617