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
89
90
91
92
93
94
95
96
97
98
99
|
= New Features
* An escaped_like extension has been added, for the creation of
LIKE/ILIKE expressions with placeholders in patterns without
access to a dataset. This adds escaped_like and escaped_ilike
methods to the same Sequel expression objects that support like
and ilike. These methods take two arguments, the first being
the pattern, with ? placeholders, and the second being the
placeholder value (which can be an array for multiple
placeholders):
Sequel.extension :escaped_like
DB[:table].where{string_column.escaped_like('?%', user_input)}
# user_input is 'foo':
# SELECT * FROM table WHERE string_column LIKE 'foo%'
# user_input is '%foo':
# SELECT * FROM table WHERE string_column LIKE '\%foo%'
* Generated columns on MySQL 5.7+ and MariaDB 5.2+ are now supported
using the :generated_always_as option when creating the column.
The :generated_type option can also be used to specify the type of
generated column (virtual or stored). Examples:
DB.add_column :t, :c, Integer, generated_always_as: Sequel[:a]+'b'
# ALTER TABLE `t` ADD COLUMN `c` varchar(255)
# GENERATED ALWAYS AS (CONCAT(`a`, 'b'))
DB.add_column :t, :c, Integer, generated_always_as: Sequel[:a]+'b',
generated_type: :virtual
# ALTER TABLE `t` ADD COLUMN `c` varchar(255)
# GENERATED ALWAYS AS (CONCAT(`a`, 'b')) VIRTUAL
DB.add_column :t, :c, Integer, generated_always_as: Sequel[:a]+'b',
generated_type: :stored
# ALTER TABLE `t` ADD COLUMN `c` varchar(255)
# GENERATED ALWAYS AS (CONCAT(`a`, 'b')) STORED
* Sequel::Model.has_dataset? has been added for checking whether the
model class has an associated dataset. This will generally be true
for most model classes, but will be false for abstract model
classes (such as Sequel::Model itself).
* Sequel::VERSION_NUMBER has been added for easier future version
comparisons. The version number for 5.9.0 is 50090.
= Other Improvements
* When disconnecting connections in the threaded connection pools,
the disconnection is performed without holding the connection
pool mutex, since disconnection may block.
* The sharded threaded connection pool no longer deadlocks when
disconnecting connections if the connection_validator or
connection_expiration extension is used.
* If a thread dies and does not check a connection back into the
connection pool, Sequel now disconnects the connection when it
detects the dead thread, instead of assuming the connection is
safe to be reused.
* When using eager_graph with cascaded associations, a unique
object is now used instead of a shared object in cases where
using a shared object may cause further cascaded associated
objects to be duplicated.
* On PostgreSQL, the ESCAPE modifier to the LIKE/ILIKE operators is
no longer used, since the default ESCAPE value is the one Sequel
uses. This change was made in order to allow the LIKE/ILIKE
operators to work with the ANY function, as PostgreSQL does not
support the use of the ESCAPE modifier in such cases.
* A hash argument passed to Model.nested_attributes in the
nested_attributes plugin is now no longer modified.
* Internal data structures for eager and eager_graph datasets are now
frozen to avoid unintentional modification.
* Nondeterministic behavior in Database#foreign_key_list with the
:reverse option on PostgreSQL is now avoided by using an
unambiguous order.
* Performance has been improved slightly by avoiding unnecessary
hash allocations.
* Performance has been improved slightly by using while instead
of Kernel#loop.
* BigDecimal() is now used instead of BigDecimal.new(), as the
latter has been deprecated.
* The jdbc adapter now avoids referencing ::NativeException on JRuby
9.2+, since JRuby has deprecated it. It is still used on older
versions of JRuby, since some JRuby 1.7 code may still require it.
* Sequel now works around multiple Date/Time conversion bugs in
JRuby 9.2.0.0 for BC dates in the pg_extended_date_support
extension. These bugs have already been fixed in JRuby, and
the workarounds will be removed after the release of JRuby
9.2.1.0.
|
