Changes between Version 234 and Version 235 of DatabaseBasedAnalysis/Spectrum


Ignore:
Timestamp:
12/09/19 18:20:25 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Spectrum

    v234 v235  
    115115{{{#!Spoiler
    116116{{{#!sql
    117         "CREATE TEMPORARY TABLE DataFiles\n"
    118         "(\n"
    119         "   FileId INT UNSIGNED NOT NULL,\n"
    120         "   PRIMARY KEY (FileId) USING HASH\n"
    121         ") ENGINE=Memory\n"
    122         "AS\n"
    123         "(\n"
    124         "   SELECT\n"
    125         "      FileId\n"
    126         "   FROM\n"
    127         "      factdata.RunInfo\n"
    128         "   WHERE\n"
    129         "      %0:where\n"
    130         "   ORDER BY\n"
    131         "      FileId\n"  // In order: faster
    132         ")";
     117CREATE TEMPORARY TABLE DataFiles
     118(
     119   FileId INT UNSIGNED NOT NULL,
     120   PRIMARY KEY (FileId) USING HASH
     121) ENGINE=Memory
     122AS
     123(
     124   SELECT
     125      FileId
     126   FROM
     127      factdata.RunInfo
     128   WHERE
     129      %0:where
     130   ORDER BY
     131      FileId
     132)
    133133}}}
    134134}}}