From a5730ff50de9392e880df698cf9c73af0a0fce9b Mon Sep 17 00:00:00 2001 From: Jamis Buck Date: Sat, 13 Jan 2007 19:46:24 +0000 Subject: Allow bignum values to be bound (thanks Timothy Wood, closes #3463) --- test/tc_integration.rb | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'test') 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 -- cgit