>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