Menu

#27 Add support for STABLE functions

Development Queue
open
None
5
2013-06-12
2011-04-22
Abbas Butt
No

Consider the following test case (taken from portals.sql)

create table tt1(f1 int);
create function count_tt1_v() returns int8 as 'select count(*) from tt1' language sql volatile;
create function count_tt1_s() returns int8 as 'select count(*) from tt1' language sql stable;
begin;
insert into tt1 values(1);
declare c1 cursor for select count_tt1_v(), count_tt1_s();
insert into tt1 values(2);
fetch all from c1;
returns
count_tt1_v | count_tt1_s
-------------+-------------
2 | 2
(1 row)

where as it is supposed to return
count_tt1_v | count_tt1_s
-------------+-------------
2 | 1
(1 row)

Discussion

  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03

    We should see vanilla PostgreSQL. This should be a bug.

     
  • Koichi Suzuki

    Koichi Suzuki - 2012-06-03
    • labels: 1443719 -->
    • milestone: 1843521 -->
     
  • Koichi Suzuki

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

    Koichi Suzuki - 2012-09-12

    Q3

     
  • Koichi Suzuki

    Koichi Suzuki - 2012-09-12
    • assigned_to: nobody --> gabbasb
    • labels: --> 1406362
     
  • Koichi Suzuki

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

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

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.