a688821c6fc714f05ecd4459d964e6858a7f5c54
hiram
  Fri Jul 3 11:53:38 2020 -0700
must have chrom= on SQL statements when getting a full table refs #25840

diff --git src/hg/hubApi/getData.c src/hg/hubApi/getData.c
index a42a05a..48471ed 100644
--- src/hg/hubApi/getData.c
+++ src/hg/hubApi/getData.c
@@ -272,34 +272,34 @@
 if (isEmpty(chrom))
     {
     jsonWriteObjectStart(jw, track);	/* begin track data output */
     char fullTableName[256];
     struct chromInfo *ciList = createChromInfoList(NULL, db);
     slSort(ciList, chromInfoCmp);
     struct chromInfo *ci = ciList;
     for ( ; ci && itemsDone < maxItemsOutput; ci = ci->next )
 	{
 	jsonWriteListStart(jw, ci->chrom);	/* starting a chrom output */
 	freeDyString(&query);
 	query = dyStringNew(64);
 	if (hti && hti->isSplit) /* when split, make up split chr name */
 	    {
 	    safef(fullTableName, sizeof(fullTableName), "%s_%s", ci->chrom, hti->rootName);
-	    sqlDyStringPrintf(query, "select * from %s", fullTableName);
+	    sqlDyStringPrintf(query, "select * from %s where chrom='%s'", fullTableName, ci->chrom);
 	    }
 	else
-	    sqlDyStringPrintf(query, "select * from %s", splitSqlTable);
+	    sqlDyStringPrintf(query, "select * from %s where chrom='%s'", splitSqlTable, ci->chrom);
 	if (tdb && isWiggleDataTable(tdb->type))
             itemsDone += wigTableDataOutput(jw, db, splitSqlTable, chrom,
 		start, end, itemsDone);
 	else
 	    itemsDone += sqlQueryJsonOutput(conn, jw, query->string,
 		columnCount, columnNames, jsonTypes, itemsDone);
 	jsonWriteListEnd(jw);	/* chrom data output list end */
 	}
     if (itemsDone >= maxItemsOutput)
 	reachedMaxItems = TRUE;
     jsonWriteObjectEnd(jw);	/* end track data output */
     itemsReturned += itemsDone;
     }
 else
     {	/* a single chrom has been requested, run it */