When you run it in the Editor, are you using F5 (execute as script) or F9?
From: lob_36979 [mailto:email@example.com]
Sent: Wednesday, July 20, 2016 10:48 AM
Subject: [Toad for Oracle - Discussion Forum] same query misses small number of records when run in Automation Designer
same query misses small number of records when run in Automation Designer
Thread created by lob_36979
I have a query that returns 117089 records when run in the Editor, but only 117012 when the query is pasted into Automation Designer > Export Dataset > Action Properties.
Some of the 83 missing records are the newest, but not all. None of the fields in the missing rows exceed the limits set in Data Masking. I suspect Data Masking might be the culprit here.
It’s a simple query
select ROW_ID, PAR_ROW_ID, LOGIN from siebel.s_user;
ROW_ID is primary key, no dups. The only difference between the Automation Designer and Editor versions is the semi-colon.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General Forum notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.