Re: TRIGGER truncates data.....

[Sheeri Kritzer]

But I explicitly cast it as a char in the last part....why doesn't that work? Does it go to the table, see what the types should be, and THEN the trigger runs? There's no reason for @bar to be truncated in the example below.....is there?

from my post...
--------------------------------------------
I even tried this:

delimiter //
DROP TRIGGER insertIP //
CREATE TRIGGER insertIP BEFORE INSERT ON IPHistoryNum FOR EACH ROW
BEGIN set @bar=CAST(NEW.ip AS char); SET NEW.ip = INET_ATON(NEW.ip); SET @foo=NEW.ip; END;//
delimiter ;

mysql> insert into IPHistoryNum (ip) VALUES ('192.168.2.50') ;
Query OK, 1 row affected, 1 warnings (0.00 sec)

Warning (Code 1265): Data truncated for column 'ip' at row 1
mysql> select @bar,@foo;
+------+------+
| @bar | @foo |
+------+------+
| 255 | 255 |
+------+------+
1 row in set (0.00 sec)

mysql> select ip from IPHistoryNum;
+------------+
| ip |
+------------+
| 192 |
| 255 |
+------------+