[TYPO3-core] WARNING: please don't touch HEAD for an hour, I borked by an accidental committ I need to revert. Thanks!

[Martin Kutschker]

Karsten Dambekalns schrieb:
> 
> You can try with HEAD, but there are a few glitches and few "too experimental" 
> changes in there right now.

Currently broken for Oracle. The installer cannot create all necesary 
tables. It's not your fault but it really sucks that the thing does NOT 
report any SQL errors * :-( I have no idea what went wrong. All of the 
missing tables contain BLOBs, none of the ones created have a BLOB.

BTW, I noticed that TEXT gets mapped to VARCHAR(4000). IMHO this is wrong 
as a Myssql TEXT coulmn may contain up to 65535 characters. So this must be 
a CLOB.

Sidenote: it's interesting that the installer reports NUMBER(20) as 
BIGINT(20) as Oracle knows only one integer/number type.

Does ADOdb support all those types?

tinyint => number(3,0) [1 byte]
smallint => number(5,0) [2 bytes]
int => number(11,0) [4 bytes]
bigint => number(20,0) [8 bytes]

AFAIK it doesn't matter as Oracle is able to hold any number in a NUMBER 
column.

As for NULL and DEFAULTs:

I found at least one column that has IS NULL but no DEFAULT: 
cache_md5params.params.

I don't know if you're trying to let the NOT NULL in if possible (my 
preference), but I think we agreed that all columns will get a TYPO3 
supplied DEFAULT if none defined by the developer.

I'll continue testing on Monday. If you want any tipps concerning Oracle XE 
ask in private mails.

Masi

* There is only one "ORA-00942: Tabelle oder View nicht vorhanden" at the 
top of the page after I do a COMPARE => Write to database.