Allow bignum values to be bound (thanks Timothy Wood, closes #3463)

2 files changed, 13 insertions, 0 deletions

diff --git a/lib/sqlite3/statement.rb b/lib/sqlite3/statement.rb
index 0de27f1..20de9ee 100644
--- a/lib/sqlite3/statement.rb
+++ b/lib/sqlite3/statement.rb
@@ -117,6 +117,8 @@ module SQLite3
       must_be_open!
       if Fixnum === param
         case value
+          when Bignum then
+            @driver.bind_int64( @handle, param, value )
           when Integer then
             @driver.bind_int( @handle, param, value )
           when Numeric then
diff --git a/test/tc_integration.rb b/test/tc_integration.rb
index e197006..8bb4c4a 100644
--- a/test/tc_integration.rb
+++ b/test/tc_integration.rb
@@ -743,6 +743,17 @@ module Integration
         assert_equal 1, @stmt.execute!.length
       end
 
+      define_method( "test_bind_param_with_various_types" ) do
+        @db.transaction do
+          @db.execute "create table all_types ( a integer primary key, b float, c string, d integer )"
+          @db.execute "insert into all_types ( b, c, d ) values ( 1.4, 'hello', 68719476735 )"
+        end
+
+        assert_equal 1, @db.execute( "select * from all_types where b = ?", 1.4 ).length
+        assert_equal 1, @db.execute( "select * from all_types where c = ?", 'hello').length
+        assert_equal 1, @db.execute( "select * from all_types where d = ?", 68719476735).length
+      end
+
       define_method( "test_execute_no_bind_no_block" ) do
         assert_instance_of SQLite3::ResultSet, @stmt.execute
       end