>Description:
Hi,
I noticed this when making a set called groups with 64 values from 1 to 64.
When inserting or updating the table with a numeric value ex 15 (should set
value 1-4),
select * from whatever doesn't show anything in that colum (not even NULL). If
using
1 to 63 it works.. 0 to 63 doesn't. 0 to 62 and Z doesn't.
I'm not on the list, so the bug might already be reported (didn't find it when
searching tho),
I'm not a guru, so I might have done something wrong (sorry;-), and please cc
replies to me ;-)
Thanks for a great product!
>How-To-Repeat:
create table settest (
id int,
s1 set('1','2','3','4'),
s2
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63'),
s3
set('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64'));
insert into settest values (1,15,15,15);
select * from settest;
>Fix:
Only use 63 fields ;-)
>Submitter-Id: <submitter ID>
>Originator: Magnus Espeland
>Organization:
>MySQL support: none
>Synopsis: Bug in the SET type with 64 entries
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.37 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, 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.37
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 hours 40 min 50 sec
Threads: 2 Questions: 158 Slow queries: 0 Opens: 38 Flush tables: 1 Open tables:
19 Queries per second avg: 0.003
>Environment:
System: Linux kelso 2.2.16-3 #1 Mon Jun 19 18:49:25 EDT 2000 i586 unknown
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/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'
CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Dec 9 08:09 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101836 Sep 6 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20273284 Sep 6 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 6 2000 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --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/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
