Re: PostgreSQL vs mySQL, any performance difference for

For what it may be worth, executing the same commands into MySQL
5.0.15-nt-max (Win XP Pro) the following it received:

mysql> create table test (i1 int);
Query OK, 0 rows affected (0.41 sec)

mysql> insert into test values (123913284723498723423);
ERROR 1264 (22003): Out of range value adjusted for column (i1) at row 1

mysql> select * from test;
Empty set (0.03 sec)


Finally an improvement!

============================================================
-----Original Message-----
mysql> create table test (i1 int);
Query OK, 0 rows affected (0.07 sec)

mysql> insert into test values (123913284723498723423);
Query OK, 1 row affected, 2 warnings (0.07 sec)

mysql> select * from test;
+------------+
| i1         |
+------------+
| 2147483647 |
+------------+
1 row in set (0.00 sec)

And other fun things.