This project is archived and is in readonly mode.
Postgres 8.3.6: base_test: test_quote fails due to not quoting escape characters
Reported by Joe Rafaniello | April 3rd, 2009 @ 06:23 PM | in 3.x
<"\ \001 ' \n \n ""> expected but was <" \001 ' \n \n "">.
edge rails... gem: postgres (0.7.9.2008.01.28) PostgreSQL 8.3.6 ubuntu 8.04
I have the DBs 'activerecord_unittest' and 'activerecord_unittest2' created in a UTF8 database in PostgreSQL. The 'rails' user has superuser rights to the DBs.
ActiveRecord::Base.configurations = { 'arunit' => {
:adapter => 'postgresql',
:username => 'rails',
:password => 'rails',
:database => 'activerecord_unittest',
:min_messages => 'warning',
:encoding => 'unicode',
:host => 'localhost'
}, 'arunit2' => {
:adapter => 'postgresql',
:username => 'rails',
:password => 'rails',
:database => 'activerecord_unittest2',
:min_messages => 'warning',
:encoding => 'unicode',
:host => 'localhost'
} }
I have tried setting the encoding to utf8 with the same results.
jrafaniello@jrafaniello-laptop:~/src/rails/activerecord$ rake test_postgresql TEST=./test/cases/base_test.rb 2>&1> base_test.log
See attached log file.
Comments and changes to this ticket
-
Joe Rafaniello April 3rd, 2009 @ 09:20 PM
This has been fixed in the proposed patch in ticket 2412 which addes Postgres support for standard_conforming_strings = on.
-
Joe Rafaniello January 27th, 2010 @ 04:25 PM
This ticket can be closed since 2412 will address the issue raised here.
-
Rohit Arondekar June 15th, 2010 @ 10:56 AM
- State changed from new to resolved
Ticket 2412 has been marked duplicate, while the original ticket https://rails.lighthouseapp.com/projects/8994/tickets/1837 has been resolved with commits and the message "Reopen with a failing test case if you have any issues."
Also since the original poster has said this ticket can be closed, I'll close it as resolved.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<h2 style="font-size: 14px">Tickets have moved to Github</h2>
The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>