>Description:
The name dec does not work as an unqualified name
when creating tables on inside queries. A syntax error is given. If
escaped as `dec`, no error is given. dec is not on
the list of reserved words. Thus this could be
either a documentation or software bug.
>How-To-Repeat:
create table xx (dec int);
>Fix:
create table xx(`dec` int);
However this is extremely inconvenient in our databases
since we use the field dec (for declination) in all tables
and it frequently shows up in the middle of complex
where clauses (e.g., where sin(dec*...) < cos(dec...)
so that it is non-trivial for us to get around this.
>Submitter-Id: Thomas McGlynn
>Originator: Same
>Organization:
HEASARC NASA/GSFC
>MySQL support: none
>Synopsis: 'dec' treated as reserved word.
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug or doc-bug
>Release: mysql-4.0.0-alpha (Official MySQL binary)
>Environment:
System: Linux skys4 2.4.7 #2 Mon Jul 23 16:45:50 EDT 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Nov 9 15:08 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1283580 Oct 3 14:10 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27314604 Oct 3 13:52 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 3 13:52 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --disable-shared
---------------------------------------------------------------------
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
