5b8c4168d4807c729fc8b1f199d9eb03c9411069
galt
  Thu Mar 3 18:40:54 2016 -0800
Replacing simple literal NOSQLINJ in string with the #define NOSQLINJ. This is slightly better because the compiler can catch a mis-spelling of the NOSQLINJ keyword. This was suggested by Angie.

diff --git src/hg/hgText/hgText.c src/hg/hgText/hgText.c
index 20243a9..59975bb 100644
--- src/hg/hgText/hgText.c
+++ src/hg/hgText/hgText.c
@@ -974,31 +974,31 @@
 /* separate tables in db into positional and nonpositional lists,
  * with db added as a prefix to each name. */
 {
 struct hash *posTableHash = newHash(7);
 struct hashEl *posTableList;
 struct hash *nonposTableHash = newHash(7);
 struct hashEl *nonposTableList;
 struct sqlResult *sr;
 char **row;
 char query[256];
 char name[128];
 char chrom[32];
 char post[64];
 char fullName[128];
 
-strcpy(query, "NOSQLINJ SHOW TABLES");
+strcpy(query, NOSQLINJ "SHOW TABLES");
 sr = sqlGetResult(conn, query);
 while((row = sqlNextRow(sr)) != NULL)
     {
     if (excludeTable(row[0]))
 	continue;
 
     /* if table name is of the form, chr*_random_* or chr*_*: */
     if ( (sscanf(row[0], "chr%32[^_]_random_%64s", chrom, post) == 2) ||
 	(sscanf(row[0], "chr%32[^_]_hla_hap1_%64s", chrom, post) == 2) ||
 	(sscanf(row[0], "chr%32[^_]_hla_hap2_%64s", chrom, post) == 2) ||
 	(sscanf(row[0], "chr%32[^_]_%64s", chrom, post) == 2))
 	{
 	snprintf(name, sizeof(name), "chrN_%s", post);
 	// If a chrN_ table is already in the (positional) hash,
 	// don't bother looking up its fields.