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

[Dan Pascu]

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