Release Notes: This release fixes "cast(x as integer)", which previously produced an error.
Release Notes: This release fixes "union all" (e.g., "select t1.a from T1 union all select t2.b from T2 union all ..") and fixes functions without parameters and parens, (e.g., "Select .. where t1.x=sysdate").
Release Notes: A bug where UNION SELECT was case sensitive was fixed.
Release Notes: Union at top level was fixed. A column without alias and IN subselect was fixed; for example, "SELECT * FROM A WHERE x IN (SELECT y FROM B )".
Release Notes: There is a patch fixing UNIONs not included in subselects. For example: "SELECT a from A union select b from B". Download the ZIP file, and replace revj.py.
Release Notes: Support for UNION was added. An exception during processing of "select o.x from out o where o.y in ( select * from t1 at1 )" was fixed.
Release Notes: Anonymous subselects were fixed. For example, "select * from (select A.id from A)". Long IN clauses are truncated. For example, "table.field in (1,2,3,4...999)".
Release Notes: This release fixes the missing edge for nested IN (subselect..). For example: select * from (select A.id from A where A.id IN (select B.id from B where v=5)) D1.
Release Notes: This release has an improved simplifier (e.g. not complaining about the column concat, which is a function). Improved subselects, e.g. "select * from (select * from ta A,tb B where A.x=B.y) D1, (select * from ta A,tb B where A.x=B.y) D2".
Release Notes: A fan trap warning was fixed in "SELECT id,sum(val1),sum(val2) from tab group by id". Constants are properly reduced in "select nvl(a111 + 2222, 3333, 4444) from table".