Bugs item #1528995, was opened at 2006-07-26 16:31 Message generated for change (Comment added) made by miconda You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1528995&group_id=139143
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: modules Group: ver devel >Status: Pending Resolution: None Priority: 5 Submitted By: Norman Brandinger (goestelecom) Assigned to: Daniel-Constantin Mierla (miconda) Summary: avp_db_query() changes the query string Initial Comment: We recently changed some database columns to mixed case from only lowercase. We updated avp_db_query() to match the mixed case that the database expects, however during execution an error message is produced indicating an unknown column. The column name in the OpenSER error message has been changed to lowercase. We tested this by renaming the database column so that it was all lowercase (we left avp_db_query() mixed case). This test successed without error. The results seem to indicate that avp_db_query() converts the passed query string to lowercase before passing it on to the database. While it is possible to work around this problem by forcing all database columns to be lowercase, this seems to be a pretty big restriction imposed on the end user. Regards, Norm ---------------------------------------------------------------------- >Comment By: Daniel-Constantin Mierla (miconda) Date: 2006-08-10 12:24 Message: Logged In: YES user_id=1246013 Any update on this? Is it specific to postgres library? ---------------------------------------------------------------------- Comment By: Daniel-Constantin Mierla (miconda) Date: 2006-08-03 20:14 Message: Logged In: YES user_id=1246013 I checked the sources, and there is no conversion to lowercase. Would this be possible to occur in the Postgres library? Can you add a log message to print the query string in the postgres module just before sending the query to Postgres, to see the format? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1528995&group_id=139143 _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
