http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/core/EXPECTED162 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED162 b/core/sql/regress/core/EXPECTED162 index 20fa63f..82da1bc 100644 --- a/core/sql/regress/core/EXPECTED162 +++ b/core/sql/regress/core/EXPECTED162 @@ -1157,21 +1157,21 @@ T_TIME >> >>select * from store ; -S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE ------------ -------------------- -------------------------- -------------------------- ---------------- -------------------- ------------------ ------------- -------------------- -------------------- ----------- -------------------- -------------------- -------------------- ------------- -------------------- ------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------- ---------------- +S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE +----------- -------------------- ----------------------------- ----------------------------- ---------------- -------------------- ------------------ ------------- -------------------- -------------------- ----------- -------------------- -------------------- -------------------- ------------- -------------------- ------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------- ---------------- - 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas st Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candid David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arm David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 - 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 - 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make mo Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 - 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychologica Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 - 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 - 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 - 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas st Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candid David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arm David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 + 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make mo Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 + 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychologica Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 + 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 + 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 + 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 --- 12 row(s) selected. >> @@ -1179,374 +1179,374 @@ S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE *** WARNING[6008] Statistics for column (D_DATE) from table HIVE.HIVE.DATE_DIM were not available. As a result, the access path chosen might not be the best possible. -D_DATE --------------------------- +D_DATE +----------------------------- -2099-01-02 00:00:00.000000 -2099-01-03 00:00:00.000000 -2099-01-04 00:00:00.000000 -2099-01-05 00:00:00.000000 -2099-01-06 00:00:00.000000 -2099-01-07 00:00:00.000000 -2099-01-08 00:00:00.000000 -2099-01-09 00:00:00.000000 -2099-01-10 00:00:00.000000 -2099-01-11 00:00:00.000000 -2099-01-12 00:00:00.000000 -2099-01-13 00:00:00.000000 -2099-01-14 00:00:00.000000 -2099-01-15 00:00:00.000000 -2099-01-16 00:00:00.000000 -2099-01-17 00:00:00.000000 -2099-01-18 00:00:00.000000 -2099-01-19 00:00:00.000000 -2099-01-20 00:00:00.000000 -2099-01-21 00:00:00.000000 -2099-01-22 00:00:00.000000 -2099-01-23 00:00:00.000000 -2099-01-24 00:00:00.000000 -2099-01-25 00:00:00.000000 -2099-01-26 00:00:00.000000 -2099-01-27 00:00:00.000000 -2099-01-28 00:00:00.000000 -2099-01-29 00:00:00.000000 -2099-01-30 00:00:00.000000 -2099-01-31 00:00:00.000000 -2099-02-01 00:00:00.000000 -2099-02-02 00:00:00.000000 -2099-02-03 00:00:00.000000 -2099-02-04 00:00:00.000000 -2099-02-05 00:00:00.000000 -2099-02-06 00:00:00.000000 -2099-02-07 00:00:00.000000 -2099-02-08 00:00:00.000000 -2099-02-09 00:00:00.000000 -2099-02-10 00:00:00.000000 -2099-02-11 00:00:00.000000 -2099-02-12 00:00:00.000000 -2099-02-13 00:00:00.000000 -2099-02-14 00:00:00.000000 -2099-02-15 00:00:00.000000 -2099-02-16 00:00:00.000000 -2099-02-17 00:00:00.000000 -2099-02-18 00:00:00.000000 -2099-02-19 00:00:00.000000 -2099-02-20 00:00:00.000000 -2099-02-21 00:00:00.000000 -2099-02-22 00:00:00.000000 -2099-02-23 00:00:00.000000 -2099-02-24 00:00:00.000000 -2099-02-25 00:00:00.000000 -2099-02-26 00:00:00.000000 -2099-02-27 00:00:00.000000 -2099-02-28 00:00:00.000000 -2099-03-01 00:00:00.000000 -2099-03-02 00:00:00.000000 -2099-03-03 00:00:00.000000 -2099-03-04 00:00:00.000000 -2099-03-05 00:00:00.000000 -2099-03-06 00:00:00.000000 -2099-03-07 00:00:00.000000 -2099-03-08 00:00:00.000000 -2099-03-09 00:00:00.000000 -2099-03-10 00:00:00.000000 -2099-03-11 00:00:00.000000 -2099-03-12 00:00:00.000000 -2099-03-13 00:00:00.000000 -2099-03-14 00:00:00.000000 -2099-03-15 00:00:00.000000 -2099-03-16 00:00:00.000000 -2099-03-17 00:00:00.000000 -2099-03-18 00:00:00.000000 -2099-03-19 00:00:00.000000 -2099-03-20 00:00:00.000000 -2099-03-21 00:00:00.000000 -2099-03-22 00:00:00.000000 -2099-03-23 00:00:00.000000 -2099-03-24 00:00:00.000000 -2099-03-25 00:00:00.000000 -2099-03-26 00:00:00.000000 -2099-03-27 00:00:00.000000 -2099-03-28 00:00:00.000000 -2099-03-29 00:00:00.000000 -2099-03-30 00:00:00.000000 -2099-03-31 00:00:00.000000 -2099-04-01 00:00:00.000000 -2099-04-02 00:00:00.000000 -2099-04-03 00:00:00.000000 -2099-04-04 00:00:00.000000 -2099-04-05 00:00:00.000000 -2099-04-06 00:00:00.000000 -2099-04-07 00:00:00.000000 -2099-04-08 00:00:00.000000 -2099-04-09 00:00:00.000000 -2099-04-10 00:00:00.000000 -2099-04-11 00:00:00.000000 -2099-04-12 00:00:00.000000 -2099-04-13 00:00:00.000000 -2099-04-14 00:00:00.000000 -2099-04-15 00:00:00.000000 -2099-04-16 00:00:00.000000 -2099-04-17 00:00:00.000000 -2099-04-18 00:00:00.000000 -2099-04-19 00:00:00.000000 -2099-04-20 00:00:00.000000 -2099-04-21 00:00:00.000000 -2099-04-22 00:00:00.000000 -2099-04-23 00:00:00.000000 -2099-04-24 00:00:00.000000 -2099-04-25 00:00:00.000000 -2099-04-26 00:00:00.000000 -2099-04-27 00:00:00.000000 -2099-04-28 00:00:00.000000 -2099-04-29 00:00:00.000000 -2099-04-30 00:00:00.000000 -2099-05-01 00:00:00.000000 -2099-05-02 00:00:00.000000 -2099-05-03 00:00:00.000000 -2099-05-04 00:00:00.000000 -2099-05-05 00:00:00.000000 -2099-05-06 00:00:00.000000 -2099-05-07 00:00:00.000000 -2099-05-08 00:00:00.000000 -2099-05-09 00:00:00.000000 -2099-05-10 00:00:00.000000 -2099-05-11 00:00:00.000000 -2099-05-12 00:00:00.000000 -2099-05-13 00:00:00.000000 -2099-05-14 00:00:00.000000 -2099-05-15 00:00:00.000000 -2099-05-16 00:00:00.000000 -2099-05-17 00:00:00.000000 -2099-05-18 00:00:00.000000 -2099-05-19 00:00:00.000000 -2099-05-20 00:00:00.000000 -2099-05-21 00:00:00.000000 -2099-05-22 00:00:00.000000 -2099-05-23 00:00:00.000000 -2099-05-24 00:00:00.000000 -2099-05-25 00:00:00.000000 -2099-05-26 00:00:00.000000 -2099-05-27 00:00:00.000000 -2099-05-28 00:00:00.000000 -2099-05-29 00:00:00.000000 -2099-05-30 00:00:00.000000 -2099-05-31 00:00:00.000000 -2099-06-01 00:00:00.000000 -2099-06-02 00:00:00.000000 -2099-06-03 00:00:00.000000 -2099-06-04 00:00:00.000000 -2099-06-05 00:00:00.000000 -2099-06-06 00:00:00.000000 -2099-06-07 00:00:00.000000 -2099-06-08 00:00:00.000000 -2099-06-09 00:00:00.000000 -2099-06-10 00:00:00.000000 -2099-06-11 00:00:00.000000 -2099-06-12 00:00:00.000000 -2099-06-13 00:00:00.000000 -2099-06-14 00:00:00.000000 -2099-06-15 00:00:00.000000 -2099-06-16 00:00:00.000000 -2099-06-17 00:00:00.000000 -2099-06-18 00:00:00.000000 -2099-06-19 00:00:00.000000 -2099-06-20 00:00:00.000000 -2099-06-21 00:00:00.000000 -2099-06-22 00:00:00.000000 -2099-06-23 00:00:00.000000 -2099-06-24 00:00:00.000000 -2099-06-25 00:00:00.000000 -2099-06-26 00:00:00.000000 -2099-06-27 00:00:00.000000 -2099-06-28 00:00:00.000000 -2099-06-29 00:00:00.000000 -2099-06-30 00:00:00.000000 -2099-07-01 00:00:00.000000 -2099-07-02 00:00:00.000000 -2099-07-03 00:00:00.000000 -2099-07-04 00:00:00.000000 -2099-07-05 00:00:00.000000 -2099-07-06 00:00:00.000000 -2099-07-07 00:00:00.000000 -2099-07-08 00:00:00.000000 -2099-07-09 00:00:00.000000 -2099-07-10 00:00:00.000000 -2099-07-11 00:00:00.000000 -2099-07-12 00:00:00.000000 -2099-07-13 00:00:00.000000 -2099-07-14 00:00:00.000000 -2099-07-15 00:00:00.000000 -2099-07-16 00:00:00.000000 -2099-07-17 00:00:00.000000 -2099-07-18 00:00:00.000000 -2099-07-19 00:00:00.000000 -2099-07-20 00:00:00.000000 -2099-07-21 00:00:00.000000 -2099-07-22 00:00:00.000000 -2099-07-23 00:00:00.000000 -2099-07-24 00:00:00.000000 -2099-07-25 00:00:00.000000 -2099-07-26 00:00:00.000000 -2099-07-27 00:00:00.000000 -2099-07-28 00:00:00.000000 -2099-07-29 00:00:00.000000 -2099-07-30 00:00:00.000000 -2099-07-31 00:00:00.000000 -2099-08-01 00:00:00.000000 -2099-08-02 00:00:00.000000 -2099-08-03 00:00:00.000000 -2099-08-04 00:00:00.000000 -2099-08-05 00:00:00.000000 -2099-08-06 00:00:00.000000 -2099-08-07 00:00:00.000000 -2099-08-08 00:00:00.000000 -2099-08-09 00:00:00.000000 -2099-08-10 00:00:00.000000 -2099-08-11 00:00:00.000000 -2099-08-12 00:00:00.000000 -2099-08-13 00:00:00.000000 -2099-08-14 00:00:00.000000 -2099-08-15 00:00:00.000000 -2099-08-16 00:00:00.000000 -2099-08-17 00:00:00.000000 -2099-08-18 00:00:00.000000 -2099-08-19 00:00:00.000000 -2099-08-20 00:00:00.000000 -2099-08-21 00:00:00.000000 -2099-08-22 00:00:00.000000 -2099-08-23 00:00:00.000000 -2099-08-24 00:00:00.000000 -2099-08-25 00:00:00.000000 -2099-08-26 00:00:00.000000 -2099-08-27 00:00:00.000000 -2099-08-28 00:00:00.000000 -2099-08-29 00:00:00.000000 -2099-08-30 00:00:00.000000 -2099-08-31 00:00:00.000000 -2099-09-01 00:00:00.000000 -2099-09-02 00:00:00.000000 -2099-09-03 00:00:00.000000 -2099-09-04 00:00:00.000000 -2099-09-05 00:00:00.000000 -2099-09-06 00:00:00.000000 -2099-09-07 00:00:00.000000 -2099-09-08 00:00:00.000000 -2099-09-09 00:00:00.000000 -2099-09-10 00:00:00.000000 -2099-09-11 00:00:00.000000 -2099-09-12 00:00:00.000000 -2099-09-13 00:00:00.000000 -2099-09-14 00:00:00.000000 -2099-09-15 00:00:00.000000 -2099-09-16 00:00:00.000000 -2099-09-17 00:00:00.000000 -2099-09-18 00:00:00.000000 -2099-09-19 00:00:00.000000 -2099-09-20 00:00:00.000000 -2099-09-21 00:00:00.000000 -2099-09-22 00:00:00.000000 -2099-09-23 00:00:00.000000 -2099-09-24 00:00:00.000000 -2099-09-25 00:00:00.000000 -2099-09-26 00:00:00.000000 -2099-09-27 00:00:00.000000 -2099-09-28 00:00:00.000000 -2099-09-29 00:00:00.000000 -2099-09-30 00:00:00.000000 -2099-10-01 00:00:00.000000 -2099-10-02 00:00:00.000000 -2099-10-03 00:00:00.000000 -2099-10-04 00:00:00.000000 -2099-10-05 00:00:00.000000 -2099-10-06 00:00:00.000000 -2099-10-07 00:00:00.000000 -2099-10-08 00:00:00.000000 -2099-10-09 00:00:00.000000 -2099-10-10 00:00:00.000000 -2099-10-11 00:00:00.000000 -2099-10-12 00:00:00.000000 -2099-10-13 00:00:00.000000 -2099-10-14 00:00:00.000000 -2099-10-15 00:00:00.000000 -2099-10-16 00:00:00.000000 -2099-10-17 00:00:00.000000 -2099-10-18 00:00:00.000000 -2099-10-19 00:00:00.000000 -2099-10-20 00:00:00.000000 -2099-10-21 00:00:00.000000 -2099-10-22 00:00:00.000000 -2099-10-23 00:00:00.000000 -2099-10-24 00:00:00.000000 -2099-10-25 00:00:00.000000 -2099-10-26 00:00:00.000000 -2099-10-27 00:00:00.000000 -2099-10-28 00:00:00.000000 -2099-10-29 00:00:00.000000 -2099-10-30 00:00:00.000000 -2099-10-31 00:00:00.000000 -2099-11-01 00:00:00.000000 -2099-11-02 00:00:00.000000 -2099-11-03 00:00:00.000000 -2099-11-04 00:00:00.000000 -2099-11-05 00:00:00.000000 -2099-11-06 00:00:00.000000 -2099-11-07 00:00:00.000000 -2099-11-08 00:00:00.000000 -2099-11-09 00:00:00.000000 -2099-11-10 00:00:00.000000 -2099-11-11 00:00:00.000000 -2099-11-12 00:00:00.000000 -2099-11-13 00:00:00.000000 -2099-11-14 00:00:00.000000 -2099-11-15 00:00:00.000000 -2099-11-16 00:00:00.000000 -2099-11-17 00:00:00.000000 -2099-11-18 00:00:00.000000 -2099-11-19 00:00:00.000000 -2099-11-20 00:00:00.000000 -2099-11-21 00:00:00.000000 -2099-11-22 00:00:00.000000 -2099-11-23 00:00:00.000000 -2099-11-24 00:00:00.000000 -2099-11-25 00:00:00.000000 -2099-11-26 00:00:00.000000 -2099-11-27 00:00:00.000000 -2099-11-28 00:00:00.000000 -2099-11-29 00:00:00.000000 -2099-11-30 00:00:00.000000 -2099-12-01 00:00:00.000000 -2099-12-02 00:00:00.000000 -2099-12-03 00:00:00.000000 -2099-12-04 00:00:00.000000 -2099-12-05 00:00:00.000000 -2099-12-06 00:00:00.000000 -2099-12-07 00:00:00.000000 -2099-12-08 00:00:00.000000 -2099-12-09 00:00:00.000000 -2099-12-10 00:00:00.000000 -2099-12-11 00:00:00.000000 -2099-12-12 00:00:00.000000 -2099-12-13 00:00:00.000000 -2099-12-14 00:00:00.000000 -2099-12-15 00:00:00.000000 -2099-12-16 00:00:00.000000 -2099-12-17 00:00:00.000000 -2099-12-18 00:00:00.000000 -2099-12-19 00:00:00.000000 -2099-12-20 00:00:00.000000 -2099-12-21 00:00:00.000000 -2099-12-22 00:00:00.000000 -2099-12-23 00:00:00.000000 -2099-12-24 00:00:00.000000 -2099-12-25 00:00:00.000000 -2099-12-26 00:00:00.000000 -2099-12-27 00:00:00.000000 -2099-12-28 00:00:00.000000 -2099-12-29 00:00:00.000000 -2099-12-30 00:00:00.000000 -2099-12-31 00:00:00.000000 -2100-01-01 00:00:00.000000 +2099-01-02 00:00:00.000000000 +2099-01-03 00:00:00.000000000 +2099-01-04 00:00:00.000000000 +2099-01-05 00:00:00.000000000 +2099-01-06 00:00:00.000000000 +2099-01-07 00:00:00.000000000 +2099-01-08 00:00:00.000000000 +2099-01-09 00:00:00.000000000 +2099-01-10 00:00:00.000000000 +2099-01-11 00:00:00.000000000 +2099-01-12 00:00:00.000000000 +2099-01-13 00:00:00.000000000 +2099-01-14 00:00:00.000000000 +2099-01-15 00:00:00.000000000 +2099-01-16 00:00:00.000000000 +2099-01-17 00:00:00.000000000 +2099-01-18 00:00:00.000000000 +2099-01-19 00:00:00.000000000 +2099-01-20 00:00:00.000000000 +2099-01-21 00:00:00.000000000 +2099-01-22 00:00:00.000000000 +2099-01-23 00:00:00.000000000 +2099-01-24 00:00:00.000000000 +2099-01-25 00:00:00.000000000 +2099-01-26 00:00:00.000000000 +2099-01-27 00:00:00.000000000 +2099-01-28 00:00:00.000000000 +2099-01-29 00:00:00.000000000 +2099-01-30 00:00:00.000000000 +2099-01-31 00:00:00.000000000 +2099-02-01 00:00:00.000000000 +2099-02-02 00:00:00.000000000 +2099-02-03 00:00:00.000000000 +2099-02-04 00:00:00.000000000 +2099-02-05 00:00:00.000000000 +2099-02-06 00:00:00.000000000 +2099-02-07 00:00:00.000000000 +2099-02-08 00:00:00.000000000 +2099-02-09 00:00:00.000000000 +2099-02-10 00:00:00.000000000 +2099-02-11 00:00:00.000000000 +2099-02-12 00:00:00.000000000 +2099-02-13 00:00:00.000000000 +2099-02-14 00:00:00.000000000 +2099-02-15 00:00:00.000000000 +2099-02-16 00:00:00.000000000 +2099-02-17 00:00:00.000000000 +2099-02-18 00:00:00.000000000 +2099-02-19 00:00:00.000000000 +2099-02-20 00:00:00.000000000 +2099-02-21 00:00:00.000000000 +2099-02-22 00:00:00.000000000 +2099-02-23 00:00:00.000000000 +2099-02-24 00:00:00.000000000 +2099-02-25 00:00:00.000000000 +2099-02-26 00:00:00.000000000 +2099-02-27 00:00:00.000000000 +2099-02-28 00:00:00.000000000 +2099-03-01 00:00:00.000000000 +2099-03-02 00:00:00.000000000 +2099-03-03 00:00:00.000000000 +2099-03-04 00:00:00.000000000 +2099-03-05 00:00:00.000000000 +2099-03-06 00:00:00.000000000 +2099-03-07 00:00:00.000000000 +2099-03-08 00:00:00.000000000 +2099-03-09 00:00:00.000000000 +2099-03-10 00:00:00.000000000 +2099-03-11 00:00:00.000000000 +2099-03-12 00:00:00.000000000 +2099-03-13 00:00:00.000000000 +2099-03-14 00:00:00.000000000 +2099-03-15 00:00:00.000000000 +2099-03-16 00:00:00.000000000 +2099-03-17 00:00:00.000000000 +2099-03-18 00:00:00.000000000 +2099-03-19 00:00:00.000000000 +2099-03-20 00:00:00.000000000 +2099-03-21 00:00:00.000000000 +2099-03-22 00:00:00.000000000 +2099-03-23 00:00:00.000000000 +2099-03-24 00:00:00.000000000 +2099-03-25 00:00:00.000000000 +2099-03-26 00:00:00.000000000 +2099-03-27 00:00:00.000000000 +2099-03-28 00:00:00.000000000 +2099-03-29 00:00:00.000000000 +2099-03-30 00:00:00.000000000 +2099-03-31 00:00:00.000000000 +2099-04-01 00:00:00.000000000 +2099-04-02 00:00:00.000000000 +2099-04-03 00:00:00.000000000 +2099-04-04 00:00:00.000000000 +2099-04-05 00:00:00.000000000 +2099-04-06 00:00:00.000000000 +2099-04-07 00:00:00.000000000 +2099-04-08 00:00:00.000000000 +2099-04-09 00:00:00.000000000 +2099-04-10 00:00:00.000000000 +2099-04-11 00:00:00.000000000 +2099-04-12 00:00:00.000000000 +2099-04-13 00:00:00.000000000 +2099-04-14 00:00:00.000000000 +2099-04-15 00:00:00.000000000 +2099-04-16 00:00:00.000000000 +2099-04-17 00:00:00.000000000 +2099-04-18 00:00:00.000000000 +2099-04-19 00:00:00.000000000 +2099-04-20 00:00:00.000000000 +2099-04-21 00:00:00.000000000 +2099-04-22 00:00:00.000000000 +2099-04-23 00:00:00.000000000 +2099-04-24 00:00:00.000000000 +2099-04-25 00:00:00.000000000 +2099-04-26 00:00:00.000000000 +2099-04-27 00:00:00.000000000 +2099-04-28 00:00:00.000000000 +2099-04-29 00:00:00.000000000 +2099-04-30 00:00:00.000000000 +2099-05-01 00:00:00.000000000 +2099-05-02 00:00:00.000000000 +2099-05-03 00:00:00.000000000 +2099-05-04 00:00:00.000000000 +2099-05-05 00:00:00.000000000 +2099-05-06 00:00:00.000000000 +2099-05-07 00:00:00.000000000 +2099-05-08 00:00:00.000000000 +2099-05-09 00:00:00.000000000 +2099-05-10 00:00:00.000000000 +2099-05-11 00:00:00.000000000 +2099-05-12 00:00:00.000000000 +2099-05-13 00:00:00.000000000 +2099-05-14 00:00:00.000000000 +2099-05-15 00:00:00.000000000 +2099-05-16 00:00:00.000000000 +2099-05-17 00:00:00.000000000 +2099-05-18 00:00:00.000000000 +2099-05-19 00:00:00.000000000 +2099-05-20 00:00:00.000000000 +2099-05-21 00:00:00.000000000 +2099-05-22 00:00:00.000000000 +2099-05-23 00:00:00.000000000 +2099-05-24 00:00:00.000000000 +2099-05-25 00:00:00.000000000 +2099-05-26 00:00:00.000000000 +2099-05-27 00:00:00.000000000 +2099-05-28 00:00:00.000000000 +2099-05-29 00:00:00.000000000 +2099-05-30 00:00:00.000000000 +2099-05-31 00:00:00.000000000 +2099-06-01 00:00:00.000000000 +2099-06-02 00:00:00.000000000 +2099-06-03 00:00:00.000000000 +2099-06-04 00:00:00.000000000 +2099-06-05 00:00:00.000000000 +2099-06-06 00:00:00.000000000 +2099-06-07 00:00:00.000000000 +2099-06-08 00:00:00.000000000 +2099-06-09 00:00:00.000000000 +2099-06-10 00:00:00.000000000 +2099-06-11 00:00:00.000000000 +2099-06-12 00:00:00.000000000 +2099-06-13 00:00:00.000000000 +2099-06-14 00:00:00.000000000 +2099-06-15 00:00:00.000000000 +2099-06-16 00:00:00.000000000 +2099-06-17 00:00:00.000000000 +2099-06-18 00:00:00.000000000 +2099-06-19 00:00:00.000000000 +2099-06-20 00:00:00.000000000 +2099-06-21 00:00:00.000000000 +2099-06-22 00:00:00.000000000 +2099-06-23 00:00:00.000000000 +2099-06-24 00:00:00.000000000 +2099-06-25 00:00:00.000000000 +2099-06-26 00:00:00.000000000 +2099-06-27 00:00:00.000000000 +2099-06-28 00:00:00.000000000 +2099-06-29 00:00:00.000000000 +2099-06-30 00:00:00.000000000 +2099-07-01 00:00:00.000000000 +2099-07-02 00:00:00.000000000 +2099-07-03 00:00:00.000000000 +2099-07-04 00:00:00.000000000 +2099-07-05 00:00:00.000000000 +2099-07-06 00:00:00.000000000 +2099-07-07 00:00:00.000000000 +2099-07-08 00:00:00.000000000 +2099-07-09 00:00:00.000000000 +2099-07-10 00:00:00.000000000 +2099-07-11 00:00:00.000000000 +2099-07-12 00:00:00.000000000 +2099-07-13 00:00:00.000000000 +2099-07-14 00:00:00.000000000 +2099-07-15 00:00:00.000000000 +2099-07-16 00:00:00.000000000 +2099-07-17 00:00:00.000000000 +2099-07-18 00:00:00.000000000 +2099-07-19 00:00:00.000000000 +2099-07-20 00:00:00.000000000 +2099-07-21 00:00:00.000000000 +2099-07-22 00:00:00.000000000 +2099-07-23 00:00:00.000000000 +2099-07-24 00:00:00.000000000 +2099-07-25 00:00:00.000000000 +2099-07-26 00:00:00.000000000 +2099-07-27 00:00:00.000000000 +2099-07-28 00:00:00.000000000 +2099-07-29 00:00:00.000000000 +2099-07-30 00:00:00.000000000 +2099-07-31 00:00:00.000000000 +2099-08-01 00:00:00.000000000 +2099-08-02 00:00:00.000000000 +2099-08-03 00:00:00.000000000 +2099-08-04 00:00:00.000000000 +2099-08-05 00:00:00.000000000 +2099-08-06 00:00:00.000000000 +2099-08-07 00:00:00.000000000 +2099-08-08 00:00:00.000000000 +2099-08-09 00:00:00.000000000 +2099-08-10 00:00:00.000000000 +2099-08-11 00:00:00.000000000 +2099-08-12 00:00:00.000000000 +2099-08-13 00:00:00.000000000 +2099-08-14 00:00:00.000000000 +2099-08-15 00:00:00.000000000 +2099-08-16 00:00:00.000000000 +2099-08-17 00:00:00.000000000 +2099-08-18 00:00:00.000000000 +2099-08-19 00:00:00.000000000 +2099-08-20 00:00:00.000000000 +2099-08-21 00:00:00.000000000 +2099-08-22 00:00:00.000000000 +2099-08-23 00:00:00.000000000 +2099-08-24 00:00:00.000000000 +2099-08-25 00:00:00.000000000 +2099-08-26 00:00:00.000000000 +2099-08-27 00:00:00.000000000 +2099-08-28 00:00:00.000000000 +2099-08-29 00:00:00.000000000 +2099-08-30 00:00:00.000000000 +2099-08-31 00:00:00.000000000 +2099-09-01 00:00:00.000000000 +2099-09-02 00:00:00.000000000 +2099-09-03 00:00:00.000000000 +2099-09-04 00:00:00.000000000 +2099-09-05 00:00:00.000000000 +2099-09-06 00:00:00.000000000 +2099-09-07 00:00:00.000000000 +2099-09-08 00:00:00.000000000 +2099-09-09 00:00:00.000000000 +2099-09-10 00:00:00.000000000 +2099-09-11 00:00:00.000000000 +2099-09-12 00:00:00.000000000 +2099-09-13 00:00:00.000000000 +2099-09-14 00:00:00.000000000 +2099-09-15 00:00:00.000000000 +2099-09-16 00:00:00.000000000 +2099-09-17 00:00:00.000000000 +2099-09-18 00:00:00.000000000 +2099-09-19 00:00:00.000000000 +2099-09-20 00:00:00.000000000 +2099-09-21 00:00:00.000000000 +2099-09-22 00:00:00.000000000 +2099-09-23 00:00:00.000000000 +2099-09-24 00:00:00.000000000 +2099-09-25 00:00:00.000000000 +2099-09-26 00:00:00.000000000 +2099-09-27 00:00:00.000000000 +2099-09-28 00:00:00.000000000 +2099-09-29 00:00:00.000000000 +2099-09-30 00:00:00.000000000 +2099-10-01 00:00:00.000000000 +2099-10-02 00:00:00.000000000 +2099-10-03 00:00:00.000000000 +2099-10-04 00:00:00.000000000 +2099-10-05 00:00:00.000000000 +2099-10-06 00:00:00.000000000 +2099-10-07 00:00:00.000000000 +2099-10-08 00:00:00.000000000 +2099-10-09 00:00:00.000000000 +2099-10-10 00:00:00.000000000 +2099-10-11 00:00:00.000000000 +2099-10-12 00:00:00.000000000 +2099-10-13 00:00:00.000000000 +2099-10-14 00:00:00.000000000 +2099-10-15 00:00:00.000000000 +2099-10-16 00:00:00.000000000 +2099-10-17 00:00:00.000000000 +2099-10-18 00:00:00.000000000 +2099-10-19 00:00:00.000000000 +2099-10-20 00:00:00.000000000 +2099-10-21 00:00:00.000000000 +2099-10-22 00:00:00.000000000 +2099-10-23 00:00:00.000000000 +2099-10-24 00:00:00.000000000 +2099-10-25 00:00:00.000000000 +2099-10-26 00:00:00.000000000 +2099-10-27 00:00:00.000000000 +2099-10-28 00:00:00.000000000 +2099-10-29 00:00:00.000000000 +2099-10-30 00:00:00.000000000 +2099-10-31 00:00:00.000000000 +2099-11-01 00:00:00.000000000 +2099-11-02 00:00:00.000000000 +2099-11-03 00:00:00.000000000 +2099-11-04 00:00:00.000000000 +2099-11-05 00:00:00.000000000 +2099-11-06 00:00:00.000000000 +2099-11-07 00:00:00.000000000 +2099-11-08 00:00:00.000000000 +2099-11-09 00:00:00.000000000 +2099-11-10 00:00:00.000000000 +2099-11-11 00:00:00.000000000 +2099-11-12 00:00:00.000000000 +2099-11-13 00:00:00.000000000 +2099-11-14 00:00:00.000000000 +2099-11-15 00:00:00.000000000 +2099-11-16 00:00:00.000000000 +2099-11-17 00:00:00.000000000 +2099-11-18 00:00:00.000000000 +2099-11-19 00:00:00.000000000 +2099-11-20 00:00:00.000000000 +2099-11-21 00:00:00.000000000 +2099-11-22 00:00:00.000000000 +2099-11-23 00:00:00.000000000 +2099-11-24 00:00:00.000000000 +2099-11-25 00:00:00.000000000 +2099-11-26 00:00:00.000000000 +2099-11-27 00:00:00.000000000 +2099-11-28 00:00:00.000000000 +2099-11-29 00:00:00.000000000 +2099-11-30 00:00:00.000000000 +2099-12-01 00:00:00.000000000 +2099-12-02 00:00:00.000000000 +2099-12-03 00:00:00.000000000 +2099-12-04 00:00:00.000000000 +2099-12-05 00:00:00.000000000 +2099-12-06 00:00:00.000000000 +2099-12-07 00:00:00.000000000 +2099-12-08 00:00:00.000000000 +2099-12-09 00:00:00.000000000 +2099-12-10 00:00:00.000000000 +2099-12-11 00:00:00.000000000 +2099-12-12 00:00:00.000000000 +2099-12-13 00:00:00.000000000 +2099-12-14 00:00:00.000000000 +2099-12-15 00:00:00.000000000 +2099-12-16 00:00:00.000000000 +2099-12-17 00:00:00.000000000 +2099-12-18 00:00:00.000000000 +2099-12-19 00:00:00.000000000 +2099-12-20 00:00:00.000000000 +2099-12-21 00:00:00.000000000 +2099-12-22 00:00:00.000000000 +2099-12-23 00:00:00.000000000 +2099-12-24 00:00:00.000000000 +2099-12-25 00:00:00.000000000 +2099-12-26 00:00:00.000000000 +2099-12-27 00:00:00.000000000 +2099-12-28 00:00:00.000000000 +2099-12-29 00:00:00.000000000 +2099-12-30 00:00:00.000000000 +2099-12-31 00:00:00.000000000 +2100-01-01 00:00:00.000000000 --- 365 row(s) selected. >>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/core/TEST038 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/TEST038 b/core/sql/regress/core/TEST038 index ea540af..36e988f 100755 --- a/core/sql/regress/core/TEST038 +++ b/core/sql/regress/core/TEST038 @@ -1260,7 +1260,7 @@ drop table t038aqr; drop table T038a; drop table T038b; drop table T038c; -drop table T038d; +drop table T038d cascade; drop table T038e; drop table T038f; drop table T038g;
