#first seems to create incorrect sql (LIMIT instead of ROWNUM) when using oracle_enhanced, rails 3.1.0.rc5

rownum_mia

Warning: NLS_LANG is not set. fallback to US-ASCII.
Loading development environment (Rails 3.1.0.rc5)
ruby-1.9.2-p290-i386 :001 > Title.connection.class
 => ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter 
ruby-1.9.2-p290-i386 :002 > Title.first
  OB Columns (1707.7ms)  SELECT column_name AS name, data_type AS sql_type, data_default, nullable, virtual_column, hidden_column, DECODE(data_type, 'NUMBER', data_precision, 'FLOAT', data_precision, 'VARCHAR2', DECODE(char_used, 'C', char_length, data_length), 'RAW', DECODE(char_used, 'C', char_length, data_length), 'CHAR', DECODE(char_used, 'C', char_length, data_length), NULL) AS limit, DECODE(data_type, 'NUMBER', data_scale, NULL) AS scale FROM all_tab_cols WHERE owner = 'CV' AND table_name = 'OB' AND hidden_column = 'NO' ORDER BY column_id
  Title Load (76.6ms)  SELECT "OB".* FROM "OB" LIMIT 1
OCIError: ORA-00933: SQL command not properly ended: SELECT  "OB".* FROM "OB"  LIMIT 1
ActiveRecord::StatementInvalid: OCIError: ORA-00933: SQL command not properly ended: SELECT  "OB".* FROM "OB"  LIMIT 1
	from stmt.c:312:in oci8lib_191.bundle
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/ruby-oci8-2.0.6/lib/oci8/oci8.rb:288:in `exec'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-oracle_enhanced-adapter-1.4.0/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.rb:141:in `exec'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-oracle_enhanced-adapter-1.4.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:593:in `block in exec_query'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract_adapter.rb:222:in `block in log'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activesupport-3.1.0.rc5/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract_adapter.rb:217:in `log'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-oracle_enhanced-adapter-1.4.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1226:in `log'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-oracle_enhanced-adapter-1.4.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:573:in `exec_query'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-oracle_enhanced-adapter-1.4.0/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1180:in `select'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract/database_statements.rb:9:in `select_all'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/base.rb:470:in `find_by_sql'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/relation.rb:111:in `to_a'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/relation/finder_methods.rb:370:in `find_first'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/relation/finder_methods.rb:122:in `first'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/activerecord-3.1.0.rc5/lib/active_record/base.rb:437:in `first'
	from (irb):2
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/railties-3.1.0.rc5/lib/rails/commands/console.rb:45:in `start'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/railties-3.1.0.rc5/lib/rails/commands/console.rb:8:in `start'
	from /Users/bence/.rvm/gems/ruby-1.9.2-p290-i386@tools/gems/railties-3.1.0.rc5/lib/rails/commands.rb:40:in `<top (required)>'
	from script/rails:6:in `require'
	from script/rails:6:in `<main>'ruby-1.9.2-p290-i386 :003 >