File Changes for angie

v343_base to v344_preview (2017-01-09 to 2017-01-16) v344

• src/hg/hgc/hgc.c
  • lines changed 4, context: html, text, full: html, text
    2f262ebebd76067ea983cfeb7454ed626a450c61 Fri Jan 6 15:45:54 2017 -0800
    In mysql 5.7 with the default configuration, it is now an error if a SELECT list using DISTINCT does not include all ORDER BY fields. The solution is to add the ORDER BY fields to the end of the SELECT list if they're not already included. The extra columns returned by the query are ignored. refs #18626, #18597
• src/hg/lib/hAnno.c
  • lines changed 6, context: html, text, full: html, text
    6072cb04b34e57ebdef620512124c4d8722b79df Fri Jan 13 11:09:48 2017 -0800
    hAnnoGetAssembly assumed that db.2bit would be found in hDbDbNibPath(db) but for old nib/ assemblies it is one level up in /gbdb/db/. Similar to hdb's hNibForChrom, test file existence and look in ../ as a backup. fixes #18445
• src/hg/lib/hdb.c
  • lines changed 6, context: html, text, full: html, text
    2f262ebebd76067ea983cfeb7454ed626a450c61 Fri Jan 6 15:45:54 2017 -0800
    In mysql 5.7 with the default configuration, it is now an error if a SELECT list using DISTINCT does not include all ORDER BY fields. The solution is to add the ORDER BY fields to the end of the SELECT list if they're not already included. The extra columns returned by the query are ignored. refs #18626, #18597
• src/hg/lib/web.c
  • lines changed 6, context: html, text, full: html, text
    2f262ebebd76067ea983cfeb7454ed626a450c61 Fri Jan 6 15:45:54 2017 -0800
    In mysql 5.7 with the default configuration, it is now an error if a SELECT list using DISTINCT does not include all ORDER BY fields. The solution is to add the ORDER BY fields to the end of the SELECT list if they're not already included. The extra columns returned by the query are ignored. refs #18626, #18597