search

activewarehouse / rails_sql_views

Rails SQL Views project extracted from ActiveWarehouse
http://activewarehouse.rubyforge.org/rails_sql_views
MIT License
140 stars 129 forks source link

incorrect drop table statement generated for activerecord-oracle_enhanced-adapter #10

Open dchelimsky opened 13 years ago

dchelimsky commented 13 years ago 
Error dropping table test_records: OCIError: ORA-00905: missing keyword: DROP TABLE "TEST_RECORDS" CASCADE

The statement should read "DROP TABLE "TEST_RECORDS" CASCADE CONSTRAINTS"

I took a look at patching this by adding the drop_table_with_cascade method to RailsSqlViews::ConnectionAdapters::OracleEnhanced, but for some reason unbeknownst to me the drop_table_with_cascade method in RailsSqlViews::ConnectionAdapters::SchemaStatements was called (even though the RailsSqlViews::ConnectionAdapters::OracleEnhanced module gets included later).