Menu

#259 Successive UPDATEs using WHERE CURRENT OF does not work

Development Queue
open
5
2013-06-12
2011-12-20
Abbas Butt
No

Successive UPDATEs using WHERE CURRENT OF or a DELETE followed by an UPDATE does not work because the first UPDATE changes the ctid.
This limitation can be solved using UPDATE/DELETE RETURNING ctid, however RETURNING is not yet supported in XC.
The test case involved here is portals.sql
There are a number of test cases failing in portals.sql because of this limitation.

Discussion

  • Abbas Butt

    Abbas Butt - 2012-03-06
    • milestone: --> 2663467
     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • assigned_to: nobody --> gabbasb
     
  • Koichi Suzuki

    Koichi Suzuki - 2012-09-12

    Q2, part of WHERE CURRENT OF work.

     
  • Koichi Suzuki

    Koichi Suzuki - 2013-03-12
    • milestone: 2663467 --> 5139567
     
  • Koichi Suzuki

    Koichi Suzuki - 2013-06-12
    • milestone: 5139567 --> Development Queue
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.