Changeset 12003 for trunk/ippTools/src/warptool.c

Timestamp:

Feb 22, 2007, 2:56:44 PM (19 years ago)

Author:

jhoblitt

Message:

document the issue with mysql 4.1.x

File:

• trunk/ippTools/src/warptool.c (modified) (1 diff)

trunk/ippTools/src/warptool.c

@@ -938 +938 @@
 
 #if MYSQL5
+    // XXX at MySQL 4.1.21 (probably all of 4.1.x) chokes and dies on this
+    // statement as it thinks it is trying to select from the table being
+    // updated. The 4.1 manual says that nested sub-queries are explicited
+    // allowed to do this with update statements as a temporary table is
+    // created so that you are not actually selecting from the table you are
+    // modifying.
     char *query =
         "UPDATE p4Run\n"