You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
Build Identifier:
When trying to run a SQL query from Ruby to MonetDB using the ruby-monetdb-sql gem, the query fails at an early point, when trying to set the timezone offset, if the timezone offset is negative (in USA, etc.).
Reproducible: Always
Steps to Reproduce:
gem 'ruby-monetdb-sql' in Gemfile
require 'MonetDB' in ruby code
db = MonetDB.new
db.conn(...connnection parameters...)
res = db.query("select * from tbl")
Actual Results:
Error message with traceback to MonetDBConnection.rb line 403, in set_timezone().
I didn't save the actual error message, since I have a working code fix for it, below.
Expected Results:
res filled with query results.
Code change which fixes this bug:
Code was (clients/ruby/lib/MonetDBConnection.rb line 402):
Fix setting time zone for negative offsets.
Port of changesets [5247c923260e](https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5247c923260e) and [084abef09d5d](https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=084abef09d5d) from MonetDB.
This fixes bug #3985.
Date: 2016-04-20 01:49:18 +0200
From: Clint Cummins <>
To: clients devs <>
Version: 11.21.19 (Jul2015-SP4)
Last updated: 2016-06-23 10:24:27 +0200
Comment 22064
Date: 2016-04-20 01:49:18 +0200
From: Clint Cummins <>
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
Build Identifier:
When trying to run a SQL query from Ruby to MonetDB using the ruby-monetdb-sql gem, the query fails at an early point, when trying to set the timezone offset, if the timezone offset is negative (in USA, etc.).
Reproducible: Always
Steps to Reproduce:
Actual Results:
Error message with traceback to MonetDBConnection.rb line 403, in set_timezone().
I didn't save the actual error message, since I have a working code fix for it, below.
Expected Results:
res filled with query results.
Code change which fixes this bug:
Code was (clients/ruby/lib/MonetDBConnection.rb line 402):
Change to:
After this, ruby runs great with MonetDB in the USA!
Comment 22065
Date: 2016-04-20 10:12:05 +0200
From: MonetDB Mercurial Repository <>
Changeset 5247c923260e made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=5247c923260e
Changeset description:
Comment 22066
Date: 2016-04-20 10:16:33 +0200
From: MonetDB Mercurial Repository <>
Changeset b4cf00b05ef1, made by Sjoerd Mullender sjoerd@acm.org in the monetdb-ruby repo, refers to this bug.
For complete details, see http://dev.monetdb.org/hg/monetdb-ruby?cmd=changeset;node=b4cf00b05ef1
Changeset description:
Comment 22068
Date: 2016-04-20 10:23:52 +0200
From: @sjoerdmullender
Thanks for the fix. It'll be in the next release.
The text was updated successfully, but these errors were encountered: