Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comparison fields validation throws OSError "Invalid argument" #1386

Open
nj1973 opened this issue Jan 6, 2025 · 0 comments · May be fixed by #1392
Open

Comparison fields validation throws OSError "Invalid argument" #1386

nj1973 opened this issue Jan 6, 2025 · 0 comments · May be fixed by #1392
Assignees
Labels
type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

Comments

@nj1973
Copy link
Contributor

nj1973 commented Jan 6, 2025

Test case (using Oracle):

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

@nj1973 nj1973 added the type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns. label Jan 6, 2025
@nj1973 nj1973 self-assigned this Jan 6, 2025
@nj1973 nj1973 linked a pull request Jan 10, 2025 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant