root/branches/1-2-stable/activerecord/CHANGELOG

*1.15.6* (November 24th, 2007)

* Allow association redefinition in subclasses.  #9346 [wildchild]

* Fix has_many :through delete with custom foreign keys.  #6466 [naffis]

* Fix regression where the association would not construct new finder SQL on save causing bogus queries for "WHERE owner_id = NULL" even after owner was saved.  #8713 [Bryan Helmkamp]


*1.15.5* (October 12th, 2007)

* Depend on Action Pack 1.4.4


*1.15.4* (October 4th, 2007)

* Fix #count on a has_many :through association so that it recognizes the :uniq option. Closes #8801 [lifofifo]

* Don't clobber includes passed to has_many.count [danger]

* Make sure has_many uses :include when counting [danger]

* Save associated records only if the association is already loaded.  #8713 [blaine]

* Changing the :default Date format doesn't break date quoting.  #6312 [bshand, Elias]

* Allow nil serialized attributes with a set class constraint. #7293 [sandofsky]

* belongs_to assignment creates a new proxy rather than modifying its target in-place.  #8412 [mmangino@elevatedrails.com]

* Fix column type detection while loading fixtures.  Closes #7987 [roderickvd]

* Document deep eager includes.  #6267 [Josh Susser, Dan Manges]

* Oracle: extract column length for CHAR also.  #7866 [ymendel]

* Small additions and fixes for ActiveRecord documentation.  Closes #7342 [jeremymcanally]

* SQLite: binary escaping works with $KCODE='u'.  #7862 [tsuka]

* Improved cloning performance by relying less on exception raising #8159 [Blaine]


*1.15.3* (March 12th, 2007)

* Allow a polymorphic :source for has_many :through associations. Closes #7143 [protocool] 

* Consistently quote primary key column names.  #7763 [toolmantim]

* Fixtures: fix YAML ordered map support.  #2665 [Manuel Holtgrewe, nfbuckley]

* Fix has_many :through << with custom foreign keys.  #6466, #7153 [naffis, Rich Collins]


*1.15.2* (February 5th, 2007)

* Pass a range in :conditions to use the SQL BETWEEN operator.  #6974 [dcmanges]
    Student.find(:all, :conditions => { :grade => 9..12 })

* Don't create instance writer methods for class attributes. [Rick]

* When dealing with SQLite3, use the table_info pragma helper, so that the bindings can do some translation for when sqlite3 breaks incompatibly between point releases. [Jamis Buck]

* SQLServer: don't choke on strings containing 'null'.  #7083 [Jakob S]

* Consistently use LOWER() for uniqueness validations (rather than mixing with UPPER()) so the database can always use a functional index on the lowercased column.  #6495 [Si]

* MySQL: SET SQL_AUTO_IS_NULL=0 so 'where id is null' doesn't select the last inserted id.  #6778 [Jonathan Viney, timc]

* Fixtures use the table name and connection from set_fixture_class.  #7330 [Anthony Eden]

* SQLServer: quote table name in indexes query.  #2928 [keithm@infused.org]


*1.15.1* (January 17th, 2007)

* Fix nodoc breaking of adapters


*1.15.0* (January 16th, 2007)

* [DOC] clear up some ambiguity with the way has_and_belongs_to_many creates the default join table name.  #7072 [jeremymcanally]

* change_column accepts :default => nil. Skip column options for primary keys.  #6956, #7048 [dcmanges, Jeremy Kemper]

* MySQL, PostgreSQL: change_column_default quotes the default value and doesn't lose column type information.  #3987, #6664 [Jonathan Viney, manfred, altano@bigfoot.com]

* Oracle: create_table takes a :sequence_name option to override the 'tablename_seq' default.  #7000 [Michael Schoen]

* MySQL: retain SSL settings on reconnect.  #6976 [randyv2]

* SQLServer: handle [quoted] table names.  #6635 [rrich]

* acts_as_nested_set works with single-table inheritance.  #6030 [Josh Susser]

* PostgreSQL, Oracle: correctly perform eager finds with :limit and :order.  #4668, #7021 [eventualbuddha, Michael Schoen]

* Fix the Oracle adapter for serialized attributes stored in CLOBs.  Closes #6825 [mschoen, tdfowler]

* [DOCS] Apply more documentation for ActiveRecord Reflection.  Closes #4055 [Robby Russell]

* [DOCS] Document :allow_nil option of #validate_uniqueness_of. Closes #3143 [Caio Chassot]

* Bring the sybase adapter up to scratch for 1.2 release. [jsheets]

* Oracle: fix connection reset failure.  #6846 [leonlleslie]

* Subclass instantiation doesn't try to explicitly require the corresponding subclass.  #6840 [leei, Jeremy Kemper]

* fix faulty inheritance tests and that eager loading grabs the wrong inheritance column when the class of your association is an STI subclass. Closes #6859 [protocool]

* find supports :lock with :include. Check whether your database allows SELECT ... FOR UPDATE with outer joins before using.  #6764 [vitaly, Jeremy Kemper]

