Extensions Version 0.9
- Included support for some keyword object names.
SELECT cast, do FROM tableName
- Included support for named primary keys in create table statements.
- Include adapter classes for visitor interfaces to simplify visitor usage.
- included a huge amount of oracle test sqls. There is much room for improvement supporting all oracle syntax specials.
- pivot support for subqueries implemented
SELECT * FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT')) ORDER BY times_purchased
- "!=" support corrected to not give "<>" while deparsing
- Improved COUNT(ALL expr) support
- lax test utils implemented
- toString() for window elements corrected
- Character Set support included.
CAST(col2 AS CHAR(255) CHARACTER SET utf8)