[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