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 |
+----------------------------------------------------------------------+
