Changeset 40483 for branches/czw_branch/20170908/psLib/src/db/psDB.c

Timestamp:

Jun 27, 2018, 3:31:55 PM (8 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/czw_branch/20170908

Files:

• . (modified) (1 prop)
• psLib/src/db/psDB.c (modified) (1 diff)

branches/czw_branch/20170908/psLib/src/db/psDB.c

@@ -2425 +2425 @@
                 // used in a where clause...
                 psStringAppend(&query, "%s LIKE '%s'", itemName, item->data.str);
+            } else if (item->comment && psStrcasestr(item->comment, "NOTLKE")) {
+                // XXX ASC NOTE: we should have a better match for
+                // char & varchar columns than this.  LIKE is OK for
+                // very large TEXT columns that really shouldn't be
+                // used in a where clause...
+                psStringAppend(&query, "%s NOT LIKE '%s'", itemName, item->data.str);
             } else {
                 psStringAppend(&query, "%s %s '%s'", itemName, opStr, item->data.str);