Extensions in version 0.9.5
- introduced first support for boolean valued column conditions
SELECT * FROM mytable WHERE mytable.boolValue;
- improved parenthesis parsing performance within expressions (#215)
- support for ALTER TABLE mytable ADD CONSTRAING name PRIMARY KEY (col)
- support for INSERT LOW_PRIORITY INTO
- support for ORDER BY and LIMIT in UPDATE and DELETE statements
UPDATE tablename SET ... ORDER BY col;
UPDATE tablename SET ... ORDER BY col LIMIT 10;
UPDATE table1 A SET ... LIMIT 10;
DELETE FROM tablename LIMIT 5;
DELETE FROM tablename ORDER BY col;
DELETE FROM tablename ORDER BY col LIMIT 10;
- support for INSERT ... ON DUPLICATE KEY UPDATE
- improved support for ALTER TABLE statements
- first Oracle hint support for SELECT statements
- first ALTER TABLE FOREIGN KEY support
- first MERGE support
- first version of escaped single quotes support
select '\''