unknown
1970-01-01 00:00:00 UTC
--047d7b343aa8300cc104d9d5421f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable <div dir="ltr">yes I'll try. But not today. Can you wait a couple of days?<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/8 <a href="mailto:***@mailme.dk">***@mailme.dk</a> <span dir="ltr"><<a href="mailto:***@mailme.dk" target="_blank">***@mailme.dk</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ok good, I take it you are on master branch. Could you please try the<br>
hotfix/3.2.1 branch ?<br>
<div class="HOEnZb"><div class="h5"><br>
> I use soci from git download of about 1 week ago<br>
><br>
><br>
> 2013/4/8 <a href="mailto:***@mailme.dk">***@mailme.dk</a> <<a href="mailto:***@mailme.dk">***@mailme.dk</a>><br>
><br>
>> Hi Bruno<br>
>><br>
>> What version of soci are you using ?<br>
>><br>
>> It looks a bit like the Postgres regression that went into 3.2.0<br>
>><br>
>> See commit c8ad2a884 for details. It should be fixed in 3.2.1.<br>
>><br>
>> Poul<br>
>><br>
>> > I tried with the escape beckslash \ (that is \:\:box3d) but the error<br>
>> was<br>
>> > the same.<br>
>> > Then I tried to change the cast syntax as suggested by Mateusz and the<br>
>> > query worked.<br>
>> > Could be a good idea to add an escape strategy like that one of the<br>
>> > backslash (\) for parsing the colons.<br>
>> > Do I add the feature request on github?<br>
>> ><br>
>> > thanks for the replies,<br>
>> > Bruno<br>
>> ><br>
>> ><br>
>> > 2013/4/6 Vadim Zeitlin <<a href="mailto:vz-***@zeitlins.org">vz-***@zeitlins.org</a>><br>
>> ><br>
>> >> On Sat, 6 Apr 2013 14:02:09 +0100 Mateusz Loskot <<a href="mailto:***@loskot.net">***@loskot.net</a>><br>
>> >> wrote:<br>
>> >><br>
>> >> ML> > the application gives my the following error:<br>
>> >> ML> ><br>
>> >> ML> > "Wt: fatal error: ERROR: syntax error at or near ""$1""<br>
>> >> ML> > LINE 1: ...etsrid('BOX3D(15.0118 37.4667, 15.2118<br>
>> 37,6667)'::$1,<br>
>> >> 4326) ...<br>
>> >> ML> ><br>
>> >> ML> > the error is given in place of $1 that in the query is ::box3d.<br>
>> >> Why?<br>
>> >> there<br>
>> >> ML> > was this traslation?<br>
>> >> ML><br>
>> >> ML> I haven't tested your query in action, but I suppose there may be<br>
>> >> conflict<br>
>> >> ML> between casting operators and how SOCI parses query to handle<br>
>> >> ML> placeholders bound by name:<br>
>> >> ML><br>
>> >> ML> <a href="http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name" target="_blank">http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name</a><br>
>> >><br>
>> >> FWIW the code in PostgreSQL backend clearly tries to detect the cast<br>
>> >> operators, there are even several cases for this there.<br>
>> >><br>
>> >> ML> > Maybe is the double colons that gives the problem? How<br>
>> >> ML> > I can fix? How to pass a colon in the sql string?<br>
>> >> ML><br>
>> >> ML> Can you try the alternative [1], SQL conformant, syntax for the<br>
>> >> cast:<br>
>> >> ML><br>
>> >> ML> SetSRID(CAST('BOX3D(15.0118 37.4667, 15.2118 37,6667)' AS box3d),<br>
>> >> 4326)<br>
>> >><br>
>> >>
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable <div dir="ltr">yes I'll try. But not today. Can you wait a couple of days?<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/4/8 <a href="mailto:***@mailme.dk">***@mailme.dk</a> <span dir="ltr"><<a href="mailto:***@mailme.dk" target="_blank">***@mailme.dk</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Ok good, I take it you are on master branch. Could you please try the<br>
hotfix/3.2.1 branch ?<br>
<div class="HOEnZb"><div class="h5"><br>
> I use soci from git download of about 1 week ago<br>
><br>
><br>
> 2013/4/8 <a href="mailto:***@mailme.dk">***@mailme.dk</a> <<a href="mailto:***@mailme.dk">***@mailme.dk</a>><br>
><br>
>> Hi Bruno<br>
>><br>
>> What version of soci are you using ?<br>
>><br>
>> It looks a bit like the Postgres regression that went into 3.2.0<br>
>><br>
>> See commit c8ad2a884 for details. It should be fixed in 3.2.1.<br>
>><br>
>> Poul<br>
>><br>
>> > I tried with the escape beckslash \ (that is \:\:box3d) but the error<br>
>> was<br>
>> > the same.<br>
>> > Then I tried to change the cast syntax as suggested by Mateusz and the<br>
>> > query worked.<br>
>> > Could be a good idea to add an escape strategy like that one of the<br>
>> > backslash (\) for parsing the colons.<br>
>> > Do I add the feature request on github?<br>
>> ><br>
>> > thanks for the replies,<br>
>> > Bruno<br>
>> ><br>
>> ><br>
>> > 2013/4/6 Vadim Zeitlin <<a href="mailto:vz-***@zeitlins.org">vz-***@zeitlins.org</a>><br>
>> ><br>
>> >> On Sat, 6 Apr 2013 14:02:09 +0100 Mateusz Loskot <<a href="mailto:***@loskot.net">***@loskot.net</a>><br>
>> >> wrote:<br>
>> >><br>
>> >> ML> > the application gives my the following error:<br>
>> >> ML> ><br>
>> >> ML> > "Wt: fatal error: ERROR: syntax error at or near ""$1""<br>
>> >> ML> > LINE 1: ...etsrid('BOX3D(15.0118 37.4667, 15.2118<br>
>> 37,6667)'::$1,<br>
>> >> 4326) ...<br>
>> >> ML> ><br>
>> >> ML> > the error is given in place of $1 that in the query is ::box3d.<br>
>> >> Why?<br>
>> >> there<br>
>> >> ML> > was this traslation?<br>
>> >> ML><br>
>> >> ML> I haven't tested your query in action, but I suppose there may be<br>
>> >> conflict<br>
>> >> ML> between casting operators and how SOCI parses query to handle<br>
>> >> ML> placeholders bound by name:<br>
>> >> ML><br>
>> >> ML> <a href="http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name" target="_blank">http://soci.sourceforge.net/doc/3.2.0/exchange.html#bind_name</a><br>
>> >><br>
>> >> FWIW the code in PostgreSQL backend clearly tries to detect the cast<br>
>> >> operators, there are even several cases for this there.<br>
>> >><br>
>> >> ML> > Maybe is the double colons that gives the problem? How<br>
>> >> ML> > I can fix? How to pass a colon in the sql string?<br>
>> >> ML><br>
>> >> ML> Can you try the alternative [1], SQL conformant, syntax for the<br>
>> >> cast:<br>
>> >> ML><br>
>> >> ML> SetSRID(CAST('BOX3D(15.0118 37.4667, 15.2118 37,6667)' AS box3d),<br>
>> >> 4326)<br>
>> >><br>
>> >>