[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

Reply via email to