Pushbuild test failure xref

Start date: (example: 2007-03-01 19:27:58)
End date:
Tree: (example: mysql-5.0)
Platform (LIKE+): (example: vm-%, not vm-win2003-64-b)
Test type: (example: ps_row)
Test name: (example: alias)
Test output match (LIKE): (example: Failed to start % mysqld)
Max. number of rows:

Test output: [Show all] [Hide all]

Push date Tree Push number (name) Platform Test type Test name Link
±2008-09-29 06:24:00 bzr_mysql-5.1-rpl 2 (He_Zhenxing__hezx-20080929062400-1) vm-win2003-64-b n_mix rpl.rpl_server_id1 [log]
±2008-09-29 06:24:00 bzr_mysql-5.1-rpl 2 (He_Zhenxing__hezx-20080929062400-1) vm-win2003-64-b ps_row rpl.rpl000011 [log]
±2008-09-22 16:18:00 bzr_mysql-5.1-rpl 3 (Magnus_Svensson__msvensson-20080922161800-1) vm-win2003-64-b ps_row rpl.rpl_delete_no_where [log]
±2008-09-22 16:18:00 bzr_mysql-5.1-rpl 3 (Magnus_Svensson__msvensson-20080922161800-1) vm-win2003-64-b ps_row rpl.rpl_ps [log]
±2008-09-22 07:04:00 bzr_mysql-5.1-rpl 4 (Magnus_Svensson__msvensson-20080922070400-1) vm-win2003-64-b n_mix rpl.rpl_loadfile [log]
±2008-09-15 15:47:00 bzr_mysql-5.1-rpl 6 (Magnus_Svensson__msvensson-20080915154700-1) vm-win2003-64-b ps_row rpl.rpl_loadfile [log]
±2008-09-11 16:45:00 bzr_mysql-5.1-rpl 9 (Magnus_Svensson__msvensson-20080911164500-1) vm-win2003-64-b n_mix main.timezone4 [log]
±2008-08-29 10:59:00 bzr_mysql-5.1-rpl 17 (Magnus_Svensson__msvensson-20080829105900-1) vm-win2003-64-b ps_row main.not_embedded_server [log]

Total 8 matches.

SELECT * FROM (
  SELECT psh_date, psh_tree, psh_order, psh_name,
         (SELECT Max(P2.psh_order)
            FROM push P2
           WHERE P2.psh_tree = P1.psh_tree) - psh_order AS pushno,
         tfl_bld_platform, tfl_tst_type, tfl_name, tfl_text
    FROM push P1
   STRAIGHT_JOIN test_failure
      ON (psh_tree = tfl_psh_tree AND psh_name = tfl_psh_name)
   WHERE tfl_text LIKE ?
   ORDER BY psh_date DESC
   LIMIT 50
) t1
 ORDER BY psh_date DESC, psh_tree, psh_order DESC, tfl_bld_platform, tfl_tst_type