861e6f43bdfd6fd801c12200f44631a204655064 angie Tue Mar 21 14:47:29 2017 -0700 Yet another place where we need the all_ prefix for the table. fixes #19111 diff --git src/hg/lib/hdb.c src/hg/lib/hdb.c index 17e2b5b..223dec0 100644 --- src/hg/lib/hdb.c +++ src/hg/lib/hdb.c @@ -3594,31 +3594,31 @@ { rowOffset = hti->hasBin; if (hti->isSplit) { if (!sameString(fields,"*")) sqlCkIl(fields); sqlDyStringPrintf(query, "select %-s from %s_%s", fields, chrom, rootTable); if (extraWhere != NULL) dyStringPrintf(query, " where %s", extraWhere); } else { if (!sameString(fields,"*")) sqlCkIl(fields); sqlDyStringPrintf(query, "select %-s from %s where %s='%s'", - fields, rootTable, hti->chromField, chrom); + fields, hti->rootName, hti->chromField, chrom); if (extraWhere != NULL) dyStringPrintf(query, " and (%s)", extraWhere); } if (order) sqlDyStringPrintf(query, " order by %s", hti->startField); sr = sqlGetResult(conn, query->string); } freeDyString(&query); if (retRowOffset != NULL) *retRowOffset = rowOffset; return sr; } struct sqlResult *hChromQuery(struct sqlConnection *conn, char *rootTable, char *chrom,