You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
drop table dvt_test.tab_1386;
create table dvt_test.tab_1386 (id number(5) primary key, col_date date, col_ts1 timestamp(0), col_ts2 timestamp(0));
-- Extreme date.
insert into dvt_test.tab_1386 values (0,date'9999-12-31',date'9999-12-31',timestamp'9999-12-31 23:59:59');
-- Mildly extreme date.
insert into dvt_test.tab_1386 values (1,date'3000-01-01',date'3000-01-01',timestamp'3000-01-01 23:59:59');
-- Unix epoch sometimes cuases issues.
insert into dvt_test.tab_1386 values (2,date'1970-01-01',date'1970-01-01',timestamp'1970-01-01 23:59:59');
insert into dvt_test.tab_1386 values (3,date'1000-01-01',date'1000-01-01',timestamp'1000-01-01 23:59:59');
-- Extreme date.
insert into dvt_test.tab_1386 values (4,date'0001-01-01',date'0001-01-01',timestamp'0001-01-01 23:59:59');
-- Customer reported potential problem dates.
insert into dvt_test.tab_1386 values (5,date'1111-02-01',date'1111-02-01',timestamp'1111-02-01 23:59:59');
insert into dvt_test.tab_1386 values (6,date'2103-03-01',date'2103-03-01',timestamp'2103-03-01 23:59:59');
-- This date because Oracle skips it.
insert into dvt_test.tab_1386 values (7,date'1582-10-14',date'1582-10-14',timestamp'1582-10-14 23:59:59');
commit;
Test command:
data-validation validate row -sc ora -tc ora --tables-list=dvt_test.tab_1386 -comp-fields="*"
...
?
I am not able to reproduce the error that was reported to me. I've asked for a retest on a recent version of DVT. I suspect this was already fixed by #1208
The text was updated successfully, but these errors were encountered:
nj1973
added
the
type: bug
Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
label
Jan 6, 2025
Test case (using Oracle):
Test command:
I am not able to reproduce the error that was reported to me. I've asked for a retest on a recent version of DVT. I suspect this was already fixed by #1208
The text was updated successfully, but these errors were encountered: