Fwd: Why would a query work on one machine but not another?
Posted in 2008
Topics: Performance & Tuning, Installation, Setup & Upgrades, Storage & Space Management, SQL Development & Query Writing
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.