From: <sinisa
Date: July 12 1999 3:39pm
Subject: strange behavior...
List-Archive: http://lists.mysql.com/mysql/7079
Message-Id: <14218.3098.284189.209713@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

elble@stripped writes:
 > behavior in my "old" version:
 > Ver 9.27 Distrib 3.22.14b-gamma, for sun-solaris2.5.1 (sparc)
 > 
 > mysql> create table foobar (
 >     -> this int unsigned 
 >     -> );
 > Query OK, 0 rows affected (0.19 sec)
 > 
 > mysql> insert into foobar values (1);
 > Query OK, 1 row affected (0.00 sec)
 > 
 > mysql> select * from foobar;
 > +------+
 > | this |
 > +------+
 > |    1 |
 > +------+
 > 1 row in set (0.04 sec)
 > 
 > built both 3.22.23b and 3.23.1-alpha with egcs 1.1.2 on Solaris 2.6, and
 > noticed this behavior:
 > Ver 9.33 Distrib 3.23.1-alpha, for sun-solaris2.6 (sparc)
 > 
 > mysql> create table foobar (
 >     -> this int unsigned
 >     -> );
 > Query OK, 0 rows affected (0.02 sec)
 > 
 > mysql> insert into foobar values (1);
 > Query OK, 1 row affected (0.00 sec)
 > 
 > mysql> select * from foobar;
 > +------------+
 > | this       |
 > +------------+
 > | 4294967295 |
 > +------------+
 > 1 row in set (0.01 sec)
 > 
 > errrrr....?
 > 
 > but, if one does this:
 > 
 > mysql> insert into foobar values ('1');
 > Query OK, 1 row affected (0.00 sec)
 > 
 > mysql> select * from foobar;
 > +------------+
 > | this       |
 > +------------+
 > | 4294967295 |
 > |          1 |
 > +------------+
 > 2 rows in set (0.00 sec)
 > 


Hi!

It seems definitely that it is a bug, which should be looked into.


Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+