>Description:
It is impossible to create column having ENUM("") type. Not sure if
it is a bug as it doesn't make too much sense but at least error
message is very wrong.
>How-To-Repeat:
mysql> create temporary table test ( test enum ("") );
ERROR 1074: Too big column length for column 'test' (max = 255).
Use BLOB instead
>Fix:
N/A
>Submitter-Id: <submitter ID>
>Originator: Ilya Martynov
>Organization:
Ilya Martynov (http://martynov.org/)
>
>MySQL support: none
>Synopsis: Cannot create column having ENUM("") type
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.51, for pc-linux-gnu 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 3.23.51-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 13 min 55 sec
Threads: 2 Questions: 250 Slow queries: 0 Opens: 85 Flush tables: 1 Open tables:
6 Queries per second avg: 0.299
>Environment:
System: Linux abra.ru 2.4.16 #1 ðÎÄ äÅË 10 20:32:46 MSK 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011006 (Debian prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 ñÎ× 15 2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1171196 äÅË 3 2001 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 2669312 äÅË 3 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 äÅË 3 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin
--datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql
--includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man
--enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb
--enable-static --enable-shared --enable-local-infile --with-raid
--enable-thread-safe-client --without-readline
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql
--without-bench --without-docs --with-client-ldflags=-lstdc++ --with-extra-charsets=all
---------------------------------------------------------------------
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
