[Users] Re: [Devel] preparation of patch release 1.0.1

[Klaus Darilion]

Hi Dan!

Do you know if this is also an issue in postgres and if backticks works
also in postgres?

regards
klaus

On Fri, February 3, 2006 13:11, Dan Pascu said:
>
> A thing that would need fixing is how the mysql queries are generated.
> To avoid issues, the field names in queries should be surrounded by
> backticks. This is to avoid a query being invalid because a field name
> that is used matches a mysql keyword.
>
> I have recently experienced this with mysql 5.0 where a number of new
> keywords were introduced. I have a table that has a field named
> 'condition'. In mysql 5.0 I can no longer select this by using a query
> like:
>
> select condition, uri from table where domain = 'test.com';
>
> instead a query like this works:
>
> select `condition`, `uri` from table where `domain` = 'test.com'
>
> The idea is to surround all the field names in the query in backticks,
> wherever they appear, to avoid any future issues if some fieldname that
> openser uses will suddenly become a keyword in the next version of mysql.
>
>
> On Friday 03 February 2006 13:23, Daniel-Constantin Mierla wrote:
>> Hello everybody,
>>
>> a new package building of CVS branch rel_1_0_0 (release v1.0.0) will
>> take place soon. This comes as an update to release 1.0.0 which will
>> include the fixings occurred since 1.0.0 was released.
>>
>> We like to collect all issues of v1.0.0 you are aware of, to be fixed
>> before package generation. Next is a list of the issues that should be
>> fixed:
>> - TLS - when TLS connections is refused, immediate reply instead of
>> waiting for timeout
>> - TCP - when the call is initiated over TCP but the contact advertised
>> is UDP, the BYE from callee is not routed properly (it is tried TCP due
>> to double RR)
>> - record_route_preset() parameter size
>> - ruri matching of canceled transactions (see:
>> http://openser.org/pipermail/users/2006-February/002951.html)
>>
>> Any feedback is appreciated.
>>
>> Cheers,
>> Daniel
>>
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>
> --
> Dan
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>