[EMAIL PROTECTED] writes:
> >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
>
>From our fine manual:
`SET('value1','value2',...)'
A set. A string object that can have zero or more values, each of
which must be chosen from the list of values `'value1'',
`'value2'', `...' A `SET' can have a maximum of 64 members. *Note
SET::.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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