>Description:
We have just upgraded from 3.22.26a to 3.23.33. One table has a column
name "FullText". However, any SQL statements (either using PHP or the command
line interface) that directly reference the column will cause an SQL error,
like:
---------------------------------------------------------------------------
Couldn't execute query: [UPDATE Resources SET
Title = 'Cambridge Scientific Abstracts',
Url = 'http://www.csa.com/htbin/dbrng.cgi?username=usf&access=usf6&cat=default',
Vendor='62',Issn='',FullText='Some FullText',TOC='N',Coverage='',
Access='Proxy', Notes = ' ', DB = 'Y', EJ = '', RT = '', IR = '', NW = '',
EB = '', IM = '', DateAdded = '2000-10-30', Continues = 'Continues',
ContinuedBy = '' WHERE (Id = '18765')]
You have an error in your SQL syntax near 'FullText='Some FullText',TOC='N',
Coverage='',Access='Proxy',Notes = ' ', DB = '' at line 1
---------------------------------------------------------------------------
(Original SQL query line was all one line, originating from a PHP page; it has
been edited only for readability.)
>How-To-Repeat:
I have not tested creating a table with such a column name. However,
with an existing table, the line above, as well as an attempt to do a:
SELECT FullText from Resources where Id='18765';
also bugs out. A similar "SELECT * from" worked fine.
>Fix:
Beyond renaming the column, no idea as of yet.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
Eric A. Stewart - Network Administrator - [EMAIL PROTECTED]
University of South Florida, Tampa Campus Library - Systems
Work: http://www.lib.usf.edu/ | MS/MIS | ICQ#
Play: http://cerebus.lib.usf.edu/ | Graduate Student | 31285736
SSI MD#100762
>
>MySQL support: none
>Synopsis: Some keywords appear no longer valid in SQL queries
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Source distribution)
>Environment:
System: SunOS charlotte 5.8 Generic sun4u sparc SUNW,Ultra-250
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake
/usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1731920 Jan 5 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 10 2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1113260 Jan 5 2000 /lib/libc.so.1
-rw-r--r-- 1 root bin 1731920 Jan 5 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jul 10 2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1113260 Jan 5 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql-3.23.33-sun-solaris2.8-sparc
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
