Extensions JSqlParser 0.9.4
- improved interval expression syntax
- support of hex values (0xabc54, x'abc567') added
- support of (e.g. @@spid) system parameters
- support of signed parameters added
SELECT * FROM mytable WHERE -? < 4
- support for SELECT SKIP FIRST ...
- Completely rewritten S_IDENTIFIER rule to accept hopefully all possible UTF-8 letters without
specifying some additional rules. - allow Server within multipart names to act as database link
- revived Apache Software License, Version 2.0
- support for row constructors in conditions
SELECT * FROM t1 WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2 WHERE id = 10)
- some refactorings for TablesNamesFinder to improve usability
- established JJTree nodes for columns and tables (look at SelectASTTest) for first usages
- support for MySQL GROUP_CONCAT
GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')