>Description:
MySQL 4.1.1-alpha (binary package from www.mysql.com)
does not accept negative number after DEFAULT.
>How-To-Repeat:
mysql> create table test (FileSize BIGINT NOT NULL DEFAULT -1);
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 '-1)' at line 1
>Fix:
This works:
create table test (FileSize BIGINT NOT NULL DEFAULT '-1');
Anyway, IMHO it should work without apostrophes too so I think it is a bug.
Mysql 3.23.55 worked well.
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization:
>MySQL support: none
>Synopsis: DEFAULT does not accept negative number
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.1-alpha-standard (Official MySQL-standard binary)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.55, for suse-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.1-alpha-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 9 min 10 sec
Threads: 2 Questions: 45 Slow queries: 0 Opens: 32 Flush tables: 1 Open tables:
10 Queries per second avg: 0.082
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
i586-suse-linux-gnu
System: Linux orion 2.4.20 #1 Tue Jan 6 17:28:30 CET 2004 i586 unknown unknown
GNU/Linux
Architecture: i586
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/i486-suse-linux/3.3/specs
Configured with: ../configure --enable-threads=posix --prefix=/usr
--with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man
--libdir=/usr/lib --enable-languages=c,c++,f77,objc,java,ada --disable-checking
--enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib
--with-system-zlib --enable-shared --enable-__cxa_atexit i486-suse-linux
Thread model: posix
gcc version 3.3 20030226 (prerelease) (SuSE Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2
-mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 1491599 Mar 14 2003 /lib/libc.so.6
-rw-r--r-- 1 root root 43012516 Mar 14 2003 /usr/lib/libc.a
-rw-r--r-- 1 root root 204 Mar 14 2003 /usr/lib/libc.so
lrwxrwxrwx 1 root root 19 Jun 17 2003 /usr/lib/libc-client.so ->
libc-client.so.2002
-rwxr-xr-x 1 root root 764016 Apr 11 2003 /usr/lib/libc-client.so.2002
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static'
'--with-mysqld-ldflags=-all-static' '--with-readline' '--with-embedded-server'
'--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro
-felide-constructors' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
