collectiveidea/awesome_nested_set — pull request #108 by pikender (2011-12-14 05:08:32+00:00)
Title: Oracle Compatibility

1. SQL Used in FUNCTION - left_and_rights_valid? IN FILE - lib/awesome_nested_set/awesome_nested_set.rb is fixed to not include AS clause in SQL's FROM clause for table aliasing (*AS clause not supported in Oracle in FROM clause for aliasing table name*)

2. Sample Oracle Adapter configuration added in database.yml

3. Gemfile updated to include oracle specific ruby gems.

4. quoting_of_multi_scope_column_names spec in spec/awesome_nested_set_spec.rb is enhanced to include proper strings as per DB connection.

5. multi_scoped_all_roots_valid? spec in spec/awesome_nested_set_spec.rb is failing due to limitation of Oracle's GROUP BY clause. For details, please refer [Oracle GROUP BY Clause Limitation](http://sqlzoo.net/howto/source/u.cgi/err979/oracle) .

6. multi_scoped_rebuild spec in spec/awesome_nested_set_spec.rb is failing due to no support of CLOB datatype in Oracle. For details and application specific solution, please refer [Changing Oracle CLOBs to VARCHAR2s](http://snippets.dzone.com/posts/show/3022) .