R
RD
This is odd:
I have an ODBC connection to an Oracle db. In this one table I see that almost
every single record is duplicated resulting in nearly half a million rows. I
thought I'd run a SELECT DISTINCT query against it so I could work with a
smaller pool of records. No dice. I still see two records but two of the
fields have "magically" changed data!
There are 33 fields but I'll just demo with the first 4 as all the fields
contain duplicate data (both before and after DISTINCT). The first 4 fields
are: ID, ADR_TYP_ID, EFF_BGN_DT and ADR_TYP_CD. Before DISTINCT these fields
are duplicated. After DISTINCT, ADR_TYP_ID and ADR_TYP_CD get changed in one of
the records! I have never seen this before.
ID ADR_TYP_ID EFF_BGN_DT ADR_TYP_CD
1183 1870 11/30/1998 HA
1183 1870 11/30/1998 HA
After DISTINCT
ID ADR_TYP_ID EFF_BGN_DT ADR_TYP_CD
1183 1870 11/30/1998 HA
1183 1871 11/30/1998 ML
BTW ... DISTINCTROW returns fully duplicated records exactly as they appear in
the table.
Anyone else ever see this? Knows what might cause it? How to fix it?
Thanks for any help,
RD
I have an ODBC connection to an Oracle db. In this one table I see that almost
every single record is duplicated resulting in nearly half a million rows. I
thought I'd run a SELECT DISTINCT query against it so I could work with a
smaller pool of records. No dice. I still see two records but two of the
fields have "magically" changed data!
There are 33 fields but I'll just demo with the first 4 as all the fields
contain duplicate data (both before and after DISTINCT). The first 4 fields
are: ID, ADR_TYP_ID, EFF_BGN_DT and ADR_TYP_CD. Before DISTINCT these fields
are duplicated. After DISTINCT, ADR_TYP_ID and ADR_TYP_CD get changed in one of
the records! I have never seen this before.
ID ADR_TYP_ID EFF_BGN_DT ADR_TYP_CD
1183 1870 11/30/1998 HA
1183 1870 11/30/1998 HA
After DISTINCT
ID ADR_TYP_ID EFF_BGN_DT ADR_TYP_CD
1183 1870 11/30/1998 HA
1183 1871 11/30/1998 ML
BTW ... DISTINCTROW returns fully duplicated records exactly as they appear in
the table.
Anyone else ever see this? Knows what might cause it? How to fix it?
Thanks for any help,
RD