833cef3fe90d02e134871bb1a6763a5a8128c210
galt
  Tue Feb 8 17:28:24 2022 -0800
Back-quoting new keyword `offset` in hgLoadWiggle. #refs #28799

diff --git src/hg/makeDb/hgLoadWiggle/hgLoadWiggle.c src/hg/makeDb/hgLoadWiggle/hgLoadWiggle.c
index 42b2b28..ce3251a 100644
--- src/hg/makeDb/hgLoadWiggle/hgLoadWiggle.c
+++ src/hg/makeDb/hgLoadWiggle/hgLoadWiggle.c
@@ -313,31 +313,31 @@
 	indexLen = hGetMinIndexLength(database);
     verbose(2, "INDEX chrom length: %d\n", indexLen);
 
     /* Create definition statement. */
     verbose(1, "Creating wiggle table definition in %s.%s\n",
 	    database, track);
     sqlDyStringPrintf(dy, "CREATE TABLE %s (\n", track);
     if (!noBin)
        dyStringAppend(dy, "  bin smallint unsigned not null,\n");
     dyStringAppend(dy, "  chrom varchar(255) not null,\n");
     dyStringAppend(dy, "  chromStart int unsigned not null,\n");
     dyStringAppend(dy, "  chromEnd int unsigned not null,\n");
     dyStringAppend(dy, "  name varchar(255) not null,\n");
     dyStringAppend(dy, "  span int unsigned not null,\n");
     dyStringAppend(dy, "  count int unsigned not null,\n");
-    dyStringAppend(dy, "  offset int unsigned not null,\n");
+    dyStringAppend(dy, "  `offset` int unsigned not null,\n");
     dyStringAppend(dy, "  file varchar(255) not null,\n");
     dyStringAppend(dy, "  lowerLimit double not null,\n");
     dyStringAppend(dy, "  dataRange double not null,\n");
     dyStringAppend(dy, "  validCount int unsigned not null,\n");
     dyStringAppend(dy, "  sumData double not null,\n");
     dyStringAppend(dy, "  sumSquares double not null,\n");
     dyStringAppend(dy, "#Indices\n");
     if (!noBin)
 	dyStringPrintf(dy, "  INDEX(chrom(%d),bin)\n", indexLen);
     else
 	{
 	dyStringPrintf(dy, "  INDEX(chrom(%d),chromStart)\n", indexLen);
 	}
     dyStringAppend(dy, ")\n");
     verbose(2, "%s", dy->string);