Changeset 17871

Timestamp:

May 30, 2008, 4:16:52 PM (18 years ago)

Author:

jhoblitt

Message:

make sure TIMESTAMP fields don't get translated into UNSIGNED DATATIME

File:

• trunk/psLib/src/db/psDB.c (modified) (2 diffs)

trunk/psLib/src/db/psDB.c

@@ -23 +23 @@
  * 4.1.2 or newer is required.
  *
- * $Id: psDB.c,v 1.159 2008-05-31 00:42:35 jhoblitt Exp $
+ * $Id: psDB.c,v 1.160 2008-05-31 02:16:52 jhoblitt Exp $
  */
 
@@ -2321 +2321 @@
     // signed or unsigned.  The result is this ugly conversion from
     // mysql -> ascii -> ptype
-    if (flags & UNSIGNED_FLAG) {
+    // XXX it appears that TIMESTAMP fields get marked as being unsigned...
+    if ((flags & UNSIGNED_FLAG) && strncmp(sqlType, "DATETIME", 9)) {
         psString new = NULL;
         psStringAppend(&new, "%s UNSIGNED", sqlType);