Dammit, Vladimir. Stop removing tests!! We need that complexity to make things break.
You seem to have a personal agenda to make the test suite run in under a minute. That goal cannot be met. Calcite is a complex piece of software. Julian > On Sep 6, 2018, at 8:54 AM, vladimirsitni...@apache.org wrote: > > Repository: calcite > Updated Branches: > refs/heads/master 3df638c9d -> 88f125541 > > > Reduce HepPlannerTest#testRuleApplyCount complexity > > > Project: http://git-wip-us.apache.org/repos/asf/calcite/repo > Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/88f12554 > Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/88f12554 > Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/88f12554 > > Branch: refs/heads/master > Commit: 88f125541a2875f693a02dbbd12ad5184124bafa > Parents: 3df638c > Author: Vladimir Sitnikov <sitnikov.vladi...@gmail.com> > Authored: Thu Sep 6 18:53:47 2018 +0300 > Committer: Vladimir Sitnikov <sitnikov.vladi...@gmail.com> > Committed: Thu Sep 6 18:53:47 2018 +0300 > > ---------------------------------------------------------------------- > .../org/apache/calcite/test/HepPlannerTest.java | 86 +------------------- > 1 file changed, 2 insertions(+), 84 deletions(-) > ---------------------------------------------------------------------- > > > http://git-wip-us.apache.org/repos/asf/calcite/blob/88f12554/core/src/test/java/org/apache/calcite/test/HepPlannerTest.java > ---------------------------------------------------------------------- > diff --git a/core/src/test/java/org/apache/calcite/test/HepPlannerTest.java > b/core/src/test/java/org/apache/calcite/test/HepPlannerTest.java > index dea4c16..8eb78d5 100644 > --- a/core/src/test/java/org/apache/calcite/test/HepPlannerTest.java > +++ b/core/src/test/java/org/apache/calcite/test/HepPlannerTest.java > @@ -77,85 +77,6 @@ public class HepPlannerTest extends RelOptTestBase { > + " select ENAME, 350401 as cat_id, '18' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 350401 union all\n" > + " select ENAME, 50015560 as cat_id, '19' as cat_name, 0 as > require_free_postage, 0 as require_15return, 0 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50015560 union all\n" > + " select ENAME, 122658003 as cat_id, '20' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122658003 union all\n" > - + " select ENAME, 122716008 as cat_id, '21' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122716008 union all\n" > - + " select ENAME, 50018406 as cat_id, '22' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50018406 union all\n" > - + " select ENAME, 50018407 as cat_id, '23' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50018407 union all\n" > - + " select ENAME, 50024678 as cat_id, '24' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024678 union all\n" > - + " select ENAME, 50022290 as cat_id, '25' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022290 union all\n" > - + " select ENAME, 50020072 as cat_id, '26' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020072 union all\n" > - + " select ENAME, 50024679 as cat_id, '27' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024679 union all\n" > - + " select ENAME, 50013326 as cat_id, '28' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013326 union all\n" > - + " select ENAME, 50020032 as cat_id, '19' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020032 union all\n" > - + " select ENAME, 50022273 as cat_id, '30' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022273 union all\n" > - + " select ENAME, 50013511 as cat_id, '31' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013511 union all\n" > - + " select ENAME, 122694006 as cat_id, '32' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122694006 union all\n" > - + " select ENAME, 50019940 as cat_id, '33' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019940 union all\n" > - + " select ENAME, 50022288 as cat_id, '34' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022288 union all\n" > - + " select ENAME, 50020069 as cat_id, '35' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020069 union all\n" > - + " select ENAME, 50021800 as cat_id, '36' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50021800 union all\n" > - + " select ENAME, 50024684 as cat_id, '37' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024684 union all\n" > - + " select ENAME, 50024676 as cat_id, '38' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024676 union all\n" > - + " select ENAME, 50020070 as cat_id, '39' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020070 union all\n" > - + " select ENAME, 50020058 as cat_id, '40' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020058 union all\n" > - + " select ENAME, 50019938 as cat_id, '41' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019938 union all\n" > - + " select ENAME, 122686009 as cat_id, '42' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122686009 union all\n" > - + " select ENAME, 50022286 as cat_id, '43' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022286 union all\n" > - + " select ENAME, 122692007 as cat_id, '44' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122692007 union all\n" > - + " select ENAME, 50020059 as cat_id, '45' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020059 union all\n" > - + " select ENAME, 50006050 as cat_id, '45' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50006050 union all\n" > - + " select ENAME, 122718006 as cat_id, '47' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122718006 union all\n" > - + " select ENAME, 50022652 as cat_id, '48' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022652 union all\n" > - + " select ENAME, 50024685 as cat_id, '49' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024685 union all\n" > - + " select ENAME, 50020104 as cat_id, '50' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020104 union all\n" > - + " select ENAME, 50013500 as cat_id, '51' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013500 union all\n" > - + " select ENAME, 50003558 as cat_id, '52' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50003558 union all\n" > - + " select ENAME, 50020061 as cat_id, '53' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020061 union all\n" > - + " select ENAME, 122656012 as cat_id, '54' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 122656012 union all\n" > - + " select ENAME, 50024812 as cat_id, '55' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024812 union all\n" > - + " select ENAME, 50022287 as cat_id, '56' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022287 union all\n" > - + " select ENAME, 50020107 as cat_id, '57' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020107 union all\n" > - + " select ENAME, 50019842 as cat_id, '58' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019842 union all\n" > - + " select ENAME, 50020106 as cat_id, '59' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020106 union all\n" > - + " select ENAME, 50020071 as cat_id, '60' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020071 union all\n" > - + " select ENAME, 50019939 as cat_id, '61' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019939 union all\n" > - + " select ENAME, 50020034 as cat_id, '62' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020034 union all\n" > - + " select ENAME, 50020025 as cat_id, '63' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020025 union all\n" > - + " select ENAME, 50022293 as cat_id, '64' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022293 union all\n" > - + " select ENAME, 50022279 as cat_id, '65' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022279 union all\n" > - + " select ENAME, 50013818 as cat_id, '66' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013818 union all\n" > - + " select ENAME, 50020060 as cat_id, '67' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020060 union all\n" > - + " select ENAME, 50020062 as cat_id, '68' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020062 union all\n" > - + " select ENAME, 50022276 as cat_id, '69' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022276 union all\n" > - + " select ENAME, 50022280 as cat_id, '70' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022280 union all\n" > - + " select ENAME, 50020619 as cat_id, '71' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020619 union all\n" > - + " select ENAME, 50013347 as cat_id, '72' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013347 union all\n" > - + " select ENAME, 50008698 as cat_id, '73' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50008698 union all\n" > - + " select ENAME, 50013334 as cat_id, '74' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013334 union all\n" > - + " select ENAME, 50024810 as cat_id, '75' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024810 union all\n" > - + " select ENAME, 50019936 as cat_id, '76' as cat_name, 1 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019936 union all\n" > - + " select ENAME, 50024813 as cat_id, '77' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024813 union all\n" > - + " select ENAME, 50020959 as cat_id, '78' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020959 union all\n" > - + " select ENAME, 124474002 as cat_id, '79' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 124474002 union all\n" > - + " select ENAME, 50019853 as cat_id, '80' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019853 union all\n" > - + " select ENAME, 50019837 as cat_id, '81' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50019837 union all\n" > - + " select ENAME, 50022289 as cat_id, '82' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022289 union all\n" > - + " select ENAME, 50022278 as cat_id, '83' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022278 union all\n" > - + " select ENAME, 50024690 as cat_id, '84' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50024690 union all\n" > - + " select ENAME, 50592002 as cat_id, '85' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50592002 union all\n" > - + " select ENAME, 50013342 as cat_id, '86' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50013342 union all\n" > - + " select ENAME, 50022296 as cat_id, '87' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022296 union all\n" > - + " select ENAME, 123456001 as cat_id, '88' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 123456001 union all\n" > - + " select ENAME, 50022298 as cat_id, '89' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022298 union all\n" > - + " select ENAME, 50022274 as cat_id, '90' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022274 union all\n" > - + " select ENAME, 50006046 as cat_id, '91' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50006046 union all\n" > - + " select ENAME, 50020676 as cat_id, '92' as cat_name, 1 as > require_free_postage, 0 as require_15return, 0 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020676 union all\n" > - + " select ENAME, 50020678 as cat_id, '93' as cat_name, 1 as > require_free_postage, 0 as require_15return, 0 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020678 union all\n" > - + " select ENAME, 121398012 as cat_id, '94' as cat_name, 1 as > require_free_postage, 0 as require_15return, 0 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 121398012 union all\n" > - + " select ENAME, 50020720 as cat_id, '95' as cat_name, 1 as > require_free_postage, 0 as require_15return, 0 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50020720 union all\n" > - + " select ENAME, 50001714 as cat_id, '96' as cat_name, 0 as > require_free_postage, 1 as require_15return, 1 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50001714 union all\n" > - + " select ENAME, 50008905 as cat_id, '97' as cat_name, 1 as > require_free_postage, 0 as require_15return, 1 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50008905 union all\n" > - + " select ENAME, 50008904 as cat_id, '98' as cat_name, 1 as > require_free_postage, 0 as require_15return, 1 as require_48hour,1 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50008904 union all\n" > - + " select ENAME, 50022358 as cat_id, '99' as cat_name, 0 as > require_free_postage, 0 as require_15return, 0 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022358 union all\n" > + " select ENAME, 50022371 as cat_id, '100' as cat_name, 0 as > require_free_postage, 0 as require_15return, 0 as require_48hour,0 as > require_insurance from emp where EMPNO = 20171216 and MGR = 0 and ENAME = 'Y' > and SAL = 50022371\n" > + ") a"; > > @@ -331,13 +252,10 @@ public class HepPlannerTest extends RelOptTestBase { > > @Test public void testRuleApplyCount() { > final long applyTimes1 = checkRuleApplyCount(HepMatchOrder.ARBITRARY); > - assertThat(applyTimes1, is(5451L)); > + assertThat(applyTimes1, is(316L)); > > final long applyTimes2 = checkRuleApplyCount(HepMatchOrder.DEPTH_FIRST); > - assertThat(applyTimes2, is(403L)); > - > - // DEPTH_FIRST has 10x fewer matches than ARBITRARY > - assertThat(applyTimes1 > applyTimes2 * 10, is(true)); > + assertThat(applyTimes2, is(87L)); > } > > @Test public void testMaterialization() throws Exception { >