Skip to content

Latest commit

 

History

History
479 lines (401 loc) · 22.6 KB

History.md

File metadata and controls

479 lines (401 loc) · 22.6 KB
Raw

1.5.6 / 2015-03-30

  • Enhancements

  • Support Rails 4.1.10 [#530]

  • Remove warning message when JDK 8 is used [#525]

  • Support RAW column types [#471]

  • Properly quote database links [#556]

  • Grant create view privilege to db user [#528]

  • Read SYSTEM password from ENV ORACLE_SYSTEM_PASSWORD optionally [#529]

  • Show original error message when loading ruby-oci8 library fails [#532]

  • Update README that OracleEnhancedProcedures is not auto loaded [#474]

  • Fix legacy schema support syntax [#507]

  • Peform all unit test when tested with Oracle 12c [#465]

  • Add :if_exists option to drop_table [#541]

  • Extract OracleEnhancedDatabaseStatements [#449]

  • Removed self.visitor_for(pool) method [#501]

  • Bug Fix

  • Fix serialized readonly lobs [#515]

  • Do not dump schema information during structure dump [#558]

  • Structure dump generates correct create or replace synonym [#453]

  • Procedures and functions are created correctly by removing semi-colon [#456]

  • Show support matrix of Java and JDBC Driver only when java_version >= '1.8' [#455]

  • Update Gemfile dependencies so specs can run [#472]

1.5.5 / 2014-05-23

  • Enhancements

  • Oracle NUMBER datatype can be handled as Rails :float datatype [#418]

    • Default NUMBER datatype handled as :decimal to keep compatibility
    • Configured by setting self.number_datatype_coercion = :float

  • Add link to supported Oracle database version, JDK and Oracle JDBC Driver version [#438]

  • Support without_prepared_statements? to handle unprepared_statement [#447]

  • Bug Fix

    • Associations with name record do not work correctly since Rails 4 [#435]
    • Skip another Oracle Text test when Oracle 12c used [#437]
    • Tag bind params with a bind param object [#444]

1.5.4 / 2014-03-25

  • Enhancements

  • Support Rails 4.1.0.rc2

  • Allow Java 8 to run with jruby [#383]

  • Bug Fix

    • Fix db:schema:dump when foreign key column name is not 'id' [#409]
    • Fix schema dump works when non Oracle adapter used [#428]

1.5.3 / 2014-03-04

  • Enhancements

  • Supports Rails 4.1.0.rc1

  • Support rails/rails#13886 by chainging select_rows arguments [#415]

  • Bug Fix

    • Fix ORA-01008: not all variables bound [#422]

1.5.2 / 2014-01-24

  • Enhancements

  • Supports Rails 4.1.0.beta1

  • Support Rails 4 Database Tasks [#404]

  • Create sequence when add primary_key column [#406]

  • Move SchemaCreation to its own file [#381]

  • Remove unused OracleEnhancedColumnDefinition [#382]

  • Log bind variables after they were type casted [#385]

  • Remove add_order_by_for_association_limiting! [#388]

  • Support named savepoints [#389]

  • Support self.extract_value_from_default [#395]

  • Remove oracle_enhanced_core_ext.rb [#397]

  • Remove unused to_sql_with_foreign_keys and lob_columns [#398]

  • Remove ruby-oci8 v1 code [#405]

  • Bug Fix

    • Move add_column_options! into SchemaCreation class [#384]
    • Add options_include_default! [#384]
    • Use OCI8::Metadata::Base#obj_link [#399]

1.5.1 / 2013-11-30

  • Enhancements

  • Removed set_table_name set_primary_key set_sequence_name from unit tests [#364]

  • Update README to support assignment methods [#365]

  • Remove add_limit_offset! method [#369]

  • Update Gemfile to use bundle config --local [#370]

  • describe does not try super when no datbase link and ORA-4043 returned [#375]

  • Support remove_columns [#377]

  • Dump views in alphabetical order and add FORCE option [#378]

  • Bug Fix

  • Fixed reverting add_column fails with v1.5.0 [#373]

1.5.0 / 2013-11-01

  • Enhancements
  • Add license in gemspec and Rakefile [#361]

1.5.0.rc1 / 2013-10-31

  • Update README and HISTORY
  • No other changes since 1.5.0.beta1

1.5.0.beta1 / 2013-10-28

  • Enhancements and major changes

  • Support Rails 4.0

  • Desupport Rails 3.2 and lower version. To support Rails 3.2, use Version 1.4.3

  • Drop session store support [#219]

  • Create indexes automatically for references and belongs_to [#183]

  • Use the index name explicitly provided in a migration when reverting [#296]

  • Rename indexes when a table or column is renamed [#286]

  • Support refactored remove_column [#172]

  • Support allowed_index_name_length method [#285]

  • Remove schema prefix from sequence name if present before truncating [#155]

  • Bumped jeweler, ruby-plsql and ruby-oci8 version [#176]

  • Support also ojdbc6.jar for Java 1.7 [#350]

  • Support "activerecord-deprecated_finders" [#210]

  • Prepared statements can be disabled [#295]

  • Ensure disconnecting or reconnecting resets the transaction state [#220]

  • Support for specifying transaction isolation level [#226]

  • Rename the partial_updates config to partial_writes [#234]

  • Deprecate passing a string as third argument of add_index [#242]

  • Rename update method to update_record, create method to create_record [#273]

  • Deprecate #connection in favour of accessing it via the class [#297]

  • Support SchemaCreation [#298]

  • Add support for foreign key creation in create_table [#317]

  • Add virtual columns support for rail4 branch [#329]

  • Support columns_for_distinct method [#340]

  • Clear index cache when any table dropped [#200]

  • Clear index cache when remove_column executed [#269]

  • Dump schema uses ruby 1.9 style hash [#229]

  • Support _field_changed? and drop field_changed? [#182 #254]

  • Use arel nodes instead of raw sql [#198]

  • Raise an ArgumentError when passing an invalid option to add_index [#242]

  • Split OracleEnhancedColumnDumper from OracleEnhancedSchemaDumper [#292]

  • Unit test sets default_timezone = :local [#184]

  • Support reset_pk_sequence! [#287]

  • Remove unnecessary pendings in unit tests [#358]

  • Bug Fix

  • Address ArgumentError: wrong number of arguments (5 for 3) [#166]

  • Address NoMethodError: undefined method `column_types' [#173]

  • Schema dumper removes table_name_prefix and table_name_suffix [#191]

  • Add clear_logger to address ArgumentError: wrong number of arguments (1 for 2) [#193]

  • Use Relation#to_a as Relation#all is deprecated in Rails [#203]

  • Address Address test_integer_zero_to_integer_zero_not_marked_as_changed failure [#207]

  • Address NoMethodError undefined method `default_string' [#221]

  • Address you can't redefine the primary key column 'id'. To define a custom primary key, pass { id: false } to create_table [#238]

  • Remove unnecessary DEPRECATION WARNING [#255]

  • Assigning "0.0" to a nullable numeric column does not make it dirty [#293]

  • Address rake spec abort [#353]

  • Correct activerecord-deprecated_finders not loaded if ENV['RAILS_GEM_VERSION'] set [#353]

  • Known Issues

  • Oracle Text features are not fully supported with Oracle 12c [#331]

1.4.3 / 2013-10-24

  • No changes since 1.4.3.rc2

1.4.3.rc2 / 2013-10-23

  • Change build procedures
  • No other changes since 1.4.3.rc1

1.4.3.rc1 / 2013-10-19

  • Enhancements:

    • Allow inserting NULL to Oracle Spatial Data Types such as MDSYS.SDO_GEOMETRY [#311]
    • Support ojdbc7.jar JDBC Driver [#335]

  • Bug fixes:

    • Fixed Gemfile to bundle update work [#294]
    • Fixed broken links in README.md and RUNNING_TESTS.md [#303 #306]
    • Address rename_table works if the source table created with :id => false [#336]
    • Use expand_path to show VERSION with Windows XP

1.4.2 / 2013-03-18

  • No changes since 1.4.2.rc2

1.4.2.rc2 / 2013-03-01

  • Bug fixes:
    • Do not consider the numeric attribute as changed if the old value is zero and the new value is not a string [#247]
    • Removed table_name_prefix and table_name_suffix when schema dumper executed [#248]
    • Remove_column should raise an ArgumentError when no columns are passed [#246]
    • Don't dump type for NUMBER virtual columns [#256]
    • Address :returning_id column should be of type Column [#274]
    • Migrated versions should be dumped in order [#277]
    • Always write serialized LOB columns [#275]
    • Truncate the schema_migrations index [#276]
    • Split paths on windows machines in the right way [#231]

1.4.2.rc1 / 2012-11-13

  • Enhancements:
    • Wordlist option for context index [#154]
    • Fall back to directly connecting via OracleDriver on JRuby [#163]
    • Allow slash-prefixed database name in database.yml for using a service [#201]
  • Bug fixes:
    • Fixed explain plans to work with JDBC and OCI8 [#146]
    • Fixed various issues with virtual columns [#159]
    • Fixed SQL structure dump with function indexes [#161]
    • Fixed broken column remove inside a change_table block [#216]
    • Dump indexes on virtual columns using the column's name instead of the column expression [#211]
    • Don't update lobs that haven't changed or are attr_readonly [#212]
    • Support dirty tracking with rails 3.2.9

1.4.1 / 2012-01-27

  • Enhancements:
    • Support for Rails 3.2
    • Support for ActiveRecord 3.2 explain plans [#116]
    • Support for ActiveRecord 3.1 statement pool, to avoid ORA-01000 maximum open cursors exceeded (default statement_limit is 250 and can be changed in database.yml) [#100]
    • Added error handling for rename_table method in migrations [#137]
  • Bug fixes:
    • Store primary key as nil in cache at first time for table without primary key [#84]
    • Fixed inserting records with decimal type columns (ORA-01722 invalid number exceptions) [#130]
    • Check virtual columns only in models that are using oracle-enhanced adapter, to avoid problems when using multiple database adapters [#85]
    • Don't drop the user in rake db:create and db:drop tasks [#103]
    • Don't add db:create and db:drop when ActiveRecord is not used as the primary datastore [#128]
    • Quote column names in LOB statements to avoid ORA-00936 errors [#91]
    • Don't add the RETURNING clause if using composite_primary_keys gem [#132]
    • Added join_to_update method that is necessary for ActiveRecord 3.1 to ensure that correct UPDATE statement is generated using WHERE ... IN subquery with offset condition

1.4.0 / 2011-08-09

  • Enhancements:
    • Support for Rails 3.1
    • Bind parameter support for exec_insert, exec_update and exec_delete (in ActiveRecord 3.1)
    • Purge recyclebin on rake db:test:purge
    • Support transactional context index
    • Require ojdbc6.jar (on Java 6) or ojdbc5.jar (on Java 5) JDBC drivers
    • Support for RAW data type
    • rake db:create and db:drop tasks
    • Support virtual columns (in Oracle 11g) in schema dump
    • It is possible to specify default tablespaces for tables, indexes, CLOBs and BLOBs
    • rename_index migrations method
    • Search for JDBC driver in ./lib directory of Rails application
  • Bug fixes:
    • Fixed context index dump when definition is larger than 4000 bytes
    • Fixed schema dump not to conflict with other database adapters that are used in the same application
    • Allow $ in table name prefix or suffix

1.3.2 / 2011-01-05

  • Enhancements:
    • If no :host or :port is provided then connect with :database name (do not default :host to localhost)
    • Database connection pool support for JRuby on Tomcat and JBoss application servers
    • NLS connection parameters support via environment variables or database.yml
    • Support for Arel 2.0 and latest Rails master branch
    • Support for Rails 3.1 prepared statements (implemented in not yet released Rails master branch version)
    • Eager loading of included association with more than 1000 records (implemented in not yet released Rails master branch version)
  • Bug fixes:
    • Foreign keys are added after table definitions in schema dump to ensure correct order of schema statements
    • Quote NCHAR and NVARCHAR2 type values with N'...'
    • Numeric username and/or password in database.yml will be automatically converted to string

1.3.1 / 2010-09-09

  • Enhancements:
    • Tested with Rails 3.0.0 release
    • Lexer options for context index creation
    • Added Bundler for running adapter specs, added RUNNING_TESTS.rdoc with description how to run specs
    • Connection to database using :host, :port and :database options
    • Improved loading of adapter in Rails 3 using railtie
  • Bug fixes:
    • Fix for custom context index procedure when indexing records with null values
    • Quote table and column names in write_lobs callback
    • Fix for incorrect column SQL types when two models use the same table and AR query cache is enabled
    • Fixes for schema and scructure dump tasks
    • Fix for handling of zero-length strings in BLOB and CLOB columns
    • removed String.mb_chars upcase and downcase methods for Ruby 1.9 as Rails 3.0.0 already includes Unicode aware upcase and downcase methods for Ruby 1.9
    • Fixes for latest ActiveRecord unit tests

1.3.0 / 2010-06-21

  • Enhancements:
    • Rails 3.0.0.beta4 and Rails 2.3.x compatible
    • When used with Rails 3 then works together with Oracle SQL compiler included in Arel gem (http://github.com/rails/arel)
    • Rails 3: Better support for limit and offset (when possible adds just ROWNUM condition in WHERE clause without using subqueries)
    • Table and column names are always quoted and in uppercase to avoid the need for checking Oracle reserved words
    • Full text search index creation (add_context_index and remove_context_index methods in migrations and #contains method in ActiveRecord models)
    • add_index and remove_index give just warnings on wrong index names (new expected behavior in Rails 2.3.8 and 3.0.0)
    • :tablespace and :options options for create_table and add_index
  • Workarounds:
    • Rails 3: set ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter.cache_columns = true in initializer file for all environments (to avoid too many data dictionary queries from Arel)
    • Rails 2.3: patch several ActiveRecord methods to work correctly with quoted table names in uppercase (see oracle_enhanced_activerecord_patches.rb). These patches are already included in Rails 3.0.0.beta4.
  • Bug fixes:
    • Fixes for schema purge (drop correctly materialized views)
    • Fixes for schema dump and structure dump (use correct statement separator)
    • Only use Oracle specific schema dump for Oracle connections

1.2.4 / 2010-02-23

  • Enhancements:
    • rake db:test:purge will drop all schema objects from test schema (including views, synonyms, packages, functions, procedures) - they should be always reloaded before tests run if necessary
    • added views, synonyms, packages, functions, procedures, indexes, triggers, types, primary, unique and foreign key constraints to structure dump
    • added :temporary option for create_table to create temporary tables
    • added :tablespace option for add_index
    • support function based indexes in schema dump
    • support JNDI database connections in JRuby
    • check ruby-oci8 minimum version 2.0.3
    • added savepoints support (nested ActiveRecord transactions)
  • Bug fixes:
    • typecast returned BigDecimal integer values to Fixnum or Bignum (to avoid issues with _before_type_cast values for id attributes because _before_type_cast is used in form helpers)
    • clear table columns cache after columns definition change in migrations

1.2.3 / 2009-12-09

  • Enhancements
    • support fractional seconds in TIMESTAMP values
    • support for ActiveRecord 2.3.5
    • use ENV['TZ'] to set database session time zone (as a result DATE and TIMESTAMP values are retrieved with correct time zone)
    • added cache_columns adapter option
    • added current_user adapter method
    • added set_integer_columns and set_string_columns ActiveRecord model class methods
  • Bug fixes:
    • do not raise exception if ENV['PATH'] is nil
    • do not add change_table behavior for ActiveRecord 2.0 (to avoid exception during loading)
    • move foreign key definitions after definition of all tables in schema.rb (to avoid definition of foreign keys before all tables are created)
    • changed timestamp format mask to use ':' before fractional seconds (workaround to avoid table detection in tables_in_string method in ActiveRecord associations.rb file)
    • fixed custom create/update/delete methods with ActiveRecord 2.3+ and timestamps
    • do not call oracle_enhanced specific schema dump methods when using other database adapters

1.2.2 / 2009-09-28

  • Enhancements
    • improved RDoc documentation of public methods
    • structure dump optionally (database.yml environment has db_stored_code: yes) extracts packages, procedures, functions, views, triggers and synonyms
    • automatically generated too long index names are shortened down to 30 characters
    • create tables with primary key triggers
    • use 'set_sequence_name :autogenerated' for inserting into legacy tables with trigger populated primary keys
    • access to tables over database link (need to define local synonym to remote table and use local synonym in set_table_name)
    • [JRuby] support JDBC connection using TNS_ADMIN environment variable and TNS database alias
    • changed cursor_sharing option default from 'similar' to 'force'
    • optional dbms_output logging to ActiveRecord log file (requires ruby-plsql gem)
    • use add_foreign_key and remove_foreign_key to define foreign key constraints (the same syntax as in http://github.com/matthuhiggins/foreigner and similar to http://github.com/eyestreet/active_record_oracle_extensions)
    • raise RecordNotUnique and InvalidForeignKey exceptions if caused by corresponding ORA errors (these new exceptions are supported just by current ActiveRecord master branch)
    • implemented disable_referential_integrity (enables safe loading of fixtures in schema with foreign key constraints)
    • use add_synonym and remove_synonym to define database synonyms
    • add_foreign_key and add_synonym are also exported to schema.rb
  • Bug fixes:
    • [JRuby] do not raise LoadError if ojdbc14.jar cannot be required (rely on application server to add it to class path)
    • [JRuby] 'execute' can be used to create triggers with :NEW reference
    • support create_table without a block
    • support create_table with Symbol table name
    • use ActiveRecord functionality to do time zone conversion
    • rake tasks such as db:test:clone are redefined only if oracle_enhanced is current adapter in use
    • VARCHAR2 and CHAR column sizes are defined in characters and not in bytes (expected behavior from ActiveRecord)
    • set_date_columns, set_datetime_columns, ignore_table_columns will work after reestablishing connection
    • ignore :limit option for :text and :binary columns in migrations
    • patches for ActiveRecord schema dumper to remove table prefixes and suffixes from schema.rb

1.2.1 / 2009-06-07

  • Enhancements
    • caching of table indexes query which makes schema dump much faster
  • Bug fixes:
    • return Date (and not DateTime) values for :date column value before year 1970
    • fixed after_create/update/destroy callbacks with plsql custom methods
    • fixed creation of large integers in JRuby
    • Made test tasks respect RAILS_ENV
    • fixed support for composite primary keys for tables with LOBs

1.2.0 / 2009-03-22

  • Enhancements
    • support for JRuby and JDBC
    • support for Ruby 1.9.1 and ruby-oci8 2.0
    • support for Rails 2.3
    • quoting of Oracle reserved words in table names and column names
    • emulation of OracleAdapter (for ActiveRecord unit tests)
  • Bug fixes:
    • several bug fixes that were identified during running of ActiveRecord unit tests

1.1.9 / 2009-01-02

  • Enhancements
    • Added support for table and column comments in migrations
    • Added support for specifying sequence start values
    • Added :privilege option (e.g. :SYSDBA) to ActiveRecord::Base.establish_connection
  • Bug fixes:
    • Do not mark empty decimals, strings and texts (stored as NULL in database) as changed when reassigning them (starting from Rails 2.1)
    • Create booleans as VARCHAR2(1) columns if emulate_booleans_from_strings is true

1.1.8 / 2008-10-10

1.1.7 / 2008-08-20

  • Bug fixes:
    • Fixed that adapter works without ruby-plsql gem (in this case just custom create/update/delete methods are not available)

1.1.6 / 2008-08-19

  • Enhancements:
    • Added support for set_date_columns and set_datetime_columns
    • Added support for set_boolean_columns
    • Added support for schema prefix in set_table_name (removed table name quoting)
    • Added support for NVARCHAR2 column type
  • Bug fixes:
    • Do not call write_lobs callback when custom create or update methods are defined

1.1.5 / 2008-07-27

  • Bug fixes:
    • Fixed that write_lobs callback works with partial_updates enabled (added additional record lock before writing BLOB data to database)
  • Enhancements:
    • Changed SQL SELECT in indexes method so that it will execute faster on some large data dictionaries
    • Support for other date and time formats when assigning string to :date or :datetime column

1.1.4 / 2008-07-14

  • Enhancements:
    • Date/Time quoting changes to support composite_primary_keys
    • Added additional methods that are used by composite_primary_keys

1.1.3 / 2008-07-10

  • Enhancements:
    • Added support for custom create, update and delete methods when working with legacy databases where PL/SQL API should be used for create, update and delete operations

1.1.2 / 2008-07-08

  • Bug fixes:
    • Fixed after_save callback addition for session store in ActiveRecord version 2.0.2
    • Changed date column name recognition - now should match regex /(^|)date(|$)/i (previously "updated_at" was recognized as :date column and not as :datetime)

1.1.1 / 2008-06-28

  • Enhancements:
    • Added ignore_table_columns option
    • Added support for TIMESTAMP columns (without fractional seconds)
    • NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT independent DATE and TIMESTAMP columns support
  • Bug fixes:
    • Checks if CGI::Session::ActiveRecordStore::Session does not have enhanced_write_lobs callback before adding it (Rails 2.0 does not add this callback, Rails 2.1 does)

1.1.0 / 2008-05-05

  • Forked from original activerecord-oracle-adapter-1.0.0.9216
  • Renamed oracle adapter to oracle_enhanced adapter
    • Added "enhanced" to method and class definitions so that oracle_enhanced and original oracle adapter could be used simultaniously
    • Added Rails rake tasks as a copy from original oracle tasks
  • Enhancements:
    • Improved perfomance of schema dump methods when used on large data dictionaries
    • Added LOB writing callback for sessions stored in database
    • Added emulate_dates_by_column_name option
    • Added emulate_integers_by_column_name option
    • Added emulate_booleans_from_strings option