8412e8481387a7f9489f156bf091c84eee44ba98
braney
  Mon Apr 22 18:19:25 2019 -0700
missed a place where indexs where limited to 16 charqcters, which breaks
on Gencode genes

diff --git src/hg/near/hgMapToGene/hgMapToGene.c src/hg/near/hgMapToGene/hgMapToGene.c
index 28c5473..aed94bf 100644
--- src/hg/near/hgMapToGene/hgMapToGene.c
+++ src/hg/near/hgMapToGene/hgMapToGene.c
@@ -412,32 +412,32 @@
     }
 bedFreeList(&bedList);
 binKeeperFree(&bk);
 }
 
 void createTable(struct sqlConnection *conn, char *tableName, boolean unique)
 /* Create our name/value table, dropping if it already exists. */
 {
 char *indexType =  (unique ? "UNIQUE" : "INDEX");
 struct dyString *dy = dyStringNew(512);
 sqlDyStringPrintf(dy, 
 "CREATE TABLE  %s (\n"
 "    name varchar(255) not null,\n"
 "    value varchar(255) not null,\n"
 "              #Indices\n"
-"    %s(name(16)),\n"
-"    INDEX(value(16))\n"
+"    %s(name),\n"
+"    INDEX(value)\n"
 ")\n",  tableName, indexType);
 sqlRemakeTable(conn, tableName, dy->string);
 dyStringFree(&dy);
 }
 
 void hgMapTableToGene(char *database, struct sqlConnection *conn, struct sqlConnection *tConn,
 	char *geneTable, char *geneTableType,
 	char *otherTable, char *otherType, char *outTable,
 	struct hash *lookupHash, struct hash *overrideHash, 
 	struct hash *excludeHash)
 /* hgMapTableToGene - Create a table that maps geneTable to otherTable, 
  * choosing the best single item in otherTable for each genePred,
  * unless overridden by an entry in the override hash. */
 {
 /* Open tab file and database loop through each chromosome writing to it. */