Default SQL and Delete mode
Posted 15 September 2004 - 12:04 AM
If you have default SQL selecting records, and have a LU that has the file in Delete mode, and no logics anywhere on any of the file logic points, then all the records in the file are delete.
It does not follow the select you make in the default SQL.
Kernel Version: 5.5r323
Posted 15 September 2004 - 10:50 AM
Nope, 'Confirmed' means that I have checked it myself.
Its more relavant for bugs posted form others.
I dont have the partial flag set.
Not tried it in a screen, this test was in an update.
Posted 16 September 2004 - 09:34 AM
I'd actually guess this could apply to any SQL database. From your description it would seem to be an issue with ProIV's "bulk delete" optimization - where there's a single file in delete mode with no logic I think ProIV tries to bypass the usual timing cycle and issue a single SQL DELETE for all the rows.
I guess maybe that can't work with explicit SQL because ProIV can't analyze your SELECT and morph it into the WHERE clause needed for the DELETE. This is kind of understandable but, if I'm guessing right, ProIV shouldn't be seeking to apply the "bulk delete" optimization where there is an explicit SELECT - that's the bug.
From your point of view you'd therefore probably get better performance by coding the DELETE statement directly and avoiding the whole problem.
Of course, this is all speculation..
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users