[daisy] regarding the DB2 issues -- @Aaron

[Bruno Dumon]

On Mon, 2007-01-22 at 11:28 +0100, Aaron.Digulla at Globus.ch wrote:
> daisy-bounces at lists.cocoondev.org schrieb am 19.01.2007 11:27:36:
> 
> > Also, we are worried about on-going support and testing against 
> > "officially supported" databases.
> 
> Please have a look at the patches right now.
> 
> You'll see that only a part of them is DB2 specific (namely, the SQL 
> generation scripts).
> 
> I reported a few issues with the datamodel (using DATE instead of 
> DATETIME/TIMESTAMP for "last modification time") plus the broken usage of 
> NULL values in PreparedStatement.set*(). These issues only work with MySQL 
> because MySQL fixed a couple of bugs in the SQL and JDBC standard :-) You 
> cannot reply on this to work anywhere else.

The like-is-case-sensitive issue and the usage of some preserved names
(such as 'name') can be added to that list ;-)

>  You'll see these if you start 
> to base your test cases in Derby, for example.
> 
> The issue about the length of the table names is probably DB2 specific but 
> I hope that you can accept shorter names in your model :-)
> 
> When these are fixed, porting to new "big" DBs like Oracle and DB2 (were 
> JDBC support is nowhere as good as in MySQL :-( ) will be much more simple 
> (namely writing or copying the Torque scripts).
> 

Exactly. That's why I would very much welcome patches for *current
trunk* that fix *specific issues*, i.e. a separate patch for the quote
issue, a separate patch for the select null issue, etc. That way
harmless enhancements can be easily committed.

Some items I really need to verify myself, like the DATE vs DATETIME
thing (does that really give the exact same type in the mysql scripts as
before?), before committing them, and that takes time.

And once more, your patch has never been committable to trunk because
almost all SQL statements were touched as part of the introduction of
namespaces. Now, let's stop talking about this ;-)

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org