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 >> [email protected] >> http://openser.org/cgi-bin/mailman/listinfo/devel > > -- > Dan > > _______________________________________________ > Devel mailing list > [email protected] > http://openser.org/cgi-bin/mailman/listinfo/devel > _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
