4b2e806a0d57f97bbadf9a762778965ccd36989d
angie
  Fri Dec 21 13:57:15 2012 -0800
Bug #9860 (Table Browser paste identifiers button not working for 1000 genomes ph1 Accessible Regions):getExamples() was unaware of bigBed, so an illegal mysql query was constructed.
Fix: added randomBigBedIds().  While in there, enhanced ramdomVcfIds() to ignore
runs of identical IDs because those are placeholders, and might otherwise crowd
out a few meaningful IDs (#8886 note 28).

diff --git src/hg/hgTables/hgTables.h src/hg/hgTables/hgTables.h
index 5408f83..d7475b9 100644
--- src/hg/hgTables/hgTables.h
+++ src/hg/hgTables/hgTables.h
@@ -765,30 +765,33 @@
 
 struct slName *bigBedGetFields(char *table, struct sqlConnection *conn);
 /* Get fields of bigBed as simple name list. */
 
 struct sqlFieldType *bigBedListFieldsAndTypes(char *table, struct sqlConnection *conn);
 /* Get fields of bigBed as list of sqlFieldType. */
 
 struct bed *bigBedGetFilteredBedsOnRegions(struct sqlConnection *conn,
 	char *db, char *table, struct region *regionList, struct lm *lm,
 	int *retFieldCount);
 /* Get list of beds from bigBed, in all regions, that pass filtering. */
 
 void bigBedTabOut(char *db, char *table, struct sqlConnection *conn, char *fields, FILE *f);
 /* Print out selected fields from Big Bed.  If fields is NULL, then print out all fields. */
 
+struct slName *randomBigBedIds(char *table, struct sqlConnection *conn, int count);
+/* Return some arbitrary IDs from a bigBed file. */
+
 void showSchemaBigBed(char *table, struct trackDb *tdb);
 /* Show schema on bigBed. */
 
 /* More stuff in bigBed.c that makes use of autoSql files. */
 
 struct sqlFieldType *sqlFieldTypesFromAs(struct asObject *as);
 /* Convert asObject to list of sqlFieldTypes */
 
 /* BAM stuff from bam.c */
 
 boolean isBamTable(char *table);
 /* Return TRUE if table corresponds to a BAM file. */
 
 struct slName *bamGetFields(char *table);
 /* Get fields of bam as simple name list. */