>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

Reply via email to