On Thu, Sep 22, 2011 at 1:37 PM, neelakanta reddy < reddy.neelaka...@gmail.com> wrote:
> 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); > INSERT INTO "objects" VALUES(1313,111,'fmAlarmModelId=CW,fmId=1',0); > > > The following entries pointed by the arrow are duplicated. > Where are they duplicated? The output you provide does not show any duplicates (all have a unique 3rd column value). ... > Here the dn name is unique but still i am seeing duplicate dn names. > Please show us the duplicates. i don't see any dupes in your inserts and you didn't present any SELECT data which shows duplicates. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users