* Support nil and Array in :conditions => { attr => value } hashes.  #6548 [Assaf, Jeremy Kemper]
    find(:all, :conditions => { :topic_id => [1, 2, 3], :last_read => nil }

* Quote ActiveSupport::Multibyte::Chars.  #6653 [Julian Tarkhanov]

* MySQL: detect when a NOT NULL column without a default value is misreported as default ''.  Can't detect for string, text, and binary columns since '' is a legitimate default.  #6156 [simon@redhillconsulting.com.au, obrie, Jonathan Viney, Jeremy Kemper]

* validates_numericality_of uses \A \Z to ensure the entire string matches rather than ^ $ which may match one valid line of a multiline string.  #5716 [Andreas Schwarz]

* Oracle: automatically detect the primary key.  #6594 [vesaria, Michael Schoen]

* Oracle: to increase performance, prefetch 100 rows and enable similar cursor sharing. Both are configurable in database.yml.  #6607 [philbogle@gmail.com, ray.fortna@jobster.com, Michael Schoen]

* Firebird: decimal/numeric support.  #6408 [macrnic]

* Find with :include respects scoped :order.  #5850

* Dynamically generate reader methods for serialized attributes.  #6362 [Stefan Kaes]

* Deprecation: object transactions warning.  [Jeremy Kemper]

* has_one :dependent => :nullify ignores nil associates.  #6528 [janovetz, Jeremy Kemper]

* Oracle: resolve test failures, use prefetched primary key for inserts, check for null defaults, fix limited id selection for eager loading. Factor out some common methods from all adapters.  #6515 [Michael Schoen]

* Make add_column use the options hash with the Sqlite Adapter. Closes #6464 [obrie]

* Document other options available to migration's add_column. #6419 [grg]

* MySQL: all_hashes compatibility with old MysqlRes class.  #6429, #6601 [Jeremy Kemper]

* Fix has_many :through to add the appropriate conditions when going through an association using STI. Closes #5783. [Jonathan Viney]

* fix select_limited_ids_list issues in postgresql, retain current behavior in other adapters [Rick]

* Restore eager condition interpolation, document it's differences [Rick]

* Don't rollback in teardown unless a transaction was started. Don't start a transaction in create_fixtures if a transaction is started.  #6282 [Jacob Fugal, Jeremy Kemper]

* Add #delete support to has_many :through associations.  Closes #6049 [Martin Landers]

* Reverted old select_limited_ids_list postgresql fix that caused issues in mysql.  Closes #5851 [Rick]

* Removes the ability for eager loaded conditions to be interpolated, since there is no model instance to use as a context for interpolation. #5553 [turnip@turnipspatch.com]

* Added timeout option to SQLite3 configurations to deal more gracefully with SQLite3::BusyException, now the connection can instead retry for x seconds to see if the db clears up before throwing that exception #6126 [wreese@gmail.com]

* Added update_attributes! which uses save! to raise an exception if a validation error prevents saving #6192 [jonathan]

* Deprecated add_on_boundary_breaking (use validates_length_of instead) #6292 [BobSilva]

* The has_many create method works with polymorphic associations.  #6361 [Dan Peterson]

* MySQL: introduce Mysql::Result#all_hashes to support further optimization.  #5581 [Stefan Kaes]

* save! shouldn't validate twice.  #6324 [maiha, Bob Silva]

* Association collections have an _ids reader method to match the existing writer for collection_select convenience (e.g. employee.task_ids). The writer method skips blank ids so you can safely do @employee.task_ids = params[:tasks] without checking every time for an empty list or blank values.  #1887, #5780 [Michael Schuerig]

* Add an attribute reader method for ActiveRecord::Base.observers [Rick Olson]

* Deprecation: count class method should be called with an options hash rather than two args for conditions and joins.  #6287 [Bob Silva]

* has_one associations with a nil target may be safely marshaled.  #6279 [norbauer, Jeremy Kemper]

* Duplicate the hash provided to AR::Base#to_xml to prevent unexpected side effects [Koz]

* Add a :namespace option to  AR::Base#to_xml [Koz]

* Deprecation tests. Remove warnings for dynamic finders and for the foo_count method if it's also an attribute. [Jeremy Kemper]

* Mock Time.now for more accurate Touch mixin tests.  #6213 [Dan Peterson]

* Improve yaml fixtures error reporting.  #6205 [Bruce Williams]

* Rename AR::Base#quote so people can use that name in their models. #3628 [Koz]

* Add deprecation warning for inferred foreign key. #6029 [Josh Susser]

* Fixed the Ruby/MySQL adapter we ship with Active Record to work with the new authentication handshake that was introduced in MySQL 4.1, along with the other protocol changes made at that time #5723 [jimw@mysql.com]

* Deprecation: use :dependent => :delete_all rather than :exclusively_dependent => true.  #6024 [Josh Susser]

* Optimistic locking: gracefully handle nil versions, treat as zero.  #5908 [Tom Ward]

* to_xml: the :methods option works on arrays of records.  #5845 [Josh Starcher]

* has_many :through conditions are sanitized by the associating class.  #5971 [martin.emde@gmail.com]

* Fix spurious newlines and spaces in AR::Base#to_xml output [Jamis Buck]

* has_one supports the :dependent => :delete option which skips the typical callback chain and deletes the associated object directly from the database.  #5927 [Chris Mear, Jonathan Viney]

* Nested subclasses are not prefixed with the parent class' table_name since they should always use the base class' table_name.  #5911 [Jonathan Viney]

* SQLServer: work around bug where some unambiguous date formats are not correctly identified if the session language is set to german.  #5894 [Tom Ward, kruth@bfpi]

* Clashing type columns due to a sloppy join shouldn't wreck single-table inheritance.  #5838 [Kevin Clark]

* Fixtures: correct escaping of \n and \r.  #5859 [evgeny.zislis@gmail.com]

* Migrations: gracefully handle missing migration files.  #5857 [eli.gordon@gmail.com]

* MySQL: update test schema for MySQL 5 strict mode.  #5861 [Tom Ward]

* to_xml: correct naming of included associations.  #5831 [josh.starcher@gmail.com]

* Pushing a record onto a has_many :through sets the association's foreign key to the associate's primary key and adds it to the correct association.  #5815, #5829 [josh@hasmanythrough.com]

* Add records to has_many :through using <<, push, and concat by creating the association record. Raise if base or associate are new records since both ids are required to create the association. #build raises since you can't associate an unsaved record. #create! takes an attributes hash and creates the associated record and its association in a transaction. [Jeremy Kemper]

    # Create a tagging to associate the post and tag.
    post.tags << Tag.find_by_name('old')
    post.tags.create! :name => 'general'

    # Would have been:
    post.taggings.create!(:tag => Tag.find_by_name('finally')
    transaction do
      post.taggings.create!(:tag => Tag.create!(:name => 'general'))
    end

* Cache nil results for :included has_one associations also.  #5787 [Michael Schoen]

* Fixed a bug which would cause .save to fail after trying to access a empty has_one association on a unsaved record. [Tobias Luetke]

* Nested classes are given table names prefixed by the singular form of the parent's table name. [Jeremy Kemper]
    Example: Invoice::Lineitem is given table name invoice_lineitems

* Migrations: uniquely name multicolumn indexes so you don't have to. [Jeremy Kemper]
    # people_active_last_name_index, people_active_deactivated_at_index
    add_index    :people, [:active, :last_name]
    add_index    :people, [:active, :deactivated_at]
    remove_index :people, [:active, :last_name]
    remove_index :people, [:active, :deactivated_at]

  WARNING: backward-incompatibility. Multicolumn indexes created before this
  revision were named using the first column name only. Now they're uniquely
  named using all indexed columns.

  To remove an old multicolumn index, remove_index :table_name, :first_column

* Fix for deep includes on the same association. [richcollins@gmail.com]

* Tweak fixtures so they don't try to use a non-ActiveRecord class.  [Kevin Clark]

* Remove ActiveRecord::Base.reset since Dispatcher doesn't use it anymore.  [Rick Olson]

* PostgreSQL: autodetected sequences work correctly with multiple schemas. Rely on the schema search_path instead of explicitly qualifying the sequence name with its schema.  #5280 [guy.naor@famundo.com]

* Replace Reloadable with Reloadable::Deprecated. [Nicholas Seckar]

* Cache nil results for has_one associations so multiple calls don't call the database.  Closes #5757. [Michael A. Schoen]

* Don't save has_one associations unnecessarily.  #5735 [Jonathan Viney]

* Refactor ActiveRecord::Base.reset_subclasses to #reset, and add global observer resetting.  [Rick Olson]

* Formally deprecate the deprecated finders. [Koz]

* Formally deprecate rich associations.  [Koz]

* Fixed that default timezones for new / initialize should uphold utc setting #5709 [daniluk@yahoo.com]

* Fix announcement of very long migration names.  #5722 [blake@near-time.com]

* The exists? class method should treat a string argument as an id rather than as conditions.  #5698 [jeremy@planetargon.com]

* Fixed to_xml with :include misbehaviors when invoked on array of model instances #5690 [alexkwolfe@gmail.com]

* Added support for conditions on Base.exists? #5689 [josh@joshpeek.com]. Examples:

    assert (Topic.exists?(:author_name => "David")) 
          assert (Topic.exists?(:author_name => "Mary", :approved => true)) 
          assert (Topic.exists?(["parent_id = ?", 1]))

* Schema dumper quotes date :default values. [Dave Thomas]

* Calculate sum with SQL, not Enumerable on HasManyThrough Associations. [Dan Peterson]

* Factor the attribute#{suffix} methods out of method_missing for easier extension. [Jeremy Kemper]

* Patch sql injection vulnerability when using integer or float columns. [Jamis Buck]

* Allow #count through a has_many association to accept :include.  [Dan Peterson]

* create_table rdoc: suggest :id => false for habtm join tables. [Zed Shaw]

* PostgreSQL: return array fields as strings. #4664 [Robby Russell]

* SQLServer: added tests to ensure all database statements are closed, refactored identity_insert management code to use blocks, removed update/delete rowcount code out of execute and into update/delete, changed insert to go through execute method, removed unused quoting methods, disabled pessimistic locking tests as feature is currently unsupported, fixed RakeFile to load sqlserver specific tests whether running in ado or odbc mode, fixed support for recently added decimal types, added support for limits on integer types. #5670 [Tom Ward]

* SQLServer: fix db:schema:dump case-sensitivity. #4684 [Will Rogers]

* Oracle: BigDecimal support. #5667 [schoenm@earthlink.net]

* Numeric and decimal columns map to BigDecimal instead of Float. Those with scale 0 map to Integer. #5454 [robbat2@gentoo.org, work@ashleymoran.me.uk]

* Firebird migrations support. #5337 [Ken Kunz <kennethkunz@gmail.com>]

* PostgreSQL: create/drop as postgres user. #4790 [mail@matthewpainter.co.uk, mlaster@metavillage.com]

* PostgreSQL: correctly quote the ' in pk_and_sequence_for. #5462 [tietew@tietew.net]

* PostgreSQL: correctly quote microseconds in timestamps. #5641 [rick@rickbradley.com]

* Clearer has_one/belongs_to model names (account has_one :user). #5632 [matt@mattmargolis.net]

* Oracle: use nonblocking queries if allow_concurrency is set, fix pessimistic locking, don't guess date vs. time by default (set OracleAdapter.emulate_dates = true for the old behavior), adapter cleanup. #5635 [schoenm@earthlink.net]

* Fixed a few Oracle issues: Allows Oracle's odd date handling to still work consistently within #to_xml, Passes test that hardcode insert statement by dropping the :id column, Updated RUNNING_UNIT_TESTS with Oracle instructions, Corrects method signature for #exec #5294 [schoenm@earthlink.net]

* Added :group to available options for finds done on associations #5516 [mike@michaeldewey.org]

* Observers also watch subclasses created after they are declared. #5535 [daniels@pronto.com.au]

* Removed deprecated timestamps_gmt class methods. [Jeremy Kemper]

* rake build_mysql_database grants permissions to rails@localhost. #5501 [brianegge@yahoo.com]

* PostgreSQL: support microsecond time resolution. #5492 [alex@msgpad.com]

* Add AssociationCollection#sum since the method_missing invokation has been shadowed by Enumerable#sum.

* Added find_or_initialize_by_X which works like find_or_create_by_X but doesn't save the newly instantiated record. [Sam Stephenson]

* Row locking. Provide a locking clause with the :lock finder option or true for the default "FOR UPDATE". Use the #lock! method to obtain a row lock on a single record (reloads the record with :lock => true). [Shugo Maeda]
    # Obtain an exclusive lock on person 1 so we can safely increment visits.
    Person.transaction do
      # select * from people where id=1 for update
      person = Person.find(1, :lock => true)
      person.visits += 1
      person.save!
    end

* PostgreSQL: introduce allow_concurrency option which determines whether to use blocking or asynchronous #execute. Adapters with blocking #execute will deadlock Ruby threads. The default value is ActiveRecord::Base.allow_concurrency. [Jeremy Kemper]

* Use a per-thread (rather than global) transaction mutex so you may execute concurrent transactions on separate connections. [Jeremy Kemper]

* Change AR::Base#to_param to return a String instead of a Fixnum. Closes #5320. [Nicholas Seckar]

* Use explicit delegation instead of method aliasing for AR::Base.to_param -> AR::Base.id. #5299 (skaes@web.de)

* Refactored ActiveRecord::Base.to_xml to become a delegate for XmlSerializer, which restores sanity to the mega method. This refactoring also reinstates the opinions that type="string" is redundant and ugly and nil-differentiation is not a concern of serialization [DHH]

* Added simple hash conditions to find that'll just convert hash to an AND-based condition string #5143 [hcatlin@gmail.com]. Example:

    Person.find(:all, :conditions => { :last_name => "Catlin", :status => 1 }, :limit => 2) 

...is the same as:

    Person.find(:all, :conditions => [ "last_name = ? and status = ?", "Catlin", 1 ], :limit => 2)
  
  This makes it easier to pass in the options from a form or otherwise outside.
    

* Fixed issues with BLOB limits, charsets, and booleans for Firebird #5194, #5191, #5189 [kennethkunz@gmail.com]

* Fixed usage of :limit and with_scope when the association in scope is a 1:m #5208 [alex@purefiction.net]

* Fixed migration trouble with SQLite when NOT NULL is used in the new definition #5215 [greg@lapcominc.com]

* Fixed problems with eager loading and counting on SQL Server #5212 [kajism@yahoo.com]

* Fixed that count distinct should use the selected column even when using :include #5251 [anna@wota.jp]

* Fixed that :includes merged from with_scope won't cause the same association to be loaded more than once if repetition occurs in the clauses #5253 [alex@purefiction.net]

* Allow models to override to_xml.  #4989 [Blair Zajac <blair@orcaware.com>]

* PostgreSQL: don't ignore port when host is nil since it's often used to label the domain socket.  #5247 [shimbo@is.naist.jp]

* Records and arrays of records are bound as quoted ids. [Jeremy Kemper]
    Foo.find(:all, :conditions => ['bar_id IN (?)', bars])
    Foo.find(:first, :conditions => ['bar_id = ?', bar])

* Fixed that Base.find :all, :conditions => [ "id IN (?)", collection ] would fail if collection was empty [DHH]

* Add a list of regexes assert_queries skips in the ActiveRecord test suite.  [Rick]

* Fix the has_and_belongs_to_many #create doesn't populate the join for new records.  Closes #3692 [josh@hasmanythrough.com]

* Provide Association Extensions access to the instance that the association is being accessed from.  
  Closes #4433 [josh@hasmanythrough.com]

* Update OpenBase adaterp's maintainer's email address. Closes #5176. [Derrick Spell]

* Add a quick note about :select and eagerly included associations. [Rick]

* Add docs for the :as option in has_one associations.  Closes #5144 [cdcarter@gmail.com]

* Fixed that has_many collections shouldn't load the entire association to do build or create [DHH]

* Added :allow_nil option for aggregations #5091 [ian.w.white@gmail.com]

* Fix Oracle boolean support and tests. Closes #5139. [schoenm@earthlink.net]

* create! no longer blows up when no attributes are passed and a :create scope is in effect (e.g. foo.bars.create! failed whereas foo.bars.create!({}) didn't.) [Jeremy Kemper]

* Call Inflector#demodulize on the class name when eagerly including an STI model.  Closes #5077 [info@loobmedia.com]

* Preserve MySQL boolean column defaults when changing a column in a migration. Closes #5015. [pdcawley@bofh.org.uk] 

* PostgreSQL: migrations support :limit with :integer columns by mapping limit < 4 to smallint, > 4 to bigint, and anything else to integer. #2900 [keegan@thebasement.org]

* Dates and times interpret empty strings as nil rather than 2000-01-01. #4830 [kajism@yahoo.com]

* Allow :uniq => true with has_many :through associations. [Jeremy Kemper]

* Ensure that StringIO is always available for the Schema dumper. [Marcel Molina Jr.]

* Allow AR::Base#to_xml to include methods too. Closes #4921. [johan@textdrive.com] 

* Remove duplicate fixture entry in comments.yml. Closes #4923. [Blair Zajac <blair@orcaware.com>]

* When grouping, use the appropriate option key. [Marcel Molina Jr.]

* Add support for FrontBase (http://www.frontbase.com/) with a new adapter thanks to the hard work of one Mike Laster. Closes #4093. [mlaster@metavillage.com]

* Add warning about the proper way to validate the presence of a foreign key. Closes #4147. [Francois Beausoleil <francois.beausoleil@gmail.com>]

* Fix syntax error in documentation. Closes #4679. [mislav@nippur.irb.hr] 

* Add Oracle support for CLOB inserts. Closes #4748. [schoenm@earthlink.net sandra.metz@duke.edu] 

* Various fixes for sqlserver_adapter (odbc statement finishing, ado schema dumper, drop index). Closes #4831. [kajism@yahoo.com]

* Add support for :order option to with_scope. Closes #3887. [eric.daspet@survol.net]

* Prettify output of schema_dumper by making things line up. Closes #4241 [Caio  Chassot <caio@v2studio.com>]

* Make build_postgresql_databases task make databases owned by the postgres user. Closes #4790. [mlaster@metavillage.com]

* Sybase Adapter type conversion cleanup. Closes #4736. [dev@metacasa.net]

* Fix bug where calculations with long alias names return null. [Rick]

* Raise error when trying to add to a has_many :through association.  Use the Join Model instead. [Rick]

    @post.tags << @tag                  # BAD
    @post.taggings.create(:tag => @tag) # GOOD

* Allow all calculations to take the :include option, not just COUNT (closes #4840) [Rick]

* Add ActiveRecord::Errors#to_xml [Jamis Buck]

* Properly quote index names in migrations (closes #4764) [John Long]

* Fix the HasManyAssociation#count method so it uses the new ActiveRecord::Base#count syntax, while maintaining backwards compatibility.  [Rick]

* Ensure that Associations#include_eager_conditions? checks both scoped and explicit conditions [Rick]

* Associations#select_limited_ids_list adds the ORDER BY columns to the SELECT DISTINCT List for postgresql. [Rick]

* Add :case_sensitive option to validates_uniqueness_of (closes #3090) [Rick]

    class Account < ActiveRecord::Base
      validates_uniqueness_of :email, :case_sensitive => false
    end

* Allow multiple association extensions with :extend option (closes #4666) [Josh Susser]

    class Account < ActiveRecord::Base
      has_many :people, :extend => [FindOrCreateByNameExtension, FindRecentExtension]
    end


*1.14.4* (August 8th, 2006)

* Add warning about the proper way to validate the presence of a foreign key.  #4147 [Francois Beausoleil <francois.beausoleil@gmail.com>]

* Fix syntax error in documentation. #4679 [mislav@nippur.irb.hr] 

* Update inconsistent migrations documentation. #4683 [machomagna@gmail.com]


*1.14.3* (June 27th, 2006)

* Fix announcement of very long migration names.  #5722 [blake@near-time.com]

* Update callbacks documentation. #3970 [Robby Russell <robby@planetargon.com>]

* Properly quote index names in migrations (closes #4764) [John Long]

* Ensure that Associations#include_eager_conditions? checks both scoped and explicit conditions [Rick]

* Associations#select_limited_ids_list adds the ORDER BY columns to the SELECT DISTINCT List for postgresql. [Rick]


*1.14.2* (April 9th, 2006)

* Fixed calculations for the Oracle Adapter (closes #4626) [Michael Schoen]


*1.14.1* (April 6th, 2006)

* Fix type_name_with_module to handle type names that begin with '::'. Closes #4614. [Nicholas Seckar]

* Fixed that that multiparameter assignment doesn't work with aggregations (closes #4620) [Lars Pind]

* Enable Limit/Offset in Calculations (closes #4558) [lmarlow@yahoo.com]

* Fixed that loading including associations returns all results if Load IDs For Limited Eager Loading returns none (closes #4528) [Rick]

* Fixed HasManyAssociation#find bugs when :finder_sql is set #4600 [lagroue@free.fr]

* Allow AR::Base#respond_to? to behave when @attributes is nil [zenspider]

* Support eager includes when going through a polymorphic has_many association. [Rick]

* Added support for eagerly including polymorphic has_one associations. (closes #4525) [Rick]

    class Post < ActiveRecord::Base
      has_one :tagging, :as => :taggable
    end
    
    Post.find :all, :include => :tagging

* Added descriptive error messages for invalid has_many :through associations: going through :has_one or :has_and_belongs_to_many [Rick]

* Added support for going through a polymorphic has_many association: (closes #4401) [Rick]

    class PhotoCollection < ActiveRecord::Base
      has_many :photos, :as => :photographic
      belongs_to :firm
    end
     
    class Firm < ActiveRecord::Base
      has_many :photo_collections
      has_many :photos, :through => :photo_collections
    end

* Multiple fixes and optimizations in PostgreSQL adapter, allowing ruby-postgres gem to work properly. [ruben.nine@gmail.com]

* Fixed that AssociationCollection#delete_all should work even if the records of the association are not loaded yet. [Florian Weber]

* Changed those private ActiveRecord methods to take optional third argument :auto instead of nil for performance optimizations.  (closes #4456) [Stefan]

* Private ActiveRecord methods add_limit!, add_joins!, and add_conditions! take an OPTIONAL third argument 'scope' (closes #4456) [Rick]

* DEPRECATED: Using additional attributes on has_and_belongs_to_many associations. Instead upgrade your association to be a real join model [DHH]

* Fixed that records returned from has_and_belongs_to_many associations with additional attributes should be marked as read only (fixes #4512) [DHH]

* Do not implicitly mark recordss of has_many :through as readonly but do mark habtm records as readonly (eventually only on join tables without rich attributes). [Marcel Mollina Jr.]

* Fixed broken OCIAdapter #4457 [schoenm@earthlink.net]


*1.14.0* (March 27th, 2006)

* Replace 'rescue Object' with a finer grained rescue. Closes #4431. [Nicholas Seckar]

* Fixed eager loading so that an aliased table cannot clash with a has_and_belongs_to_many join table [Rick]

* Add support for :include to with_scope [andrew@redlinesoftware.com]

* Support the use of public synonyms with the Oracle adapter; required ruby-oci8 v0.1.14 #4390 [schoenm@earthlink.net]

* Change periods (.) in table aliases to _'s.  Closes #4251 [jeff@ministrycentered.com]

* Changed has_and_belongs_to_many join to INNER JOIN for Mysql 3.23.x.  Closes #4348 [Rick]

* Fixed issue that kept :select options from being scoped [Rick]

* Fixed db_schema_import when binary types are present #3101 [DHH]

* Fixed that MySQL enums should always be returned as strings #3501 [DHH]

* Change has_many :through to use the :source option to specify the source association.  :class_name is now ignored. [Rick Olson]

    class Connection < ActiveRecord::Base
      belongs_to :user
      belongs_to :channel
    end

    class Channel < ActiveRecord::Base
      has_many :connections
      has_many :contacts, :through => :connections, :class_name => 'User' # OLD
      has_many :contacts, :through => :connections, :source => :user      # NEW
    end

* Fixed DB2 adapter so nullable columns will be determines correctly now and quotes from column default values will be removed #4350 [contact@maik-schmidt.de]

* Allow overriding of find parameters in scoped has_many :through calls [Rick Olson]

  In this example, :include => false disables the default eager association from loading.  :select changes the standard
  select clause.  :joins specifies a join that is added to the end of the has_many :through query.
  
    class Post < ActiveRecord::Base
      has_many :tags, :through => :taggings, :include => :tagging do
        def add_joins_and_select
          find :all, :select => 'tags.*, authors.id as author_id', :include => false,
            :joins => 'left outer join posts on taggings.taggable_id = posts.id left outer join authors on posts.author_id = authors.id'
        end
      end
    end
    
* Fixed that schema changes while the database was open would break any connections to a SQLite database (now we reconnect if that error is throw) [DHH]

* Don't classify the has_one class when eager loading, it is already singular. Add tests. (closes #4117) [jonathan@bluewire.net.nz]

* Quit ignoring default :include options in has_many :through calls [Mark James]

* Allow has_many :through associations to find the source association by setting a custom class (closes #4307) [jonathan@bluewire.net.nz]

* Eager Loading support added for has_many :through => :has_many associations (see below).  [Rick Olson]

* Allow has_many :through to work on has_many associations (closes #3864) [sco@scottraymond.net]  Example:

    class Firm < ActiveRecord::Base
      has_many :clients
      has_many :invoices, :through => :clients
    end
  
    class Client < ActiveRecord::Base
      belongs_to :firm
      has_many   :invoices
    end
  
    class Invoice < ActiveRecord::Base
      belongs_to :client
    end

* Raise error when trying to select many polymorphic objects with has_many :through or :include (closes #4226) [josh@hasmanythrough.com]

* Fixed has_many :through to include :conditions set on the :through association. closes #4020 [jonathan@bluewire.net.nz]

* Fix that has_many :through honors the foreign key set by the belongs_to association in the join model (closes #4259) [andylien@gmail.com / Rick]

* SQL Server adapter gets some love #4298 [rtomayko@gmail.com]

* Added OpenBase database adapter that builds on top of the http://www.spice-of-life.net/ruby-openbase/ driver. All functionality except LIMIT/OFFSET is supported #3528 [derrickspell@cdmplus.com]

* Rework table aliasing to account for truncated table aliases.  Add smarter table aliasing when doing eager loading of STI associations. This allows you to use the association name in the order/where clause. [Jonathan Viney / Rick Olson] #4108 Example (SpecialComment is using STI):

    Author.find(:all, :include => { :posts => :special_comments }, :order => 'special_comments.body')

* Add AbstractAdapter#table_alias_for to create table aliases according to the rules of the current adapter. [Rick]

* Provide access to the underlying database connection through Adapter#raw_connection. Enables the use of db-specific methods without complicating the adapters. #2090 [Koz]

* Remove broken attempts at handling columns with a default of 'now()' in the postgresql adapter. #2257 [Koz]

* Added connection#current_database that'll return of the current database (only works in MySQL, SQL Server, and Oracle so far -- please help implement for the rest of the adapters) #3663 [Tom ward]

* Fixed that Migration#execute would have the table name prefix appended to its query #4110 [mark.imbriaco@pobox.com]

* Make all tinyint(1) variants act like boolean in mysql (tinyint(1) unsigned, etc.) [Jamis Buck]

* Use association's :conditions when eager loading. [jeremyevans0@gmail.com] #4144

* Alias the has_and_belongs_to_many join table on eager includes. #4106 [jeremyevans0@gmail.com]

  This statement would normally error because the projects_developers table is joined twice, and therefore joined_on would be ambiguous.

    Developer.find(:all, :include => {:projects => :developers}, :conditions => 'join_project_developers.joined_on IS NOT NULL')

* Oracle adapter gets some love #4230 [schoenm@earthlink.net]

    * Changes :text to CLOB rather than BLOB [Moses Hohman]
    * Fixes an issue with nil numeric length/scales (several)
    * Implements support for XMLTYPE columns [wilig / Kubo Takehiro]
    * Tweaks a unit test to get it all green again
    * Adds support for #current_database

* Added Base.abstract_class? that marks which classes are not part of the Active Record hierarchy #3704 [Rick Olson]

    class CachedModel < ActiveRecord::Base
      self.abstract_class = true
    end
    
    class Post < CachedModel
    end
    
    CachedModel.abstract_class?
    => true
    
    Post.abstract_class?
    => false

    Post.base_class
    => Post
    
    Post.table_name
    => 'posts'

* Allow :dependent options to be used with polymorphic joins. #3820 [Rick Olson]

    class Foo < ActiveRecord::Base
      has_many :attachments, :as => :attachable, :dependent => :delete_all
    end

* Nicer error message on has_many :through when :through reflection can not be found. #4042 [court3nay@gmail.com]

* Upgrade to Transaction::Simple 1.3 [Jamis Buck]

* Catch FixtureClassNotFound when using instantiated fixtures on a fixture that has no ActiveRecord model [Rick Olson]

* Allow ordering of calculated results and/or grouped fields in calculations [solo@gatelys.com]

* Make ActiveRecord::Base#save! return true instead of nil on success.  #4173 [johan@johansorensen.com]

* Dynamically set allow_concurrency.  #4044 [Stefan Kaes]

* Added Base#to_xml that'll turn the current record into a XML representation [DHH]. Example:

    topic.to_xml
  
  ...returns:
  
    <?xml version="1.0" encoding="UTF-8"?>
    <topic>
      <title>The First Topic</title>
      <author-name>David</author-name>
      <id type="integer">1</id>
      <approved type="boolean">false</approved>
      <replies-count type="integer">0</replies-count>
      <bonus-time type="datetime">2000-01-01 08:28:00</bonus-time>
      <written-on type="datetime">2003-07-16 09:28:00</written-on>
      <content>Have a nice day</content>
      <author-email-address>david@loudthinking.com</author-email-address>
      <parent-id></parent-id>
      <last-read type="date">2004-04-15</last-read>
    </topic>
  
  ...and you can configure with:
  
    topic.to_xml(:skip_instruct => true, :except => [ :id, bonus_time, :written_on, replies_count ])
  
  ...that'll return:
  
    <topic>
      <title>The First Topic</title>
      <author-name>David</author-name>
      <approved type="boolean">false</approved>
      <content>Have a nice day</content>
      <author-email-address>david@loudthinking.com</author-email-address>
      <parent-id></parent-id>
      <last-read type="date">2004-04-15</last-read>
    </topic>
  
  You can even do load first-level associations as part of the document:
  
    firm.to_xml :include => [ :account, :clients ]
  
  ...that'll return something like:
  
    <?xml version="1.0" encoding="UTF-8"?>
    <firm>
      <id type="integer">1</id>
      <rating type="integer">1</rating>
      <name>37signals</name>
      <clients>
        <client>
          <rating type="integer">1</rating>
          <name>Summit</name>
        </client>
        <client>
          <rating type="integer">1</rating>
          <name>Microsoft</name>
        </client>
      </clients>
      <account>
        <id type="integer">1</id>
        <credit-limit type="integer">50</credit-limit>
      </account>
    </firm>  

* Allow :counter_cache to take a column name for custom counter cache columns [Jamis Buck]

* Documentation fixes for :dependent [robby@planetargon.com]

* Stop the MySQL adapter crashing when views are present. #3782 [Jonathan Viney]

* Don't classify the belongs_to class, it is already singular #4117 [keithm@infused.org]

* Allow set_fixture_class to take Classes instead of strings for a class in a module.  Raise FixtureClassNotFound if a fixture can't load.  [Rick Olson]

* Fix quoting of inheritance column for STI eager loading #4098 [Jonathan Viney <jonathan@bluewire.net.nz>]

* Added smarter table aliasing for eager associations for multiple self joins #3580 [Rick Olson]

    * The first time a table is referenced in a join, no alias is used.
    * After that, the parent class name and the reflection name are used.
    
        Tree.find(:all, :include => :children) # LEFT OUTER JOIN trees AS tree_children ...
    
    * Any additional join references get a numerical suffix like '_2', '_3', etc.

* Fixed eager loading problems with single-table inheritance #3580 [Rick Olson]. Post.find(:all, :include => :special_comments) now returns all posts, and any special comments that the posts may have. And made STI work with has_many :through and polymorphic belongs_to.

* Added cascading eager loading that allows for queries like Author.find(:all, :include=> { :posts=> :comments }), which will fetch all authors, their posts, and the comments belonging to those posts in a single query (using LEFT OUTER JOIN) #3913 [anna@wota.jp]. Examples:

    # cascaded in two levels
    >> Author.find(:all, :include=>{:posts=>:comments})
    => authors
         +- posts
              +- comments
    
    # cascaded in two levels and normal association
    >> Author.find(:all, :include=>[{:posts=>:comments}, :categorizations])
    => authors
         +- posts
              +- comments
         +- categorizations
    
    # cascaded in two levels with two has_many associations
    >> Author.find(:all, :include=>{:posts=>[:comments, :categorizations]})
    => authors
         +- posts
              +- comments
              +- categorizations
    
    # cascaded in three levels
    >> Company.find(:all, :include=>{:groups=>{:members=>{:favorites}}})
    => companies
         +- groups
              +- members
                   +- favorites
    
* Make counter cache work when replacing an association #3245 [eugenol@gmail.com]

* Make migrations verbose [Jamis Buck]

* Make counter_cache work with polymorphic belongs_to [Jamis Buck]

* Fixed that calling HasOneProxy#build_model repeatedly would cause saving to happen #4058 [anna@wota.jp]

* Added Sybase database adapter that relies on the Sybase Open Client bindings (see http://raa.ruby-lang.org/project/sybase-ctlib) #3765 [John Sheets]. It's almost completely Active Record compliant (including migrations), but has the following caveats:

    * Does not support DATE SQL column types; use DATETIME instead.
    * Date columns on HABTM join tables are returned as String, not Time.
    * Insertions are potentially broken for :polymorphic join tables
    * BLOB column access not yet fully supported

* Clear stale, cached connections left behind by defunct threads. [Jeremy Kemper]

* CHANGED DEFAULT: set ActiveRecord::Base.allow_concurrency to false.  Most AR usage is in single-threaded applications. [Jeremy Kemper]

* Renamed the "oci" adapter to "oracle", but kept the old name as an alias #4017 [schoenm@earthlink.net]

* Fixed that Base.save should always return false if the save didn't succeed, including if it has halted by before_save's #1861, #2477 [DHH]

* Speed up class -> connection caching and stale connection verification.  #3979 [Stefan Kaes]

* Add set_fixture_class to allow the use of table name accessors with models which use set_table_name. [Kevin Clark]

* Added that fixtures to placed in subdirectories of the main fixture files are also loaded #3937 [dblack@wobblini.net]

* Define attribute query methods to avoid method_missing calls. #3677 [jonathan@bluewire.net.nz]

* ActiveRecord::Base.remove_connection explicitly closes database connections and doesn't corrupt the connection cache. Introducing the disconnect! instance method for the PostgreSQL, MySQL, and SQL Server adapters; implementations for the others are welcome.  #3591 [Simon Stapleton, Tom Ward]

* Added support for nested scopes #3407 [anna@wota.jp]. Examples:

    Developer.with_scope(:find => { :conditions => "salary > 10000", :limit => 10 }) do
      Developer.find(:all)     # => SELECT * FROM developers WHERE (salary > 10000) LIMIT 10

      # inner rule is used. (all previous parameters are ignored)
      Developer.with_exclusive_scope(:find => { :conditions => "name = 'Jamis'" }) do
        Developer.find(:all)   # => SELECT * FROM developers WHERE (name = 'Jamis')
      end

      # parameters are merged
      Developer.with_scope(:find => { :conditions => "name = 'Jamis'" }) do
        Developer.find(:all)   # => SELECT * FROM developers WHERE (( salary > 10000 ) AND ( name = 'Jamis' )) LIMIT 10
      end
    end

* Fixed db2 connection with empty user_name and auth options #3622 [phurley@gmail.com]

* Fixed validates_length_of to work on UTF-8 strings by using characters instead of bytes #3699 [Masao Mutoh]

* Fixed that reflections would bleed across class boundaries in single-table inheritance setups #3796 [lars@pind.com]

* Added calculations: Base.count, Base.average, Base.sum, Base.minimum, Base.maxmium, and the generic Base.calculate. All can be used with :group and :having. Calculations and statitics need no longer require custom SQL. #3958 [Rick Olson]. Examples:

    Person.average :age
    Person.minimum :age
    Person.maximum :age
    Person.sum :salary, :group => :last_name

* Renamed Errors#count to Errors#size but kept an alias for the old name (and included an alias for length too) #3920 [contact@lukeredpath.co.uk]

* Reflections don't attempt to resolve module nesting of association classes. Simplify type computation. [Jeremy Kemper]

* Improved the Oracle OCI Adapter with better performance for column reflection (from #3210), fixes to migrations (from #3476 and #3742), tweaks to unit tests (from #3610), and improved documentation (from #2446) #3879 [Aggregated by schoenm@earthlink.net]

* Fixed that the schema_info table used by ActiveRecord::Schema.define should respect table pre- and suffixes #3834 [rubyonrails@atyp.de]

* Added :select option to Base.count that'll allow you to select something else than * to be counted on. Especially important for count queries using DISTINCT #3839 [skaes]

* Correct syntax error in mysql DDL,  and make AAACreateTablesTest run first [Bob Silva]

* Allow :include to be used with has_many :through associations #3611 [Michael Schoen]

* PostgreSQL: smarter schema dumps using pk_and_sequence_for(table).  #2920 [Blair Zajac]

* SQLServer: more compatible limit/offset emulation.  #3779 [Tom Ward]

* Polymorphic join support for has_one associations (has_one :foo, :as => :bar)  #3785 [Rick Olson]

* PostgreSQL: correctly parse negative integer column defaults.  #3776 [bellis@deepthought.org]

* Fix problems with count when used with :include [Jeremy Hopple and Kevin Clark]

* ActiveRecord::RecordInvalid now states which validations failed in its default error message [Tobias Luetke]

* Using AssociationCollection#build with arrays of hashes should call build, not create [DHH]

* Remove definition of reloadable? from ActiveRecord::Base to make way for new Reloadable code. [Nicholas Seckar]

* Fixed schema handling for DB2 adapter that didn't work: an initial schema could be set, but it wasn't used when getting tables and indexes #3678 [Maik Schmidt]

* Support the :column option for remove_index with the PostgreSQL adapter. #3661 [shugo@ruby-lang.org]

* Add documentation for add_index and remove_index. #3600 [Manfred Stienstra <m.stienstra@fngtps.com>]

* If the OCI library is not available, raise an exception indicating as much. #3593 [schoenm@earthlink.net]

* Add explicit :order in finder tests as postgresql orders results differently by default. #3577. [Rick Olson]

* Make dynamic finders honor additional passed in :conditions. #3569 [Oleg Pudeyev <pudeyo@rpi.edu>, Marcel Molina Jr.]

* Show a meaningful error when the DB2 adapter cannot be loaded due to missing dependencies. [Nicholas Seckar]

* Make .count work for has_many associations with multi line finder sql [schoenm@earthlink.net]

* Add AR::Base.base_class for querying the ancestor AR::Base subclass [Jamis Buck]

* Allow configuration of the column used for optimistic locking [wilsonb@gmail.com]

* Don't hardcode 'id' in acts as list.  [ror@philippeapril.com]

* Fix date errors for SQLServer in association tests. #3406 [kevin.clark@gmal.com]

* Escape database name in MySQL adapter when creating and dropping databases. #3409 [anna@wota.jp]

* Disambiguate table names for columns in validates_uniquness_of's WHERE clause. #3423 [alex.borovsky@gmail.com]

* .with_scope imposed create parameters now bypass attr_protected [Tobias Luetke]

* Don't raise an exception when there are more keys than there are named bind variables when sanitizing conditions. [Marcel Molina Jr.]

* Multiple enhancements and adjustments to DB2 adaptor. #3377 [contact@maik-schmidt.de]

* Sanitize scoped conditions. [Marcel Molina Jr.]

* Added option to Base.reflection_of_all_associations to specify a specific association to scope the call. For example Base.reflection_of_all_associations(:has_many) [DHH]

* Added ActiveRecord::SchemaDumper.ignore_tables which tells SchemaDumper which tables to ignore. Useful for tables with funky column like the ones required for tsearch2. [TobiasLuetke]

* SchemaDumper now doesn't fail anymore when there are unknown column types in the schema. Instead the table is ignored and a Comment is left in the schema.rb. [TobiasLuetke]

* Fixed that saving a model with multiple habtm associations would only save the first one.  #3244 [yanowitz-rubyonrails@quantumfoam.org, Florian Weber]

* Fix change_column to work with PostgreSQL 7.x and 8.x.  #3141 [wejn@box.cz, Rick Olson, Scott Barron] 

* removed :piggyback in favor of just allowing :select on :through associations. [Tobias Luetke] 

* made method missing delegation to class methods on relation target work on :through associations. [Tobias Luetke] 

* made .find() work on :through relations. [Tobias Luetke] 

* Fix typo in association docs. #3296. [Blair Zajac]

* Fixed :through relations when using STI inherited classes would use the inherited class's name as foreign key on the join model [Tobias Luetke] 

*1.13.2* (December 13th, 2005)

* Become part of Rails 1.0

* MySQL: allow encoding option for mysql.rb driver.  [Jeremy Kemper]

* Added option inheritance for find calls on has_and_belongs_to_many and has_many assosociations [DHH]. Example:

    class Post
      has_many :recent_comments, :class_name => "Comment", :limit => 10, :include => :author
    end
    
    post.recent_comments.find(:all) # Uses LIMIT 10 and includes authors
    post.recent_comments.find(:all, :limit => nil) # Uses no limit but include authors
    post.recent_comments.find(:all, :limit => nil, :include => nil) # Uses no limit and doesn't include authors

* Added option to specify :group, :limit, :offset, and :select options from find on has_and_belongs_to_many and has_many assosociations [DHH]

* MySQL: fixes for the bundled mysql.rb driver.  #3160 [Justin Forder]

* SQLServer: fix obscure optimistic locking bug.  #3068 [kajism@yahoo.com]

* SQLServer: support uniqueidentifier columns.  #2930 [keithm@infused.org]

* SQLServer: cope with tables names qualified by owner.  #3067 [jeff@ministrycentered.com]

* SQLServer: cope with columns with "desc" in the name.  #1950 [Ron Lusk, Ryan Tomayko]

* SQLServer: cope with primary keys with "select" in the name.  #3057 [rdifrango@captechventures.com]

* Oracle: active? performs a select instead of a commit.  #3133 [Michael Schoen]

* MySQL: more robust test for nullified result hashes.  #3124 [Stefan Kaes]

* Reloading an instance refreshes its aggregations as well as its associations.  #3024 [François Beausolei]

* Fixed that using :include together with :conditions array in Base.find would cause NoMethodError #2887 [Paul Hammmond]

* PostgreSQL: more robust sequence name discovery.  #3087 [Rick Olson]

* Oracle: use syntax compatible with Oracle 8.  #3131 [Michael Schoen]

* MySQL: work around ruby-mysql/mysql-ruby inconsistency with mysql.stat.  Eliminate usage of mysql.ping because it doesn't guarantee reconnect.  Explicitly close and reopen the connection instead.  [Jeremy Kemper]

* Added preliminary support for polymorphic associations [DHH]

* Added preliminary support for join models [DHH]

* Allow validate_uniqueness_of to be scoped by more than just one column.  #1559. [jeremy@jthopple.com, Marcel Molina Jr.]

* Firebird: active? and reconnect! methods for handling stale connections.  #428 [Ken Kunz <kennethkunz@gmail.com>]

* Firebird: updated for FireRuby 0.4.0.  #3009 [Ken Kunz <kennethkunz@gmail.com>]

* MySQL and PostgreSQL: active? compatibility with the pure-Ruby driver.  #428 [Jeremy Kemper]

* Oracle: active? check pings the database rather than testing the last command status.  #428 [Michael Schoen]

* SQLServer: resolve column aliasing/quoting collision when using limit or offset in an eager find.  #2974 [kajism@yahoo.com]

* Reloading a model doesn't lose track of its connection.  #2996 [junk@miriamtech.com, Jeremy Kemper]

* Fixed bug where using update_attribute after pushing a record to a habtm association of the object caused duplicate rows in the join table. #2888 [colman@rominato.com, Florian Weber, Michael Schoen]

* MySQL, PostgreSQL: reconnect! also reconfigures the connection.  Otherwise, the connection 'loses' its settings if it times out and is reconnected.  #2978 [Shugo Maeda]

* has_and_belongs_to_many: use JOIN instead of LEFT JOIN.  [Jeremy Kemper]

* MySQL: introduce :encoding option to specify the character set for client, connection, and results.  Only available for MySQL 4.1 and later with the mysql-ruby driver.  Do SHOW CHARACTER SET in mysql client to see available encodings.  #2975 [Shugo Maeda]

* Add tasks to create, drop and rebuild the MySQL and PostgreSQL test  databases. [Marcel Molina Jr.]

* Correct boolean handling in generated reader methods.  #2945 [don.park@gmail.com, Stefan Kaes]

* Don't generate read methods for columns whose names are not valid ruby method names.  #2946 [Stefan Kaes]

* Document :force option to create_table.  #2921 [Blair Zajac <blair@orcaware.com>]

* Don't add the same conditions twice in has_one finder sql.  #2916 [Jeremy Evans]

* Rename Version constant to VERSION. #2802 [Marcel Molina Jr.]

* Introducing the Firebird adapter.  Quote columns and use attribute_condition more consistently.  Setup guide: http://wiki.rubyonrails.com/rails/pages/Firebird+Adapter  #1874 [Ken Kunz <kennethkunz@gmail.com>]

* SQLServer: active? and reconnect! methods for handling stale connections.  #428 [kajism@yahoo.com, Tom Ward <tom@popdog.net>]

* Associations handle case-equality more consistently: item.parts.is_a?(Array) and item.parts === Array.  #1345 [MarkusQ@reality.com]

* SQLServer: insert uses given primary key value if not nil rather than SELECT @@IDENTITY.  #2866 [kajism@yahoo.com, Tom Ward <tom@popdog.net>]

* Oracle: active? and reconnect! methods for handling stale connections.  Optionally retry queries after reconnect.  #428 [Michael Schoen <schoenm@earthlink.net>]

* Correct documentation for Base.delete_all.  #1568 [Newhydra]

* Oracle: test case for column default parsing.  #2788 [Michael Schoen <schoenm@earthlink.net>]

* Update documentation for Migrations.  #2861 [Tom Werner <tom@cube6media.com>]

* When AbstractAdapter#log rescues an exception, attempt to detect and reconnect to an inactive database connection.  Connection adapter must respond to the active? and reconnect! instance methods.  Initial support for PostgreSQL, MySQL, and SQLite.  Make certain that all statements which may need reconnection are performed within a logged block: for example, this means no avoiding log(sql, name) { } if @logger.nil?  #428 [Jeremy Kemper]

* Oracle: Much faster column reflection.  #2848 [Michael Schoen <schoenm@earthlink.net>]

* Base.reset_sequence_name analogous to reset_table_name (mostly useful for testing).  Base.define_attr_method allows nil values.  [Jeremy Kemper]

* PostgreSQL: smarter sequence name defaults, stricter last_insert_id, warn on pk without sequence.  [Jeremy Kemper]

* PostgreSQL: correctly discover custom primary key sequences.  #2594 [Blair Zajac <blair@orcaware.com>, meadow.nnick@gmail.com, Jeremy Kemper]

* SQLServer: don't report limits for unsupported field types.  #2835 [Ryan Tomayko]

* Include the Enumerable module in ActiveRecord::Errors.  [Rick Bradley <rick@rickbradley.com>]

* Add :group option, correspond to GROUP BY, to the find method and to the has_many association.  #2818 [rubyonrails@atyp.de]

* Don't cast nil or empty strings to a dummy date.  #2789 [Rick Bradley <rick@rickbradley.com>]

* acts_as_list plays nicely with inheritance by remembering the class which declared it.  #2811 [rephorm@rephorm.com]