Throw an explicit error to make it clear we don't support the TRIGGER combination of SELECT and FOR EACH ROW

Apply #418: MySQL compatibility: support for ALTER TABLE tbl_name MODIFY [COLUMN] col_name column_definition, patch from Ville Koskela.

Expose limit/offset/distinct/having/group values as getter methods on Query for external TableEngine implementations

Patch from Andrew Gaul argaul@gmail.com
Fixes issue 401.

PostgreSQL compatibility: support for data types BIGSERIAL and SERIAL as an alias for AUTO_INCREMENT.

Spotted by rami.ojares@gmail.com

Fix for a bug where we would sometimes use the wrong unique constraint to validate foreign key constraints.

Added compatibility for "SET NAMES" query in MySQL compatibility mode.

Executing the statement CREATE INDEX IF ALREADY EXISTS if the index already exists no longer fails for a read only database.

Use HMAC for authenticating remote LOB id's, removing the need for maintaining a cache, and removing the limit on the number of LOBs per result set.

as per Thomas' suggestion, change syntax to use the more familiar comma-separated list without brackets