[SR-Dev] git:janakj/mysql: - evaluate DECIMAL (and NEW_DECIMAL) type a DB_STRING, and not DB_INT

[Jan Janak]

Module: sip-router
Branch: janakj/mysql
Commit: b74e6f6521af86e9fb68e8561c69fcfcd411d7c1
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b74e6f6521af86e9fb68e8561c69fcfcd411d7c1

Author: Henning Westerholt <henning.westerholt at 1und1.de>
Committer: Henning Westerholt <henning.westerholt at 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");