hplsql/src/test/results/db/cmp_sum.out.txt

Ln:1 CMP
Ln:1 Query 1: SELECT COUNT(1) AS row_count,
COUNT(C1) AS C1_COUNT_NOT_NULL,
SUM(LENGTH(C1)) AS C1_SUM_LENGTH,
MIN(LENGTH(C1)) AS C1_MIN_LENGTH,
MAX(LENGTH(C1)) AS C1_MAX_LENGTH,
COUNT(C2) AS C2_COUNT_NOT_NULL,
SUM(LENGTH(C2)) AS C2_SUM_LENGTH,
MIN(LENGTH(C2)) AS C2_MIN_LENGTH,
MAX(LENGTH(C2)) AS C2_MAX_LENGTH,
COUNT(C3) AS C3_COUNT_NOT_NULL,
SUM(LENGTH(C3)) AS C3_SUM_LENGTH,
MIN(LENGTH(C3)) AS C3_MIN_LENGTH,
MAX(LENGTH(C3)) AS C3_MAX_LENGTH,
COUNT(C4) AS C4_COUNT_NOT_NULL,
SUM(C4) AS C4_SUM,
MIN(C4) AS C4_MIN,
MAX(C4) AS C4_MAX,
COUNT(C5) AS C5_COUNT_NOT_NULL,
SUM(C5) AS C5_SUM,
MIN(C5) AS C5_MIN,
MAX(C5) AS C5_MAX,
COUNT(C6) AS C6_COUNT_NOT_NULL,
SUM(C6) AS C6_SUM,
MIN(C6) AS C6_MIN,
MAX(C6) AS C6_MAX,
COUNT(C7) AS C7_COUNT_NOT_NULL,
SUM(C7) AS C7_SUM,
MIN(C7) AS C7_MIN,
MAX(C7) AS C7_MAX,
COUNT(C8) AS C8_COUNT_NOT_NULL,
SUM(C8) AS C8_SUM,
MIN(C8) AS C8_MIN,
MAX(C8) AS C8_MAX,
COUNT(C9) AS C9_COUNT_NOT_NULL,
SUM(C9) AS C9_SUM,
MIN(C9) AS C9_MIN,
MAX(C9) AS C9_MAX,
COUNT(C10) AS C10_COUNT_NOT_NULL,
SUM(C10) AS C10_SUM,
MIN(C10) AS C10_MIN,
MAX(C10) AS C10_MAX,
COUNT(C11) AS C11_COUNT_NOT_NULL,
SUM(YEAR(C11)) AS C11_SUM_YEAR,
SUM(MONTH(C11)) AS C11_SUM_MONTH,
SUM(DAY(C11)) AS C11_SUM_DAY,
MIN(C11) AS C11_MIN,
MAX(C11) AS C11_MAX,
COUNT(C12) AS C12_COUNT_NOT_NULL,
SUM(YEAR(C12)) AS C12_SUM_YEAR,
SUM(MONTH(C12)) AS C12_SUM_MONTH,
SUM(DAY(C12)) AS C12_SUM_DAY,
MIN(C12) AS C12_MIN,
MAX(C12) AS C12_MAX FROM src_dt
Ln:1 Query 2: SELECT COUNT(1) AS row_count,
COUNT(C1) AS C1_COUNT_NOT_NULL,
SUM(LENGTH(C1)) AS C1_SUM_LENGTH,
MIN(LENGTH(C1)) AS C1_MIN_LENGTH,
MAX(LENGTH(C1)) AS C1_MAX_LENGTH,
COUNT(C2) AS C2_COUNT_NOT_NULL,
SUM(LENGTH(C2)) AS C2_SUM_LENGTH,
MIN(LENGTH(C2)) AS C2_MIN_LENGTH,
MAX(LENGTH(C2)) AS C2_MAX_LENGTH,
COUNT(C3) AS C3_COUNT_NOT_NULL,
SUM(LENGTH(C3)) AS C3_SUM_LENGTH,
MIN(LENGTH(C3)) AS C3_MIN_LENGTH,
MAX(LENGTH(C3)) AS C3_MAX_LENGTH,
COUNT(C4) AS C4_COUNT_NOT_NULL,
SUM(C4) AS C4_SUM,
MIN(C4) AS C4_MIN,
MAX(C4) AS C4_MAX,
COUNT(C5) AS C5_COUNT_NOT_NULL,
SUM(C5) AS C5_SUM,
MIN(C5) AS C5_MIN,
MAX(C5) AS C5_MAX,
COUNT(C6) AS C6_COUNT_NOT_NULL,
SUM(C6) AS C6_SUM,
MIN(C6) AS C6_MIN,
MAX(C6) AS C6_MAX,
COUNT(C7) AS C7_COUNT_NOT_NULL,
SUM(C7) AS C7_SUM,
MIN(C7) AS C7_MIN,
MAX(C7) AS C7_MAX,
COUNT(C8) AS C8_COUNT_NOT_NULL,
SUM(C8) AS C8_SUM,
MIN(C8) AS C8_MIN,
MAX(C8) AS C8_MAX,
COUNT(C9) AS C9_COUNT_NOT_NULL,
SUM(C9) AS C9_SUM,
MIN(C9) AS C9_MIN,
MAX(C9) AS C9_MAX,
COUNT(C10) AS C10_COUNT_NOT_NULL,
SUM(C10) AS C10_SUM,
MIN(C10) AS C10_MIN,
MAX(C10) AS C10_MAX,
COUNT(C11) AS C11_COUNT_NOT_NULL,
SUM(YEAR(C11)) AS C11_SUM_YEAR,
SUM(MONTH(C11)) AS C11_SUM_MONTH,
SUM(DAY(C11)) AS C11_SUM_DAY,
MIN(C11) AS C11_MIN,
MAX(C11) AS C11_MAX,
COUNT(C12) AS C12_COUNT_NOT_NULL,
SUM(YEAR(C12)) AS C12_SUM_YEAR,
SUM(MONTH(C12)) AS C12_SUM_MONTH,
SUM(DAY(C12)) AS C12_SUM_DAY,
MIN(C12) AS C12_MIN,
MAX(C12) AS C12_MAX FROM src_dt
row_count	500	500
c1_count_not_null	500	500
c1_sum_length	3406	3406
c1_min_length	5	5
c1_max_length	7	7
c2_count_not_null	500	500
c2_sum_length	3406	3406
c2_min_length	5	5
c2_max_length	7	7
c3_count_not_null	500	500
c3_sum_length	3406	3406
c3_min_length	5	5
c3_max_length	7	7
c4_count_not_null	106	106
c4_sum	6697	6697
c4_min	0	0
c4_max	126	126
c5_count_not_null	500	500
c5_sum	130091	130091
c5_min	0	0
c5_max	498	498
c6_count_not_null	500	500
c6_sum	130091	130091
c6_min	0	0
c6_max	498	498
c7_count_not_null	500	500
c7_sum	130091	130091
c7_min	0	0
c7_max	498	498
c8_count_not_null	500	500
c8_sum	13009.1	13009.1
c8_min	0	0
c8_max	49.8	49.8
c9_count_not_null	500	500
c9_sum	13009.10001783073	13009.10001783073
c9_min	0.0	0.0
c9_max	49.79999923706055	49.79999923706055
c10_count_not_null	500	500
c10_sum	13009.09999999999	13009.09999999999
c10_min	0.0	0.0
c10_max	49.8	49.8
c11_count_not_null	500	500
c11_sum_year	1007500	1007500
c11_sum_month	4500	4500
c11_sum_day	3500	3500
c11_min	null	null
c11_max	null	null
c12_count_not_null	500	500
c12_sum_year	1007500	1007500
c12_sum_month	4500	4500
c12_sum_day	3500	3500
c12_min	null	null
c12_max	null	null
Ln:2 CMP
Ln:2 Query 1: SELECT COUNT(1) AS row_count,
COUNT(C1) AS C1_COUNT_NOT_NULL,
SUM(LENGTH(C1)) AS C1_SUM_LENGTH,
MIN(LENGTH(C1)) AS C1_MIN_LENGTH,
MAX(LENGTH(C1)) AS C1_MAX_LENGTH,
COUNT(C2) AS C2_COUNT_NOT_NULL,
SUM(LENGTH(C2)) AS C2_SUM_LENGTH,
MIN(LENGTH(C2)) AS C2_MIN_LENGTH,
MAX(LENGTH(C2)) AS C2_MAX_LENGTH,
COUNT(C3) AS C3_COUNT_NOT_NULL,
SUM(LENGTH(C3)) AS C3_SUM_LENGTH,
MIN(LENGTH(C3)) AS C3_MIN_LENGTH,
MAX(LENGTH(C3)) AS C3_MAX_LENGTH,
COUNT(C4) AS C4_COUNT_NOT_NULL,
SUM(C4) AS C4_SUM,
MIN(C4) AS C4_MIN,
MAX(C4) AS C4_MAX,
COUNT(C5) AS C5_COUNT_NOT_NULL,
SUM(C5) AS C5_SUM,
MIN(C5) AS C5_MIN,
MAX(C5) AS C5_MAX,
COUNT(C6) AS C6_COUNT_NOT_NULL,
SUM(C6) AS C6_SUM,
MIN(C6) AS C6_MIN,
MAX(C6) AS C6_MAX,
COUNT(C7) AS C7_COUNT_NOT_NULL,
SUM(C7) AS C7_SUM,
MIN(C7) AS C7_MIN,
MAX(C7) AS C7_MAX,
COUNT(C8) AS C8_COUNT_NOT_NULL,
SUM(C8) AS C8_SUM,
MIN(C8) AS C8_MIN,
MAX(C8) AS C8_MAX,
COUNT(C9) AS C9_COUNT_NOT_NULL,
SUM(C9) AS C9_SUM,
MIN(C9) AS C9_MIN,
MAX(C9) AS C9_MAX,
COUNT(C10) AS C10_COUNT_NOT_NULL,
SUM(C10) AS C10_SUM,
MIN(C10) AS C10_MIN,
MAX(C10) AS C10_MAX,
COUNT(C11) AS C11_COUNT_NOT_NULL,
SUM(YEAR(C11)) AS C11_SUM_YEAR,
SUM(MONTH(C11)) AS C11_SUM_MONTH,
SUM(DAY(C11)) AS C11_SUM_DAY,
MIN(C11) AS C11_MIN,
MAX(C11) AS C11_MAX,
COUNT(C12) AS C12_COUNT_NOT_NULL,
SUM(YEAR(C12)) AS C12_SUM_YEAR,
SUM(MONTH(C12)) AS C12_SUM_MONTH,
SUM(DAY(C12)) AS C12_SUM_DAY,
MIN(C12) AS C12_MIN,
MAX(C12) AS C12_MAX FROM src_dt where 1 = 1
Ln:2 Query 2: SELECT COUNT(1) AS row_count,
COUNT(C1) AS C1_COUNT_NOT_NULL,
SUM(LENGTH(C1)) AS C1_SUM_LENGTH,
MIN(LENGTH(C1)) AS C1_MIN_LENGTH,
MAX(LENGTH(C1)) AS C1_MAX_LENGTH,
COUNT(C2) AS C2_COUNT_NOT_NULL,
SUM(LENGTH(C2)) AS C2_SUM_LENGTH,
MIN(LENGTH(C2)) AS C2_MIN_LENGTH,
MAX(LENGTH(C2)) AS C2_MAX_LENGTH,
COUNT(C3) AS C3_COUNT_NOT_NULL,
SUM(LENGTH(C3)) AS C3_SUM_LENGTH,
MIN(LENGTH(C3)) AS C3_MIN_LENGTH,
MAX(LENGTH(C3)) AS C3_MAX_LENGTH,
COUNT(C4) AS C4_COUNT_NOT_NULL,
SUM(C4) AS C4_SUM,
MIN(C4) AS C4_MIN,
MAX(C4) AS C4_MAX,
COUNT(C5) AS C5_COUNT_NOT_NULL,
SUM(C5) AS C5_SUM,
MIN(C5) AS C5_MIN,
MAX(C5) AS C5_MAX,
COUNT(C6) AS C6_COUNT_NOT_NULL,
SUM(C6) AS C6_SUM,
MIN(C6) AS C6_MIN,
MAX(C6) AS C6_MAX,
COUNT(C7) AS C7_COUNT_NOT_NULL,
SUM(C7) AS C7_SUM,
MIN(C7) AS C7_MIN,
MAX(C7) AS C7_MAX,
COUNT(C8) AS C8_COUNT_NOT_NULL,
SUM(C8) AS C8_SUM,
MIN(C8) AS C8_MIN,
MAX(C8) AS C8_MAX,
COUNT(C9) AS C9_COUNT_NOT_NULL,
SUM(C9) AS C9_SUM,
MIN(C9) AS C9_MIN,
MAX(C9) AS C9_MAX,
COUNT(C10) AS C10_COUNT_NOT_NULL,
SUM(C10) AS C10_SUM,
MIN(C10) AS C10_MIN,
MAX(C10) AS C10_MAX,
COUNT(C11) AS C11_COUNT_NOT_NULL,
SUM(YEAR(C11)) AS C11_SUM_YEAR,
SUM(MONTH(C11)) AS C11_SUM_MONTH,
SUM(DAY(C11)) AS C11_SUM_DAY,
MIN(C11) AS C11_MIN,
MAX(C11) AS C11_MAX,
COUNT(C12) AS C12_COUNT_NOT_NULL,
SUM(YEAR(C12)) AS C12_SUM_YEAR,
SUM(MONTH(C12)) AS C12_SUM_MONTH,
SUM(DAY(C12)) AS C12_SUM_DAY,
MIN(C12) AS C12_MIN,
MAX(C12) AS C12_MAX FROM src_dt
row_count	500	500
c1_count_not_null	500	500
c1_sum_length	3406	3406
c1_min_length	5	5
c1_max_length	7	7
c2_count_not_null	500	500
c2_sum_length	3406	3406
c2_min_length	5	5
c2_max_length	7	7
c3_count_not_null	500	500
c3_sum_length	3406	3406
c3_min_length	5	5
c3_max_length	7	7
c4_count_not_null	106	106
c4_sum	6697	6697
c4_min	0	0
c4_max	126	126
c5_count_not_null	500	500
c5_sum	130091	130091
c5_min	0	0
c5_max	498	498
c6_count_not_null	500	500
c6_sum	130091	130091
c6_min	0	0
c6_max	498	498
c7_count_not_null	500	500
c7_sum	130091	130091
c7_min	0	0
c7_max	498	498
c8_count_not_null	500	500
c8_sum	13009.1	13009.1
c8_min	0	0
c8_max	49.8	49.8
c9_count_not_null	500	500
c9_sum	13009.10001783073	13009.10001783073
c9_min	0.0	0.0
c9_max	49.79999923706055	49.79999923706055
c10_count_not_null	500	500
c10_sum	13009.09999999999	13009.09999999999
c10_min	0.0	0.0
c10_max	49.8	49.8
c11_count_not_null	500	500
c11_sum_year	1007500	1007500
c11_sum_month	4500	4500
c11_sum_day	3500	3500
c11_min	null	null
c11_max	null	null
c12_count_not_null	500	500
c12_sum_year	1007500	1007500
c12_sum_month	4500	4500
c12_sum_day	3500	3500
c12_min	null	null
c12_max	null	null