Description:
When creating a table with a column named force an error is shown and the
table is not created.
How-To-Repeat:
When trying to do this :
CREATE TABLE testcase (
force int default NULL
) TYPE=MyISAM;
I get this :
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'force int default NULL,
) TYPE=MyISAM' at line 2
Is this related to the FORCE INDEX feature ?
Fix:
Change columnname to something different, but this often requires changes
to software which is not always possible.
Submitter-Id:
Originator: Peter O
Organization:
MySQL support: none
Synopsis: column named force not allowed
Severity: non-critical
Priority: medium
Category: mysql
Class: sw-bug
Release:mysql-4.0.9-gamma (Official MySQL RPM)
C compiler:2.95.3
C++ compiler: 2.95.3
Environment:
System: Linux 2.4.18-14bigmem #1 SMP Wed Sep 4 11:58:10 EDT 2002 i686 i686
i386 GNU/Linux
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/3.2/specs
Configured with:
../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info
--enable-shared --enable-threads=posix --disable-checking --host=i386-redha
t-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='gcc'
-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions
-fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root 14 Jan 17 17:35 /lib/libc.so.6 -
libc-2.2.93.so
-rwxr-xr-x1 root root 1235468 Sep 6 2002 /lib/libc-2.2.93.so
-rw-r--r--1 root root 2233342 Sep 6 2002 /usr/lib/libc.a
-rw-r--r--1 root root 178 Sep 6 2002 /usr/lib/libc.so
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl'
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--with-embedded-server' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CC=gcc'
'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium'
'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-e
xceptions -fno-rtti -mpentium' 'CXX=gcc'
Kind regards,
Peter O
***
Peter O, Software Developer
MrBookmaker NV, Bijenstraat 11, B-9051 Sint-Denijs-Westrem, Belgium
Tel:+32-(0)9-245.44.44, fax:+32-(0)9-245.44.45
mailto:[EMAIL PROTECTED]
***
-
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