[Info-ingres] Database procedure for loops and commit/rollback

[Martin Bowes]

Hi Everyone,

I've attached a simple shell script. To execute it do this:

1.       createdb dummydb

2.       weird.sh dummydb

I'd be appreciative if people could try this out on different platforms and let me know what ingres version they do it on.

What I see on II 11.0.0 (a64.lnx/100) +p15330 is this:

execute procedure trial_loop;
Executing . . .

MESSAGE 0: [1] for refresh_id = 1, snapshot_id = 100
MESSAGE 0: Cool to commit
MESSAGE 0: Summary: Encountered 1. Updated 1, Failed 0
E_US11FD The cursor is not currently positioned on a row.
    (Fri Jun  7 10:12:51 2019)

continue
* * modify base to heap;
Executing . . .

(6 rows)
continue
* * execute procedure trial_loop;
Executing . . .

MESSAGE 0: [1] for refresh_id = 1, snapshot_id = 100
MESSAGE 0: Cool to commit
MESSAGE 0: [2] for refresh_id = 2, snapshot_id = 200
MESSAGE 0: Failed with refresh_id = 2 so I'll rollback
MESSAGE 0: [3] for refresh_id = 3, snapshot_id = 300
MESSAGE 0: Cool to commit
MESSAGE 0: [4] for refresh_id = 4, snapshot_id = 400
MESSAGE 0: Failed with refresh_id = 4 so I'll rollback
MESSAGE 0: [5] for refresh_id = 5, snapshot_id = 500
MESSAGE 0: Cool to commit
MESSAGE 0: [6] for refresh_id = 6, snapshot_id = 600
MESSAGE 0: Failed with refresh_id = 6 so I'll rollback
MESSAGE 0: Summary: Encountered 6. Updated 3, Failed 3
continue
* * rollback

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190607/95ab9ee6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: weird.sh
Type: application/octet-stream
Size: 3463 bytes
Desc: weird.sh
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190607/95ab9ee6/attachment.obj>