From: Baron Schwartz (baronpercona.com)
Date: Sun Apr 06 2008 - 20:28:59 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Ed,

On Thu, Apr 3, 2008 at 3:32 PM, Ed W <listswildgooses.com> wrote:
> Hi
>
> Up until version 5.0.44 (on linux) it appeared that you could do stuff like
> deliberately insert a NULL into a NOT NULL varchar field and it would be
> silently converted to an empty string. Similarly if you didn't specify a
> value it appeared to use what is describe in the docs as the "DEFAULT()"
> function to enter an empty string in the column
>
> However, I just upgraded from 5.0.44 to 5.0.54 and now the behaviour has
> changed so that this errors noisily.
> The docs on SQL Modes
> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html - suggests that
> this behaviour can be controlled, but as far as I can see I don't have the
> |STRICT_ALL_TABLES or ||STRICT_TRANS_TABLES options enabled anyway..?

Check the changelogs in the manual, but I don't think this behavior
has changed. That would break backwards compatibility in a way I
don't think has happened.

You should check by examining your SQL mode on the running server:

SELECT SQL_MODE;

This is more reliable than looking at the configuration file, because
you might be looking at the wrong file, or the wrong section, or
someone might have updated the SQL mode by using SET GLOBAL SQL_MODE
-- who knows.

Regards
Baron

--

Baron Schwartz, Senior Consultant, Percona Inc.
Tel: +1 888 401 3401 ext 507
24/7 Emergency Line +1 888 401 3401 ext 911
Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]