All releases of xplain2sql
Release Notes: Important performance improvements with extends and bugfixes.
Release Notes: Much better code generation for the count, min, max, and total functions using left outer joins instead of sub-selects. A new extension to mimic SQL's insert into ... select. Extended attributes can now be updated for most dialects. A variety of bugfixes. Now includes an Ubuntu 8.0.4 package.
Release Notes: Assert support was added. If-then-else is supported in init [default] statements for dialects that support triggers.
Release Notes: More faithful support for init [default] expressions. PostgreSQL output when using values in a stored procedure has been fixed. MySQL 5 support has been added. Support for SQLite 3 has been added. Any and nil support are now correctly implemented for InterBase 6. Functions like min and max now work as expected on InterBase 6.
Release Notes: MySQL 5 and SQLite support was added. Complete support was added for init and init default for most dialects. InterBase 6 improvements were done.
Release Notes: Column number is now reported for warnings. Values can now be updated (previously, this worked only for certain dialects). Support has been added for the * and ? operators. If these two characters appear in a literal string, the comparison is done with like. Bugfixes for output for InterBase, PostgreSQL, Microsoft SQL and Oracle.
Release Notes: This version added support for the four conversion functions integer (), real (), string (), and datef(). An extend now always creates a unique index on the primary key column of the extended table. The PostgreSQL 7.3 output was changed so that procedures that return result sets now work very well through an ODBC interface.
Release Notes: This version features better code generation for existing targets, much improved PostgreSQL output, support for Oracle, and generates an XML description of the generated SQL code.
Release Notes: The join builder was rewritten, and should no longer use double joins or wrong joins. It also contains "init" support for PostgreSQL and bugfixes for InterBase. Issues were fixed where a specialized self reference was converted to a 'not null' column, which should have been a 'null' column, and the output of "get some", which was wrong in certain cases.
Release Notes: This release constists mainly of bugfixes in the SQL code, and enhancements to support more Xplain features, such as having an 'its' list in a count function or per clause.
