Module: sip-router Branch: janakj/mysql Commit: b74e6f6521af86e9fb68e8561c69fcfcd411d7c1 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b74e6f65...
Author: Henning Westerholt henning.westerholt@1und1.de Committer: Henning Westerholt henning.westerholt@1und1.de Date: Mon Sep 15 10:26:35 2008 +0000
- evaluate DECIMAL (and NEW_DECIMAL) type a DB_STRING, and not DB_INT - patch from Alex Hermann, related to #2111861
git-svn-id: https://openser.svn.sourceforge.net/svnroot/openser/trunk@4901 689a6050-402a-0410-94f2-e92a70836424
---
modules/db_mysql/km_res.c | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/modules/db_mysql/km_res.c b/modules/db_mysql/km_res.c index 44e4f48..4a649e3 100644 --- a/modules/db_mysql/km_res.c +++ b/modules/db_mysql/km_res.c @@ -91,10 +91,6 @@ int db_mysql_get_columns(const db_con_t* _h, db_res_t* _r) case MYSQL_TYPE_LONG: case MYSQL_TYPE_INT24: case MYSQL_TYPE_LONGLONG: - case MYSQL_TYPE_DECIMAL: - #if MYSQL_VERSION_ID > 49999 - case MYSQL_TYPE_NEWDECIMAL: - #endif case MYSQL_TYPE_TIMESTAMP: LM_DBG("use DB_INT result type\n"); RES_TYPES(_r)[col] = DB_INT; @@ -121,6 +117,10 @@ int db_mysql_get_columns(const db_con_t* _h, db_res_t* _r) RES_TYPES(_r)[col] = DB_BITMAP; break;
+ case MYSQL_TYPE_DECIMAL: + #if MYSQL_VERSION_ID > 49999 + case MYSQL_TYPE_NEWDECIMAL: + #endif case MYSQL_TYPE_STRING: case MYSQL_TYPE_VAR_STRING: LM_DBG("use DB_STRING result type\n");