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

1 files changed, 11 insertions, 0 deletions

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