BUG #8606: Materialized View WITH NO DATA bug

Поиск
Список
Период
Сортировка
От j.rejda@konektel.cz
Тема BUG #8606: Materialized View WITH NO DATA bug
Дата
Msg-id E1VinLE-0005zJ-HB@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8606: Materialized View WITH NO DATA bug
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8606
Logged by:          Jaroslav Rejda
Email address:      j.rejda@konektel.cz
PostgreSQL version: 9.3.1
Operating system:   MS Windows XP SP3
Description:

-- Hi,
-- please, check this example:


-- simple table
CREATE TABLE test (cislo integer);
INSERT INTO test VALUES (10);


-- immutable "long time" math func
CREATE FUNCTION long_test(_n bigint)
  RETURNS bigint AS
$BODY$DECLARE
  _result bigint := 0;
  _i bigint := 2;
BEGIN
  _n := !! _n;
  WHILE _i < _n LOOP
    IF _n % _i = 0 THEN
      _result := _result + 1;
    END IF;
    _i := _i + 1;
  END LOOP;
  RETURN _result;
END;$BODY$
  LANGUAGE plpgsql IMMUTABLE STRICT
  COST 100;


-- this returns "immediately"
CREATE MATERIALIZED VIEW test1 AS SELECT long_test(cislo) FROM test WITH NO
DATA;


-- this returns "after some time" (as long as normal "SELECT long_test(10);"
do)
CREATE MATERIALIZED VIEW test2 AS SELECT long_test(10) WITH NO DATA;


-- it's ok or bug?
-- Thanks ... JR

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Ronan Dunklau
Дата:
Сообщение: Server may segfault when using slices on int2vector
Следующее
От: atoriwork@gmail.com
Дата:
Сообщение: BUG #8605: Regular expression lazy quantification issue