[ postfixadmin-Bugs-1699218 ] not MySQL strict compliant

[SourceForge.net <no...@so...>]

Bugs item #1699218, was opened at 2007-04-12 15:24
Message generated for change (Comment added) made by christian_boltz
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1699218&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
>Group: SVN (please specify revision!)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: not MySQL strict compliant

Initial Comment:
Trying to run the database script on a database with strict mode is an exercise in futility. Why dates are stored as 0000-00-00 instead of being proper nulls?

----------------------------------------------------------------------

>Comment By: Christian Boltz (christian_boltz)
Date: 2007-10-09 21:18

Message:
Logged In: YES 
user_id=593261
Originator: NO

Gingerdog, you can real all the details on
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

The reporter unfortunately didn't mention where he found problems.
According to grep, I think the problem is located in DATABASE_MYSQL.TXT
which has several datetime fields with default '0000-00-00'.

(Database design (especially encoding) and upgrading has to be discussed
anyway. I'll start a thread on the -devel mailinglist.)

----------------------------------------------------------------------

Comment By: GingerDog (gingerdog)
Date: 2007-10-09 19:03

Message:
Logged In: YES 
user_id=1761957
Originator: NO

Hmm... I had no idea MySQL had a 'strict' mode.

Anyone know how to do this?

Would making it compliant with 'strict' mode affect PostgreSQL
compatibility?

(I suspect not, but it's something to be careful about)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=1699218&group_id=191583