[mantisbt-dev] PostgreSQL and ADODB Fixes

[Victor B. <vb...@gm...>]

Hi Paul and all,

1. ADODB Fixes

I've created a page that lists all the fixes with applied to ADODB and
track whether such fixes were reported to ADODB team or not.  Also
once applied we want to track the ADODB version that has the fix.

http://www.mantisbt.org/wiki/doku.php/mantisbt:adodb_fixes

Paul, I'll send you an email with John Lim's email address to report
this new issue to him.  Last time we checked, they were not using a
bug tracker.

2. PostgreSQL Fixes

Recently you have been working on fix Mantis code so that we have
portable queries that work with all DBMSes we support.  I think we
should add a page under the Wiki Developer's Corner that captures
these gotchas.  For example,

1. UPDATE w/ LIMIT 1,
2. BOOL vs TINYINT / INT
3. I've seen some adding of quotation marks in schema.

etc.  For each one, we should specify the DBMS that is broken and
reference any relevant documentation.

This will allow us to easily educate the team (the current as well as
whoever joins in the future) on such issues and avoid them in the
future.

Regards,
Victor.