github.com/hasnat/dolt/go@v0.0.0-20210628190320-9eb5d843fbb7/libraries/doltcore/sqle/logictest/regressions.sql (about)

     1  CREATE TABLE `nightly_dolt_results` (
     2    `test_file` VARCHAR(255) NOT NULL,
     3    `line_num` BIGINT NOT NULL,
     4    `duration` BIGINT NOT NULL,
     5    `query_string` LONGTEXT NOT NULL,
     6    `result` LONGTEXT NOT NULL,
     7    `error_message` LONGTEXT,
     8    `version` VARCHAR(255) NOT NULL,
     9    PRIMARY KEY (`test_file`,`line_num`)
    10  );
    11  
    12  CREATE TABLE `nightly_dolt_mean_results` (
    13    `version` VARCHAR(255) NOT NULL,
    14    `test_file` VARCHAR(255) NOT NULL,
    15    `line_num` BIGINT NOT NULL,
    16    `mean_duration` DOUBLE NOT NULL,
    17    `result` LONGTEXT NOT NULL,
    18    PRIMARY KEY (`test_file`,`line_num`)
    19  );
    20  
    21  CREATE TABLE `releases_dolt_results` (
    22    `test_file` VARCHAR(255) NOT NULL,
    23    `line_num` BIGINT NOT NULL,
    24    `duration` BIGINT NOT NULL,
    25    `query_string` LONGTEXT NOT NULL,
    26    `result` LONGTEXT NOT NULL,
    27    `error_message` LONGTEXT,
    28    `version` VARCHAR(255) NOT NULL,
    29    PRIMARY KEY (`test_file`,`line_num`)
    30  );
    31  
    32  CREATE TABLE `releases_dolt_mean_results` (
    33    `version` VARCHAR(255) NOT NULL,
    34    `test_file` VARCHAR(255) NOT NULL,
    35    `line_num` BIGINT NOT NULL,
    36    `mean_duration` DOUBLE NOT NULL,
    37    `result` LONGTEXT NOT NULL,
    38    PRIMARY KEY (`test_file`,`line_num`)
    39  );
    40  
    41  create view `releases_nightly_duration_change`
    42  as
    43  select *
    44  from
    45  (
    46    select 
    47    r.test_file, 
    48    r.version as release_version, 
    49    sum(r.mean_duration) as release_mean_duration_sum_ms, 
    50    n.version as nightly_build, 
    51    sum(n.mean_duration) as nightly_mean_duration_sum_ms, 
    52    (100.0 * (cast(sum(r.mean_duration) as decimal(48, 16)) - 
    53      cast(sum(n.mean_duration) as decimal(48, 16))) / 
    54      (cast((sum(r.mean_duration)) as decimal(48, 16)) + .00001)) as percent_change 
    55    from releases_dolt_mean_results as r 
    56    join nightly_dolt_mean_results as n 
    57    on r.test_file = n.test_file and r.line_num = n.line_num
    58  )
    59  as wrapped where percent_change < -5.0;
    60  
    61  create view `releases_nightly_result_change`
    62  as 
    63  select 
    64  r.test_file, 
    65  r.line_num, 
    66  r.version as release_version, 
    67  r.result as release_result, 
    68  n.version as nightly_build, 
    69  n.result as nightly_result 
    70  from releases_dolt_mean_results as r 
    71  join nightly_dolt_mean_results as n 
    72  on r.line_num = n.line_num 
    73  and r.test_file = n.test_file 
    74  and (r.result = "ok" and n.result != "ok");
    75  
    76  create view `release_committer_result_change`
    77  as
    78  select
    79  r.test_file,
    80  r.line_num,
    81  r.query_string,
    82  r.version as release_version,
    83  r.result as release_result,
    84  n.version as committer_version,
    85  n.result as commiter_result,
    86  n.error_message as commiter_error_message
    87  from releases_dolt_results as r
    88  join nightly_dolt_results as n
    89  on r.line_num = n.line_num
    90  and r.test_file = n.test_file
    91  and (r.result = "ok" and n.result != "ok");