rsim/oracle-enhanced — Issue #124: ActiveRecord unit tests failures - Message: <"OCIError: ORA-00904: \"[:foo]\": invalid identifier: ALTER TABLE \"TESTINGS\" DROP COLUMN \"[:foo]\""> 
Author: yahonda
Created: 2011-11-13 23:40:49+00:00
State: open

Since this commit has merged to rails master branch, ActiveRecord unit test for Oracle database got two failures.

https://github.com/rails/rails/commit/81fad6a270ec3cbbb88553c9f2e8200c34fd4d13

I'm not sure which projects to issue this failure, now I make this post to here.
I have not found any possible source code to address these failures.

```ruby

$ cd activerecord
$ rake test_oracle
... snip ...
2) Failure:
test_change_table_should_not_have_mixed_syntax(SexierMigrationsTest) [/home/yahonda/Dropbox/git/rails/activerecord/test/cases/migration_test.rb:1801]:
[NoMethodError] exception expected, not
Class:
Message: <"OCIError: ORA-00904: \"[:foo]\": invalid identifier: ALTER TABLE \"TESTINGS\" DROP COLUMN \"[:foo]\"">
---Backtrace---
stmt.c:312:in oci8lib_191.so
/home/yahonda/.rvm/gems/ruby-1.9.3-p0@rails_master/gems/ruby-oci8-2.0.6/lib/oci8/oci8.rb:288:in `exec'
/home/yahonda/.rvm/gems/ruby-1.9.3-p0@rails_master/gems/ruby-oci8-2.0.6/lib/oci8/oci8.rb:116:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:469:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:88:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:589:in `block in execute'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:262:in `block in log'
/home/yahonda/Dropbox/git/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:257:in `log'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1292:in `log'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:589:in `execute'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_schema_statements.rb:260:in `remove_column'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb:383:in `remove'
/home/yahonda/Dropbox/git/rails/activerecord/test/cases/migration_test.rb:1803:in `block (2 levels) in test_change_table_should_not_have_mixed_syntax'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:251:in `change_table'
/home/yahonda/Dropbox/git/rails/activerecord/test/cases/migration_test.rb:1802:in `block in test_change_table_should_not_have_mixed_syntax'
---------------

3) Error:
test_change_table_without_block_parameter_no_bulk(SexierMigrationsTest):
ActiveRecord::StatementInvalid: OCIError: ORA-00904: "[:foo]": invalid identifier: ALTER TABLE "TESTINGS" DROP COLUMN "[:foo]"
stmt.c:312:in oci8lib_191.so
/home/yahonda/.rvm/gems/ruby-1.9.3-p0@rails_master/gems/ruby-oci8-2.0.6/lib/oci8/oci8.rb:288:in `exec'
/home/yahonda/.rvm/gems/ruby-1.9.3-p0@rails_master/gems/ruby-oci8-2.0.6/lib/oci8/oci8.rb:116:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:469:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:88:in `exec'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:589:in `block in execute'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:262:in `block in log'
/home/yahonda/Dropbox/git/rails/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:257:in `log'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1292:in `log'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:589:in `execute'
/home/yahonda/Dropbox/git/oracle-enhanced/lib/active_record/connection_adapters/oracle_enhanced_schema_statements.rb:260:in `remove_column'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_definitions.rb:383:in `remove'
/home/yahonda/Dropbox/git/rails/activerecord/test/cases/migration_test.rb:1768:in `block in test_change_table_without_block_parameter_no_bulk'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:253:in `instance_eval'
/home/yahonda/Dropbox/git/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:253:in `change_table'
/home/yahonda/Dropbox/git/rails/activerecord/test/cases/migration_test.rb:1767:in `test_change_table_without_block_parameter_no_bulk'
/home/yahonda/.rvm/gems/ruby-1.9.3-p0@rails_master/gems/mocha-0.10.0/lib/mocha/integration/mini_test/version_230_to_251.rb:28:in `run'

3121 tests, 9579 assertions, 1 failures, 2 errors, 0 skips
rake aborted!
Command failed with status (3): [/home/yahonda/.rvm/rubies/ruby-1.9.3-p0/bi...]

Tasks: TOP => test_oracle
(See full trace by running task with --trace)
[1.9.3@rails_master] yahonda@myoel6 ~/Dropbox/git/rails/activerecord (master)
$
```