Hi, Looks like my screw-up. My change for Trafodion 1585 is the likely culprit. I think the thing to do is simply update the expected results.
Dave -----Original Message----- From: Sandhya Sundaresan [mailto:[email protected]] Sent: Thursday, June 9, 2016 9:57 AM To: [email protected] Cc: Dave Birdsall <[email protected]>; Qin, Hao (Howard) <[email protected]> Subject: RE: compGeneral/TEST015 : Trafodion master Daily Test Result - 232 - Still Failing compGeneral/TETS015 fails with a diff. Could one of the checkins(Dave or Howard) below have caused it ? Here is the diff : http://traf-testlogs.esgyn.com/Daily-master/232/regress-compGeneral-cdh/sql-regress-logs/compGeneral/DIFF015 1268c1268 < NESTED_JOIN --- > HYBRID_#HASH_JOIN 1300,1302c1300 < TRAFODION_SCAN < NESTED_JOIN < PROBE_CACHE 1.000E+000 10 fragment_ --- > HYBRID_#HASH_JOIN 1304a1303 > TRAFODION_SCAN 1306c1305 < --- 5 row(s) selected. --- > --- 4 row(s) selected. 1778c1777 < join_method: hash parallel_join_ --- > join_method: hash hash_join_predi 1797c1796 < 1.2 --- > 1.0 1801c1800 < 1.2 --- > 1.0 2112c2111 < 1.2 --- > 1.0 2116c2115 < 1.2 --- > 1.0 2259c2258 < NESTED_JOIN --- > HYBRID_#HASH_JOIN 2272c2271 < NESTED_JOIN --- > HYBRID_#HASH_JOIN 2286c2285 < NESTED_JOIN --- > HYBRID_#HASH_JOIN 2690,2695c2689 < OPERATOR < ---------- < < TUPLELIST < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2733,2738c2727 < OPERATOR < ---------- < < TUPLELIST < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2763c2752 < +>where operator in ('TRAFODION_SCAN') and position('mdam_disjunct' in description) > 0 --- > +>where operator in ('FILE_SCAN') and position('mdam_disjunct' in > description) > 0 2794,2799c2783 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = count(1 )) and ((A = 1) o < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2817,2822c2801 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = max(CAT.MYHCUBE.T0.A)) an < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2840,2845c2819 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = sum(CAT.MYHCUBE.T0.B)) an < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2863,2868c2837 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2888,2893c2857 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2911,2916c2875 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2945,2950c2904 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2956c2910 < HYBRID_#HASH_JOIN --- > NESTED_JOIN 2968,2973c2922 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 2979c2928 < HYBRID_#HASH_JOIN --- > NESTED_JOIN 2991,2996c2940 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3002c2946 < HYBRID_#HASH_JOIN --- > NESTED_JOIN 3014,3019c2958 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3025c2964 < HYBRID_#HASH_JOIN --- > NESTED_JOIN 3039,3044c2978 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3062,3067c2996 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3099,3104c3028 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = count(1 )) and ((A = 1) o < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3122,3127c3046 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = max(CAT.MYHCUBE.T0.A)) an < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3145,3150c3064 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = sum(CAT.MYHCUBE.T0.B)) an < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3168,3173c3082 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3193,3198c3102 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) ((A = 1) or (A = 3)) < < --- 1 row(s) selected. --- > --- 0 row(s) selected. 3216,3221c3120 < TNAME MDAM_DISJUNCT < ---------- < < C2 (CAT.MYHCUBE.CUBE2) (B = 2) and ((A = 1) or (A = 3 < < --- 1 row(s) selected. --- > --- 0 row(s) selected. -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Thursday, June 9, 2016 4:41 AM To: [email protected] Subject: Trafodion master Daily Test Result - 232 - Still Failing Daily Automated Testing master Jenkins Job: https://jenkins.esgyn.com/job/Check-Daily-master/232/ Archived Logs: http://traf-testlogs.esgyn.com/Daily-master/232 Bld Downloads: http://traf-builds.esgyn.com Changes since previous daily build: [hao.qin] Fix webroot reported assertion failure [dbirdsall] [TRAFODION-2041] Turn off bucket cache in HBaseClient estimateRowCount Test Job Results: FAILURE core-regress-compGeneral-cdh (39 min) FAILURE core-regress-compGeneral-hdp (59 min) FAILURE core-regress-hive-cdh (33 min) SUCCESS build-master-debug (27 min) SUCCESS build-master-release (32 min) SUCCESS core-regress-charsets-cdh (28 min) SUCCESS core-regress-charsets-hdp (44 min) SUCCESS core-regress-core-cdh (47 min) SUCCESS core-regress-core-hdp (57 min) SUCCESS core-regress-executor-cdh (1 hr 4 min) SUCCESS core-regress-executor-hdp (1 hr 21 min) SUCCESS core-regress-fullstack2-cdh (12 min) SUCCESS core-regress-fullstack2-hdp (14 min) SUCCESS core-regress-hive-hdp (52 min) SUCCESS core-regress-privs1-cdh (39 min) SUCCESS core-regress-privs1-hdp (54 min) SUCCESS core-regress-privs2-cdh (44 min) SUCCESS core-regress-privs2-hdp (48 min) SUCCESS core-regress-qat-cdh (19 min) SUCCESS core-regress-qat-hdp (33 min) SUCCESS core-regress-seabase-cdh (1 hr 2 min) SUCCESS core-regress-seabase-hdp (1 hr 15 min) SUCCESS core-regress-udr-cdh (23 min) SUCCESS core-regress-udr-hdp (43 min) SUCCESS jdbc_test-cdh (32 min) SUCCESS jdbc_test-hdp (36 min) SUCCESS phoenix_part1_T2-cdh (56 min) SUCCESS phoenix_part1_T2-hdp (1 hr 27 min) SUCCESS phoenix_part1_T4-cdh (56 min) SUCCESS phoenix_part1_T4-hdp (1 hr 9 min) SUCCESS phoenix_part2_T2-cdh (52 min) SUCCESS phoenix_part2_T2-hdp (1 hr 24 min) SUCCESS phoenix_part2_T4-cdh (51 min) SUCCESS phoenix_part2_T4-hdp (1 hr 12 min) SUCCESS pyodbc_test-cdh (15 min) SUCCESS pyodbc_test-hdp (23 min)
