8000 Commits · omghax/sql · GitHub

More Web Proxy on the site http://driver.im/

Commits

Commits on Jul 23, 2008

Moved SQL::VERSION into its own file, so that the Rakefile won't have to load the entire SQL library just to get the version string.
Dray Lacy
committed

Commits on Jul 21, 2008

Added support for approximate float values (1E+5, -2.5E+30, etc.)
Dray Lacy
committed
Added CURRENT_USER.
Dray Lacy
committed

Commits on Jul 19, 2008

Added support for using ORDER BY with an unsigned integer constant. Not sure exactly why you'd want to do this, but it's in the SQL-92 spec, so in it goes :-\
Dray Lacy
committed
Added ASC / DESC to ORDER BY (defaults to ASC).
Dray Lacy
committed
Added ORDER BY.
Dray Lacy
committed
Added support for using subqueries in a WHERE clause.
Dray Lacy
committed
Added implied AS clauses ('SELECT * FROM users u' instead of 'SELECT * FROM users AS u').
Dray Lacy
committed
Added quoting around all generated column and table names.
Dray Lacy
committed
Added better support for string quoting. It's still not all the way there yet, but it's better than it was.
Dray Lacy
committed

Commits on Jul 18, 2008

Added support for IN predicates to have subqueries.
Dray Lacy
committed
Fixed NOT EXISTS so that it doesn't negate the entire subquery.
Dray Lacy
committed
Added EXISTS / NOT EXISTS.
Dray Lacy
committed
Made the lexer case-insensitive.
Dray Lacy
committed
DRYed up the statement tests a bit by extracting node creation into helper methods.
Dray Lacy
committed
Added USING clause for joins.
Dray Lacy
committed
DRYed up Column and Table nodes by making them extend from an Identifier node.
Dray Lacy
committed
Renamed the As node's :name attribute to :column, since it's now a Column object instead of just a string.
Dray Lacy
committed
Changed QualifiedColumn's initializer to accept a Table node and a Column node.
Dray Lacy
committed
Changed QualifiedColumn to take a Table node in its initializer rather than just a string.
Dray Lacy
committed

Commits on Jul 17, 2008

Added quoted identifiers.
Dray Lacy
committed
Added FULL OUTER JOIN.
Dray Lacy
committed
Added FULL JOIN.
Dray Lacy
committed
Added RIGHT OUTER JOIN.
Dray Lacy
committed
Added RIGHT JOIN.
Dray Lacy
committed
Added LEFT OUTER JOIN.
Dray Lacy
committed
Added LEFT JOIN.
Dray Lacy
committed
Added INNER JOIN.
Dray Lacy
committed
Cleaned up the table reference grammar in the racc file. Removed the table_reference_list node I had added which differed from the SQL-92 grammar spec.
Dray Lacy
committed
Added explicit CROSS JOIN expression.
Dray Lacy
committed
Changed FROM t1, t2 syntax to output a CrossJoin node.
Dray Lacy
committed
Added table reference lists (ex. 'FROM users, posts, comments').
Dray Lacy
committed
Cleaned up the array-like nodes in the racc file. They now use Array() rather than [].
Dray Lacy
committed
Added HAVING clauses.
Dray Lacy
committed
Added GROUP BY clauses.
Dray Lacy
committed

0