[TYPO3-core] RFC: Fix FE user login for DBAL
Dmitry Dulepov
typo3 at accio.lv
Wed Jun 28 10:45:16 CEST 2006
Hi!
Martin Kutschker wrote:
> But the real issue is that I cannot insert/update '' on a NOT NULL
> column in Oracle. *sigh* So NOT NULL and DEFAULT '' don't work together.
What I can say? Only the "F***king Oracle!" :(
But '' is very good default value. We cannot remove NOT NULL just
because Oracle treats empty string is null. If we do it, we will allow
NULL values in many columns and many queries will break. Result of
comparison is undefined if column has null as value. Thus = and <> will
be both true for this column. This is even worse!
I suppose DBAL could remove NOT NULL only for Oracle, not for other
(normal) databases.
Dmitry.
--
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)
More information about the TYPO3-team-core
mailing list