b13a2a991ee5be9c88fe0f4baf7859900c7c8570 galt Tue May 31 23:29:23 2022 -0700 correction for the SQL NOT operator in sqlSanity.c diff --git src/hg/lib/sqlSanity.c src/hg/lib/sqlSanity.c index 3ee01ad..ef8e785 100644 --- src/hg/lib/sqlSanity.c +++ src/hg/lib/sqlSanity.c @@ -44,31 +44,31 @@ if (tokPtr->type == kxtEquals) sqlDyStringPrintf(clause, "="); else if (tokPtr->type == kxtGT) sqlDyStringPrintf(clause, ">"); else if (tokPtr->type == kxtGE) sqlDyStringPrintf(clause, ">="); else if (tokPtr->type == kxtLT) sqlDyStringPrintf(clause, "<"); else if (tokPtr->type == kxtLE) sqlDyStringPrintf(clause, "<="); else if (tokPtr->type == kxtAnd) sqlDyStringPrintf(clause, "AND"); else if (tokPtr->type == kxtOr) sqlDyStringPrintf(clause, "OR"); else if (tokPtr->type == kxtNot) - sqlDyStringPrintf(clause, "NOT"); + sqlDyStringPrintf(clause, "!"); else if (tokPtr->type == kxtAdd) sqlDyStringPrintf(clause, "+"); else if (tokPtr->type == kxtSub) sqlDyStringPrintf(clause, "-"); else if (tokPtr->type == kxtDiv) sqlDyStringPrintf(clause, "/"); else if (tokPtr->type == kxtOpenParen) { sqlDyStringPrintf(clause, "("); numLeftParen++; } else if (tokPtr->type == kxtCloseParen) { sqlDyStringPrintf(clause, ")"); numRightParen++;