Sha256: 077626d8d4068ef73c4596f47ac3d0abb73301553a9e412fdf1ca0c6e4f1f571
Contents?: true
Size: 1.68 KB
Versions: 39
Compression:
Stored size: 1.68 KB
Contents
= New Features
* On PostgreSQL 14+, Dataset#with_recursive now supports :search and
:cycle options for result ordering and cycle detection. These use
the SEARCH and CYCLE clauses added in PostgreSQL 14:
DB[:t].with_recursive(:t,
DB[:i1].where(parent_id: nil),
DB[:i1].join(:t, id: :parent_id).select_all(:i1),
search: {by: :id, type: :breadth},
cycle: {columns: :id, cycle_value: 1, noncycle_value: 2})
# WITH RECURSIVE t AS (
# SELECT * FROM i1 WHERE (parent_id IS NULL)
# UNION ALL
# (SELECT i1.* FROM i1 INNER JOIN t ON (t.id = i1.parent_id))
# )
# SEARCH BREADTH FIRST BY id SET ordercol
# CYCLE id SET is_cycle TO 1 DEFAULT 2 USING path
* On MySQL, column schema hashes now contain an :extra entry, which
contains the Extra string returned in MySQL's DESCRIBE results
for the column.
= Other Improvements
* When eager loading via the tactical_eager_loading plugin, objects
that already have an association loaded will not have it reloaded
unless the :eager_reload option is given.
* When cloning an association and using a different :class option
than the cloned association, the :class option given when cloning
will now take precedence over the :class option for the cloned
association.
* When using the mock postgres adapter, the adapter defaults to
supporting PostgreSQL 14 (previously, it defaulted to supporting
PostgreSQL 9.5).
* Sequel now avoids a method redefined warning in the lazy attributes
plugin in verbose warnings mode.
= Other
* Sequel's primary discussion forum is now GitHub Discussions. The
sequel-talk Google Group is still available for users who would
prefer to use that instead.
Version data entries
39 entries across 39 versions & 2 rubygems