src/hg/visiGene/vgProbeTrack/vgProbeTrack.c 1.16

Index: src/hg/visiGene/vgProbeTrack/vgProbeTrack.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/visiGene/vgProbeTrack/vgProbeTrack.c,v
retrieving revision 1.15
retrieving revision 1.16
diff -b -B -U 4 -r1.15 -r1.16
--- src/hg/visiGene/vgProbeTrack/vgProbeTrack.c	13 Oct 2009 05:37:19 -0000	1.15
+++ src/hg/visiGene/vgProbeTrack/vgProbeTrack.c	14 Oct 2009 19:03:02 -0000	1.16
@@ -1436,8 +1436,10 @@
 ,database,fasta);
 verbose(1,"%s\n",cmd); system(cmd);
 
 sqlUpdate(conn, "create index seq on vgRemapTemp(seq(40));");
+/* required for mysql 5 longtext for case-insensitive comparisons of blobs */
+sqlUpdate(conn, "ALTER table vgRemapTemp modify seq longtext;");
 
 /* get remapped psl probes not yet aligned */
 dyStringClear(dy);
 dyStringPrintf(dy, 
@@ -1446,9 +1448,9 @@
     "concat('vgPrb_',e.id),m.qSize,m.qStart,m.qEnd,m.tName,m.tSize,m.tStart,m.tEnd,m.blockCount,"
     "m.blockSizes,m.qStarts,m.tStarts"    
     " from vgPrb e, vgPrbAliAll a, %s.%s m, vgRemapTemp n"
     " where e.id = a.vgPrb and a.db = '%s' and a.status='new'"
-    " and m.qName = n.name and n.seq = lower(e.seq)"
+    " and m.qName = n.name and n.seq = e.seq"
     " and e.taxon = %d and e.state='seq' and e.seq <> ''"
     " order by m.tName,m.tStart"
     ,db,track,db,fromTaxon);
 rc = 0;