QOT

Due to my mistake in domain configuration ritmark.com is currently inaccessible by it’s domain name. My apologies. This will be fixed ASAP.

It has been quite some time since the last 0.0.3 release, and now QOT 0.0.4 is finally available.

Here’s the ChangeLog of the new release:

- added ORDER BY analysis for index generation
- added an ORDER BY-specific rewrite (const-field removal)
- added ORDER BY-specific static checks (unoptimizable ORDER BY cases)
- added table and field alias support
- improved error reporting
- fixed: bug 0000002: Segfault if query-file doesn’t start with create database and use commands general
- fixed: bug 0000003: Segfault for queries that use table alias
- fixed: bug 0000005: Various segfaults
- fixed: bug 0000006: crash with bigint, datetime, enum field types
- minor output formatting improvements
- improved covering indexes gneeration algorithm

The new version is avaialble for download.

In this release:

- added: windows port
- added: multitable select star warning
- added: multicolumn IN clause warning
- added: numeration for output messages

- fixed: bug 0000001: Compilation fails
(a compilation problem on 3.x g++ compilers)

My article in the latest issue of the MySQL Magazine explains the features of the new QOT version 0.0.2, and shows how the tool can be used during the physical schema design stage.

The new version is avaialble for download.

Featues:
- added error reporting for unresolved identifiers to –info option
- added a new –static-checks option which should perform what is usually called static code checking, i.e. find constructs that are formally valid but has proven to be dangerous. Here you can find the full list of QOT static checks.
- added a new –rewrite option. Here you can find the full list of available QOT rewrites.

QOT version 0.0.1 is available for download here. Also a Quick Start Guide is available.