here the Duplication means the object table obj_id which is a primary key i
duplicated twice
Here my question is for primary key (obj_id) , we are getting two entries
for the same primary id which must be unique
since the database is large i am pasting the db bump output
CREATE TABLE objects (obj_id integer primary key, class_id integer, dn text,
last_ccb integer);
INSERT INTO "objects"
VALUES(1,127,'APG43L_DDISKPATH=ACS_ACA_DATA,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(2,127,'APG43L_DDISKPATH=ACS_ALEC_DATA,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(3,127,'APG43L_DDISKPATH=ACS_CHB_DATA,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(4,127,'APG43L_DDISKPATH=ACS_DATA,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(5,127,'APG43L_DDISKPATH=ACS_DATA_BASE,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(6,127,'APG43L_DDISKPATH=ACS_LOGS,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(7,127,'APG43L_DDISKPATH=ACS_LOGS_BASE,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(8,127,'APG43L_DDISKPATH=ACS_MTZ_DATA,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(9,127,'APG43L_DDISKPATH=ACS_RTR_DATA,safApp=safImmService',0);
|
|
|
INSERT INTO "objects"
VALUES(1304,155,'entryId=6,tableId=CPIdTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1305,155,'entryId=6,tableId=HWCTable,CSId=1',0);
INSERT INTO "objects" VALUES(1306,155,'entryId=6,tableId=NETable,CSId=1',0);
INSERT INTO "objects"
VALUES(1307,155,'entryId=60,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1308,155,'entryId=61,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1309,155,'entryId=62,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1310,155,'entryId=63,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1311,155,'entryId=64,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1312,155,'entryId=65,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1313,155,'entryId=66,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1314,155,'entryId=67,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1315,155,'entryId=68,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1309,155,'entryId=99,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1310,118,'externalMediaFunctionMId=1,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(1311,115,'fileOutputId=1,statisticalCounterMId=1,safApp=safImmService',0);
INSERT INTO "objects"
VALUES(1312,114,'filterId=1,ldapId=1,ldapAuthenticationMethodId=1',0);
Here the obj_id which is primary is having duplicate primary value entries
INSERT INTO "objects"
VALUES(1309,155,'entryId=62,tableId=CPGMembersTable,CSId=1',0);
INSERT INTO "objects"
VALUES(1309,155,'entryId=99,tableId=CPGMembersTable,CSId=1',0);
can some one please tell me why the primary key is coming twice
-Neel.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
