[syslog-ng] [Bug 23] MySQL default configuration causes error on 'pid' column

[bugzilla at bugzilla.balabit.com]

https://bugzilla.balabit.com/show_bug.cgi?id=23





--- Comment #7 from Mark LaCroix <mark at la-croix.net>  2008-09-26 15:35:11 ---
> in text-based fields the empty strings should be '' instead of NULL.

Well, yes and no.  Empty strings should be '', but MISSING strings should be NULL.  Ideally, missing anything should become a NULL value, at least for the
purposes of database insertion.  Unfortunately it's not that simple.

But it illustrates a core problem with the current DB interface.  Everything is being treated as a string in the INSERT statement and there is no way to
differentiate between an empty string value and a missing data value.

I have tested the patch and it didn't work.  A missing PID still produces an empty string in the INSERT statement.


-- 
Configure bugmail: https://bugzilla.balabit.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.