List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:July 12 1999 3:39pm
Subject:strange behavior...
View as plain text  
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       |
+----------------------------------------------------------------------+
Thread
strange behavior...elble12 Jul
  • strange behavior...sinisa12 Jul
    • Re: strange behavior...elble13 Jul
    • Re: strange behavior...elble14 Jul