Update ruby-sequel to 4.42.1.

=== 4.42.1 (2017-01-12)

* Make dataset_module inherited to subclasses when using the single_table_inheritance plugin (jeremyevans) (#1284)

=== 4.42.0 (2017-01-01)

* Handle eager load callbacks correctly for one_to_one associations with orders or offsets when window functions are not supported (jeremyevans)

* Raise Sequel::Error if using an :eager_limit dataset option when eager loading a singular association (jeremyevans)

* Replace internal uses of Dataset#select_more with #select_append to save a method call (jeremyevans)

* Make Dataset#order_append the primary method, and #order_more the alias, for similarity to #select_append and #select_more (jeremyevans)

* Replace internal uses of Dataset#filter with #where to save a method call (jeremyevans)

* Do not set :auto_increment in the schema information for integer columns that are part of a composite primary key on SQLite (jeremyevans)

* Use autoincrement setting on integer primary key columns when emulating table modification methods on SQLite (thenrio, jeremyevans) (#1277, #1278)

* Make the pagination extension work on frozen datasets (jeremyevans)

* Make Dataset#server work for frozen model datasets using the sharding plugin (jeremyevans)

* Make Dataset#nullify in the null_dataset extension work on frozen datasets (jeremyevans)

* Make Model#set_server work when using a frozen model dataset (jeremyevans)

* Make Dataset#ungraphed work on a frozen model dataset (jeremyevans)

* Add Dataset#with_{autoid,fetch,numrows} to the mock adapter, returning cloned datasets with the setting changed (jeremyevans)

* Make looser_typecasting extension handle the strict BigDecimal parsing introduced in ruby 2.4rc1 (jeremyevans)

* Make Database#{db,opts}= in the sequel_3_dataset_methods extension raise for frozen datasets (jeremyevans)

* Speed up repeated calls to Dataset#{interval,range} for frozen datasets using a cached placeholder literalizer (jeremyevans)

* Speed up repeated calls to Dataset#get with a single argument for frozen datasets using a cached placeholder literalizer (jeremyevans)

* Speed up repeated calls to Dataset#{first,last} with arguments/blocks for frozen datasets using a cached placeholder literalizer (jeremyevans)

* Speed up repeated calls to Dataset#{avg,min,max,sum} for frozen datasets using a cached placeholder literalizer (jeremyevans)

* Cache dataset returned by Dataset#skip_locked for frozen datasets (jeremyevans)

* Cache dataset returned by Dataset#for_update for frozen datasets (jeremyevans)

* Cache dataset returned by Dataset#un{filtered,grouped,limited,ordered} for frozen datasets (jeremyevans)

* Cache dataset returned by Dataset#reverse (no args) for frozen datasets (jeremyevans)

* Cache dataset returned by Dataset#invert for frozen datasets (jeremyevans)

* Speed up repeated calls to Dataset#count with an argument or block for frozen datasets using a cached placeholder literalizer (jeremyevans)

* Using :on_duplicate_columns=>:warn Database option with duplicate_columns_handler now prepends file/line to the warning message (jeremyevans)

* Move identifier mangling code to identifier_mangling extension, load by default unless using :identifier_mangling=>false Database option (jeremyevans)

* Allow Dataset#with_extend to accept a block and create a module with that block that the object is extended with (jeremyevans)

* Speed up repeated calls to with_pk on the same frozen model dataset using a cached placeholder literalizer (jeremyevans)

* Add dataset_module methods such as select and order that define dataset methods which support caching for frozen datasets (jeremyevans)

* Cache subset datasets if they don't use blocks or procs for frozen model datasets (jeremyevans)

* Cache intermediate dataset used in Dataset#{last,paged_each} for frozen model datasets without an order (jeremyevans)

* Cache dataset returned by Dataset#naked for frozen datasets (jeremyevans)

* Cache intermediate dataset used in Dataset#last (no args) for frozen datasets (jeremyevans)

* Cache intermediate dataset used in Dataset#first (no args) and #single_record for frozen datasets (jeremyevans)

* Cache intermediate dataset used in Dataset#empty? for frozen datasets (jeremyevans)

* Cache intermediate dataset used in Dataset#count (no args) for frozen datasets (jeremyevans)

* Warn if :conditions option may be unexpectedly ignored during eager_graph/association_join (jeremyevans) (#1272)

* Cache SELECT and DELETE SQL for most frozen datasets (jeremyevans)

* Freeze most SQL::Expression objects and internal state by default (jeremyevans)

* Freeze Dataset::PlaceholderLiteralizer and Dataset::PlaceholderLiteralizer::Argument instances (jeremyevans)

* Freeze most dataset opts values to avoid unintentional modification (jeremyevans)

* Add Dataset#with_convert_smallint_to_bool on DB2, returning a clone with convert_smallint_to_bool set (jeremyevans)

* Make Dataset#freeze actually freeze the dataset on ruby 2.4+ (jeremyevans)

* Avoid using instance variables other than @opts for dataset data storage (jeremyevans)

* Add freeze_datasets extension, making all datasets for a given Database frozen (jeremyevans)

* Refactor prepared statement internals, using opts instead of instance variables (jeremyevans)

* Model.set_dataset now operates on a clone of the dataset given instead of modifying it, so it works with frozen datasets (jeremyevans)

=== 4.41.0 (2016-12-01)

* Add Dataset#with_mssql_unicode_strings on Microsoft SQL Server, returning a clone with mssql_unicode_strings set (jeremyevans)

* Add Dataset#with_identifier_output_method, returning a clone with identifier_output_method set (jeremyevans)

* Add Dataset#with_identifier_input_method, returning a clone with identifier_input_method set (jeremyevans)

* Add Dataset#with_quote_identifiers, returning a clone with quote_identifiers set (jeremyevans)

* Add Dataset#with_extend, returning a clone extended with given modules (jeremyevans)

* Add Dataset#with_row_proc, returning a clone with row_proc set (jeremyevans)

* Support use of SQL::AliasedExpressions as Model#to_json :include option keys in the json_serializer plugin (sensadrome) (#1269)

* Major improvements to type conversion in the ado adapter (vais, jeremyevans) (#1265)

* Avoid memory leak in ado adapter by closing result sets after yielding them (vais, jeremyevans) (#1259)

* Fix hook_class_methods plugin handling of commit hooks (jeremyevans)

* Make association dataset method correctly handle cases where key fields are nil (jeremyevans)

* Handle pure java exceptions that don't support message= when reraising the exception in the jdbc adapter (jeremyevans)

* Add support for :offset_strategy Database option on DB2, with :limit_offset and :offset_fetch values, to disable OFFSET emulation (#1254) (jeremyevans)

* Remove deprecated support for using Bignum class as a generic type (jeremyevans)

3 files changed, 20 insertions, 8 deletions

diff --git a/databases/ruby-sequel/Makefile b/databases/ruby-sequel/Makefile
index a9bdfd2feb2..92acd4c63ef 100644
--- a/databases/ruby-sequel/Makefile
+++ b/databases/ruby-sequel/Makefile
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.49 2016/11/01 16:44:15 taca Exp $
+# $NetBSD: Makefile,v 1.50 2017/01/13 15:30:04 taca Exp $
 
-DISTNAME=	sequel-4.40.0
+DISTNAME=	sequel-4.42.1
 CATEGORIES=	databases
 
 MAINTAINER=	pkgsrc-users@NetBSD.org
@@ -10,5 +10,8 @@ LICENSE=	mit
 
 RUBYGEM_OPTIONS+=	--format-executable
 
+pre-build:
+	${CHMOD} 0755 ${WRKSRC}/bin/sequel
+
 .include "../../lang/ruby/gem.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/ruby-sequel/PLIST b/databases/ruby-sequel/PLIST
index 4d0568b21fe..23cd7c56aba 100644
--- a/databases/ruby-sequel/PLIST
+++ b/databases/ruby-sequel/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.46 2016/11/01 16:44:15 taca Exp $
+@comment $NetBSD: PLIST,v 1.47 2017/01/13 15:30:04 taca Exp $
 bin/sequel${RUBY_SUFFIX}
 ${GEM_HOME}/cache/${GEM_NAME}.gem
 ${GEM_LIBDIR}/CHANGELOG
@@ -130,6 +130,8 @@ ${GEM_LIBDIR}/doc/release_notes/4.38.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.39.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.4.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.40.0.txt
+${GEM_LIBDIR}/doc/release_notes/4.41.0.txt
+${GEM_LIBDIR}/doc/release_notes/4.42.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.5.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.6.0.txt
 ${GEM_LIBDIR}/doc/release_notes/4.7.0.txt
@@ -211,6 +213,7 @@ ${GEM_LIBDIR}/lib/sequel/adapters/utils/pg_types.rb
 ${GEM_LIBDIR}/lib/sequel/adapters/utils/replace.rb
 ${GEM_LIBDIR}/lib/sequel/adapters/utils/split_alter_table.rb
 ${GEM_LIBDIR}/lib/sequel/adapters/utils/stored_procedures.rb
+${GEM_LIBDIR}/lib/sequel/adapters/utils/unmodified_identifiers.rb
 ${GEM_LIBDIR}/lib/sequel/ast_transformer.rb
 ${GEM_LIBDIR}/lib/sequel/connection_pool.rb
 ${GEM_LIBDIR}/lib/sequel/connection_pool/sharded_single.rb
@@ -259,9 +262,11 @@ ${GEM_LIBDIR}/lib/sequel/extensions/empty_array_ignore_nulls.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/error_sql.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/eval_inspect.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/filter_having.rb
+${GEM_LIBDIR}/lib/sequel/extensions/freeze_datasets.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/from_block.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/graph_each.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/hash_aliases.rb
+${GEM_LIBDIR}/lib/sequel/extensions/identifier_mangling.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/inflector.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/looser_typecasting.rb
 ${GEM_LIBDIR}/lib/sequel/extensions/meta_def.rb
@@ -416,6 +421,7 @@ ${GEM_LIBDIR}/spec/adapters/sqlite_spec.rb
 ${GEM_LIBDIR}/spec/bin_spec.rb
 ${GEM_LIBDIR}/spec/core/connection_pool_spec.rb
 ${GEM_LIBDIR}/spec/core/database_spec.rb
+${GEM_LIBDIR}/spec/core/dataset_mutation_spec.rb
 ${GEM_LIBDIR}/spec/core/dataset_spec.rb
 ${GEM_LIBDIR}/spec/core/deprecated_spec.rb
 ${GEM_LIBDIR}/spec/core/expression_filters_spec.rb
@@ -469,11 +475,13 @@ ${GEM_LIBDIR}/spec/extensions/error_sql_spec.rb
 ${GEM_LIBDIR}/spec/extensions/eval_inspect_spec.rb
 ${GEM_LIBDIR}/spec/extensions/filter_having_spec.rb
 ${GEM_LIBDIR}/spec/extensions/force_encoding_spec.rb
+${GEM_LIBDIR}/spec/extensions/freeze_datasets_spec.rb
 ${GEM_LIBDIR}/spec/extensions/from_block_spec.rb
 ${GEM_LIBDIR}/spec/extensions/graph_each_spec.rb
 ${GEM_LIBDIR}/spec/extensions/hash_aliases_spec.rb
 ${GEM_LIBDIR}/spec/extensions/hook_class_methods_spec.rb
 ${GEM_LIBDIR}/spec/extensions/identifier_columns_spec.rb
+${GEM_LIBDIR}/spec/extensions/identifier_mangling_spec.rb
 ${GEM_LIBDIR}/spec/extensions/inflector_spec.rb
 ${GEM_LIBDIR}/spec/extensions/input_transformer_spec.rb
 ${GEM_LIBDIR}/spec/extensions/insert_returning_select_spec.rb
@@ -653,5 +661,6 @@ ${GEM_LIBDIR}/spec/model_no_assoc_spec.rb
 ${GEM_LIBDIR}/spec/model_spec.rb
 ${GEM_LIBDIR}/spec/plugin_spec.rb
 ${GEM_LIBDIR}/spec/sequel_coverage.rb
+${GEM_LIBDIR}/spec/sequel_warning.rb
 ${GEM_LIBDIR}/spec/spec_config.rb
 ${GEM_HOME}/specifications/${GEM_NAME}.gemspec
diff --git a/databases/ruby-sequel/distinfo b/databases/ruby-sequel/distinfo
index be34460b09f..b3fe4db41da 100644
--- a/databases/ruby-sequel/distinfo
+++ b/databases/ruby-sequel/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.47 2016/11/01 16:44:15 taca Exp $
+$NetBSD: distinfo,v 1.48 2017/01/13 15:30:04 taca Exp $
 
-SHA1 (sequel-4.40.0.gem) = a26790d1e5bd0ea92b501d6e009119c2f19ad64e
-RMD160 (sequel-4.40.0.gem) = 1bd03addbe9bb0a1da9194b477abcd7c685a92cd
-SHA512 (sequel-4.40.0.gem) = 9bb34d34355ef695edb29c336340e8024cd84f4cd5faed873dff79a535fed6bb7de61b1adf2f58d1ccb22cd94f5640bdbce7196e04816a4a413c6d0147a05b41
-Size (sequel-4.40.0.gem) = 1383936 bytes
+SHA1 (sequel-4.42.1.gem) = 2d525e943e2ed243e094a9d3d709bf3226d0a30d
+RMD160 (sequel-4.42.1.gem) = 241246523f8dd001ec3a50ce1ad97a1dc724acdc
+SHA512 (sequel-4.42.1.gem) = d15117d028fdfabc0215c78782762af979a8f266cddeb55b25bec3e7b516d4372a602e9f15baec3178fb7b314655863640f94d7793491a1d691ca91364ccf2f5
+Size (sequel-4.42.1.gem) = 1402368 bytes