/usr/share/doc/ruby-sequel/doc/release_notes/3.25.0.txt is in ruby-sequel 3.33.0-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 | = New Features
* drop_table, drop_view, drop_column, and drop_constraint all now
support a :cascade option for using CASCADE.
DB.drop_table(:tab, :cascade=>true)
# DROP TABLE tab CASCADE
DB.drop_column(:tab, :col, :cascade=>true)
# ALTER TABLE tab DROP COLUMN col CASCADE
A few databases support CASCADE for dropping tables and views,
but only PostgreSQL appears to support it for columns and
constraints. Using the :cascade option when the underlying
database doesn't support it will probably result in a
DatabaseError being raised.
* You can now use datasets as expressions, allowing things such as:
DB[:table1].select(:column1) > DB[:table2].select(:column2)
# (SELECT column1 FROM table1) > (SELECT column2 FROM table2)
DB[:table1].select(:column1).cast(Integer)
# CAST((SELECT column1 FROM table1) AS integer)
* Dataset#select_group has been added for grouping and selecting on
the same columns.
DB[:a].select_group(:b, :c)
# SELECT b, c FROM a GROUP BY b, c
* Dataset#exclude_where and #exclude_having methods have been added,
allowing you to specify which clause to affect. #exclude's
behavior is still to add to the HAVING clause if one is present,
and use the WHERE clause otherwise.
* Dataset#select_all now accepts optional arguments and will select
all columns from those arguments if present:
DB[:a].select_all(:a)
# SELECT a.* FROM a
DB.from(:a, :b).select_all(:a, :b)
# SELECT a.*, b.* FROM a, b
* Dataset#group and #group_and_count now both accept virtual row
blocks:
DB[:a].select(:b).group{c(d)}
# SELECT b FROM a GROUP BY c(d)
* If you use a LiteralString as a validation error message,
Errors#full_messages will now not add the related column name to
the start of the error message.
* Model.set_dataset now accepts SQL::Identifier,
SQL::QualifiedIdentifier, and SQL::AliasedExpression instances,
treating them like Symbols.
= Other Improvements
* The association_pks plugin's setter method will now automatically
convert a given array of strings to an array of integers if the
primary key field is an integer field, which should make it easier
to use in web applications.
* nil bound variable, prepared statement, and stored procedure
arguments are now handled correctly in the JDBC adapter.
* On 1.9, you can now load plugins even when ::ClassMethods,
::InstanceMethods, or ::DatasetMethods is defined.
= Backwards Compatibility
* The tinytds adapter now only works with tiny_tds 0.4.5 and greater.
Also, if you were using the tinytds adapter with FreeTDS 0.91rc1,
you need to upgrade to FreeTDS 0.91rc2 for it to work. Also, if
you were referencing an entry in the freetds.conf file, you now
need to specify it directly using the :dataserver option when
connecting, the adapter no longer copies the :host option to the
:dataserver option.
* On postgresql, Sequel now no longer drops tables with CASCADE by
default. You now have to use the :cascade option to drop_table if
you want to use CASCADE.
* The Database#drop_table_sql private method now takes an additional
options hash argument.
|