From 73ff6797ef3e6fd0a3ee4b860061cf6869fe835d Mon Sep 17 00:00:00 2001 From: Aaron Patterson Date: Mon, 9 May 2011 13:53:46 -0700 Subject: use a null byte as a bind parameter substitute as it is not allowed in normal SQL. fixes #411, #417 --- .../cases/adapters/mysql2/bind_parameter_test.rb | 50 ++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 activerecord/test/cases/adapters/mysql2/bind_parameter_test.rb (limited to 'activerecord/test/cases') diff --git a/activerecord/test/cases/adapters/mysql2/bind_parameter_test.rb b/activerecord/test/cases/adapters/mysql2/bind_parameter_test.rb new file mode 100644 index 0000000000..cd9c1041dc --- /dev/null +++ b/activerecord/test/cases/adapters/mysql2/bind_parameter_test.rb @@ -0,0 +1,50 @@ +require "cases/helper" +require 'models/topic' + +module ActiveRecord + module ConnectionAdapters + class Mysql2Adapter + class BindParameterTest < ActiveRecord::TestCase + fixtures :topics + + def test_update_question_marks + str = "foo?bar" + x = Topic.find :first + x.title = str + x.content = str + x.save! + x.reload + assert_equal str, x.title + assert_equal str, x.content + end + + def test_create_question_marks + str = "foo?bar" + x = Topic.create!(:title => str, :content => str) + x.reload + assert_equal str, x.title + assert_equal str, x.content + end + + def test_update_null_bytes + str = "foo\0bar" + x = Topic.find :first + x.title = str + x.content = str + x.save! + x.reload + assert_equal str, x.title + assert_equal str, x.content + end + + def test_create_null_bytes + str = "foo\0bar" + x = Topic.create!(:title => str, :content => str) + x.reload + assert_equal str, x.title + assert_equal str, x.content + end + end + end + end +end -- cgit v1.2.3