Fwd: Why would a query work on one machine but not another?

The query deletes the one of each pair of duplicate keyed rows that has the greater ROWID. Art On Thu, Nov 20, 2008 at 12:07 PM, TBP <theBP@usenet-news.net> wrote: > JaxenT wrote: > > I have an install of 11.5 in production and one in development. The > > installs should be the same, except one machine is fedora and the > > other is debian. On one box I my query works on the other I get a > > -360 error "Cannot modify table or view used in subquery." I am > > deleting duplicate rows with: > > > > DELETE FROM table > > WHERE rowid IN( > > SELECT fs1.rowid > > FROM table fs1, table fs2 > > WHERE fs1.serial_num = fs2.serial_num > > AND fs1.rowid > fs2.rowid)> > > > > > I know the other tricks to do the job, but I just am curious why this > > works on one machine and fail on the other? > > Interesting ... > > So, same schema and data makes one wonder. > > dbschema -ss of the two tables from the Prod and the Dev environment.> > Are you using PDQ? Multiple temporary dbspaces? Fragmentation? > > What about the sqexplain?? > > rowids are also a bit of a "vague area", and not really sure for what > purpose the above query would be serving as rowids are not > really involved in a relationship model. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.