Merge branch '5.0/use-bind-values' into 5.0-trunk

2 files changed, 11 insertions, 1 deletions

diff --git a/etc/RT_Config.pm.in b/etc/RT_Config.pm.in
index cbe6115468..b0b0c5cc65 100644
--- a/etc/RT_Config.pm.in
+++ b/etc/RT_Config.pm.in
@@ -1625,6 +1625,16 @@ Admin -> Tools menu for SuperUsers.
 
 Set($StatementLog, undef);
 
+=item SQL bind parameters
+
+RT enables SQL bind parameters for all searches by default, which improves
+performance especially for Oracle. If you need to disable this for some
+reason, add this to config:
+
+    $ENV{SB_PREFER_BIND} = 0;
+
+See also L<DBIx::SearchBuilder/BuildSelectQuery>.
+
 =back
 
 
diff --git a/etc/cpanfile b/etc/cpanfile
index a3c8324fe9..9932ccdea3 100644
--- a/etc/cpanfile
+++ b/etc/cpanfile
@@ -22,7 +22,7 @@ requires 'DateTime', '>= 0.44';
 requires 'DateTime::Format::Natural', '>= 0.67';
 requires 'DateTime::Locale', '>= 0.40, != 1.00, != 1.01';
 requires 'DBI', '>= 1.37';
-requires 'DBIx::SearchBuilder', '>= 1.68';
+requires 'DBIx::SearchBuilder', '>= 1.71';
 requires 'Devel::GlobalDestruction';
 requires 'Devel::StackTrace', '>= 1.19, != 1.28, != 1.29';
 requires 'Digest::base';