We had a fairly insane bug using PG v9.3.2 PG v0.17.1, and Ruby v2.2.0 that was alleviated by upgrading to v0.18.1, and I thought I should bring it up here.
Somewhere after ActiveRecord hands off SQL statement to the
PG::Connection, seemingly random bits are being added to the end of an email string.
Here are some examples:
email@example.com\u007f firstname.lastname@example.org\u007f email@example.comU\u007f firstname.lastname@example.org\u007f email@example.com#m$\u007f
(Note the wonky delete character!)
Occasionally completely garbage bits get added causing a
I thoroughly debugged the values of the email, and everything seems clean even before ActiveRecord's call to
#async_exec, but retrieving the record back from the database (if the
PG::CharacterNotInRepertoire had not occurred, of course) reveals those mystery bits.