List:MySQL++« Previous MessageNext Message »
From:Kemet Date:July 14 2011 6:20am
Subject:Re: update fails... any suggestions?
View as plain text  
Hi Jay,


I stumbled on the same problem when using BINARY columns in SQL.
And we found it is a small bug in the code (it was only quoting the blob, 
not escaping it).
See "SOLVED: SSQLS with BINARY column is only escaped when defined as "NOT 
NULL"" in the mailing list of May 2011.

You only need a small patch in the current 3.1.0 code and recompile it:

Quote from Warren:

So you're saying the fix is this:

Index: lib/type_info.cpp
===================================================================
--- lib/type_info.cpp   (revision 2689)
+++ lib/type_info.cpp   (working copy)
@@ -252,7 +252,7 @@

  bool mysql_type_info::escape_q() const
  {
-       const type_info& ti = c_type();
+       const type_info& ti = base_type().c_type();
         return ti == typeid(string) ||
                         ti == typeid(sql_enum) ||
                         ti == typeid(sql_blob) ||

End Quote.

So basically change the line "const type_info& ti = ...."

Once you have this in place, everything works great !

----- Original Message ----- 
From: "Jay Sprenkle" <jsprenkle@stripped>
To: <plusplus@stripped>
Sent: Wednesday, July 13, 2011 11:40 PM
Subject: Re: update fails... any suggestions?


> My catch blocks weren't correct.
>
> It looks like an escaping error on the blob.
>
> Thanks for the help.
>

Thread
update fails... any suggestions?Jay Sprenkle13 Jul
  • Re: update fails... any suggestions?Warren Young13 Jul
    • Re: update fails... any suggestions?Jay Sprenkle13 Jul
      • Re: update fails... any suggestions?Warren Young13 Jul
        • Re: update fails... any suggestions?Warren Young13 Jul
        • Re: update fails... any suggestions?Jay Sprenkle13 Jul
          • Re: update fails... any suggestions?Kemet14 Jul
            • Re: update fails... any suggestions?Warren Young14 Jul
              • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                  • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                    • Re: update fails... any suggestions?Jay Sprenkle14 Jul
                      • Re: update fails... any suggestions?Warren Young15 Jul
                        • Re: update fails... any suggestions?Jay Sprenkle15 Jul