Sha256: 8d049a79f6a006e7cd0522b453c534ec23eddfc00815943562574aa44e330340

Contents?: true

Size: 1.96 KB

Versions: 21

Compression:

Stored size: 1.96 KB

Contents

= New Features

* A :graph_use_association_block association option has been added,
  which makes eager_graph use the association block (as eager does),
  generally resulting in a JOIN to a subquery:

    Artist.one_to_many :tracks, graph_use_association_block: true do |ds|
      ds.where(foo: 3)
    end
    Artist.eager_graph(:tracks)
    # SELECT albums.id, tracks.id AS tracks_id, tracks.album_id
    # FROM albums
    # LEFT OUTER JOIN (SELECT * FROM tracks WHERE (foo = 3)) AS tracks
    # ON (tracks.album_id = albums.id)

  Assuming that the database can optimize the query correctly, using
  the :graph_use_association_block option is probably simpler than
  than using other :graph_* options to duplicate the conditions added
  by the association block.

* Numeric/Decimal column schema entries now include :min_value and
  :max_value entries on most databases, indicating the minimum and
  maximum values supported for the column. Similar to the support
  for integer columns added in 5.62.0, this allows the
  auto_validations plugin to automatically validate the values of
  the columns are in the allowed range.

= Other Improvements

* many_through_{one,many} associations now support eager_graph
  callbacks.

* The :db_type column schema entries on SQLAnywhere now include
  precision/scale information, to work with the numeric/decimal
  column min_value/max_value support.

* The oracle adapter now includes a :column_size column schema
  entry containing the precision of the columns, to work with the
  numeric/decimal column min_value/max_value support.

= Backwards Compatibility

* The private Database#column_schema_integer_min_max_values method
  added in 5.62.0 now takes a column schema hash instead of a
  database type string.

* Code that previously looked at the :db_type column schema entry on
  SQLAnywhere should be updated to look at the :domain_name entry, and
  code that looked at the :domain_name_with_size entry should be
  updated to look at the :db_type entry.

Version data entries

21 entries across 21 versions & 1 rubygems

Version Path
sequel-5.83.1 doc/release_notes/5.64.0.txt
sequel-5.83.0 doc/release_notes/5.64.0.txt
sequel-5.82.0 doc/release_notes/5.64.0.txt
sequel-5.81.0 doc/release_notes/5.64.0.txt
sequel-5.80.0 doc/release_notes/5.64.0.txt
sequel-5.79.0 doc/release_notes/5.64.0.txt
sequel-5.78.0 doc/release_notes/5.64.0.txt
sequel-5.77.0 doc/release_notes/5.64.0.txt
sequel-5.76.0 doc/release_notes/5.64.0.txt
sequel-5.75.0 doc/release_notes/5.64.0.txt
sequel-5.74.0 doc/release_notes/5.64.0.txt
sequel-5.73.0 doc/release_notes/5.64.0.txt
sequel-5.72.0 doc/release_notes/5.64.0.txt
sequel-5.71.0 doc/release_notes/5.64.0.txt
sequel-5.70.0 doc/release_notes/5.64.0.txt
sequel-5.69.0 doc/release_notes/5.64.0.txt
sequel-5.68.0 doc/release_notes/5.64.0.txt
sequel-5.67.0 doc/release_notes/5.64.0.txt
sequel-5.66.0 doc/release_notes/5.64.0.txt
sequel-5.65.0 doc/release_notes/5.64.0.txt