From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | Wes Williams <wes_williams(at)fcbonline(dot)net>, "'Jan'" <janoleolsen(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL vs mySQL, any performance difference for |
Date: | 2005-10-25 19:48:40 |
Message-ID: | 20051025194840.GA76010@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Oct 25, 2005 at 02:24:11PM -0500, Scott Marlowe wrote:
> Cool. Does it still error out after issueing:
>
> set sql_mode='MYSQL323';
>
> ???
>
> Just wondering if bounds checking is still optional but is now op-out
> instead of opt-in, or if it's something that you can no longer turn off.
Actually it still appears to be opt-in in stock builds. I have a
5.0.15 server built from source and sql_mode is empty by default,
so I still get the bogus behavior.
mysql> select version();
+------------+
| version() |
+------------+
| 5.0.15-log |
+------------+
1 row in set (0.00 sec)
mysql> select @@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+
1 row in set (0.00 sec)
mysql> create table test (i1 int);
Query OK, 0 rows affected (0.92 sec)
mysql> insert into test values (123913284723498723423);
Query OK, 1 row affected, 2 warnings (0.00 sec)
mysql> select * from test;
+------------+
| i1 |
+------------+
| 2147483647 |
+------------+
1 row in set (0.00 sec)
mysql> set sql_mode='MYSQL323';
Query OK, 0 rows affected (0.01 sec)
mysql> insert into test values (123913284723498723423);
Query OK, 1 row affected, 2 warnings (0.00 sec)
mysql> select * from test;
+------------+
| i1 |
+------------+
| 2147483647 |
| 2147483647 |
+------------+
2 rows in set (0.01 sec)
mysql> set sql_mode='STRICT_ALL_TABLES';
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values (123913284723498723423);
ERROR 1264 (22003): Out of range value adjusted for column 'i1' at row 1
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Wiersig | 2005-10-25 20:15:22 | Re: Installation Problem |
Previous Message | Magnus Hagander | 2005-10-25 19:37:34 | Re: alt+F not working after calling pg_dump |