Home > mailing lists

Thread: [BUGS] plpgsql - wrong using of PERFORM statement doesn't raise a error

[BUGS] plpgsql - wrong using of PERFORM statement doesn't raise a error

From

Pavel Stehule

Date:

23 December 2016, 15:14:57

Following command finishing without any error, but (as expected) do nothing

postgres=# create table foo(a int);

CREATE TABLE

Time: 51,363 ms

postgres=# DO $$

postgres$# DECLARE t text;

postgres$# BEGIN

postgres$# t := 'INSERT INTO foo VALUES(10)';

postgres$# PERFORM t;

postgres$# END;

postgres$# $$;

Time: 4,375 ms

postgres=# select * from foo;

┌───┐

│ a │

╞═══╡

└───┘

(0 rows)

Time: 1,367 ms

Regards

Pavel Stehule

Re: [BUGS] plpgsql - wrong using of PERFORM statement doesn't raise a error

From

Pavel Stehule

Date:

23 December 2016, 15:24:54

2016-12-23 10:14 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:

Hi

Following command finishing without any error, but (as expected) do nothing

postgres=# create table foo(a int);
CREATE TABLE
Time: 51,363 ms
postgres=# DO $$
postgres$# DECLARE t text;
postgres$# BEGIN
postgres$# t := 'INSERT INTO foo VALUES(10)';
postgres$# PERFORM t;
postgres$# END;
postgres$# $$;
DO
Time: 4,375 ms
postgres=# select * from foo;
┌───┐
│ a │
╞═══╡
└───┘
(0 rows)

Time: 1,367 ms

Related to http://stackoverflow.com/questions/41294888/plpgsql-error-query-has-no-destination-for-result-data-on-a-parameter-declarati

Regards

It generate valid command

SELECT t --> SELECT 'INSERT ...';

Hard to detect this issue.

Pavel

Pavel Stehule