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)
