Hi Marc,

On Wed, 2007-04-11 at 15:32 +0200, Marc Herbert wrote:
> Just tried this:
> mysql> create table a (i int unsigned);  insert into a values ('-1'); select 
> * from a;

You will get a warning when inserting -1:

mysql> insert into a values (-1);
Query OK, 1 row affected, 1 warning (0.10 sec)

mysql> show warnings;
+---------+------+-----------------------------------------------------+
| Level   | Code | Message                                             |
+---------+------+-----------------------------------------------------+
| Warning | 1264 | Out of range value adjusted for column 'i' at row 1| 
+---------+------+-----------------------------------------------------+
1 row in set (0.00 sec)

Regards,
Csaba



_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob

Reply via email to