From: | Oleg Serov <serovov(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Bug in PL/PgSQL "SELECT .. INTO" statement parser |
Date: | 2009-01-21 11:57:14 |
Message-ID: | cec7c6df0901210357v4d0053a0sc3d14c9553444790@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Sorry, but is not important, i forgot to remove original table name
"chunk_ad", but is not affected to the bug..
2009/1/21 Oleg Serov <serovov(at)gmail(dot)com>:
> Here is an example:
>
> CREATE TABLE test2 (
> id BIGINT,
> chunk_id BIGINT
> );
> CREATE TABLE test1 (
> id BIGINT
> );
>
> CREATE OR REPLACE FUNCTION "bug" () RETURNS pg_catalog.void AS
> $body$
> DECLARE
> row_test1 test1%rowtype;
> row_test2 test2%rowtype;
> BEGIN
> SELECT test1, chunk_ad
> FROM test1 JOIN test2 ON(chunk.id = test2.chunk_id)
> LIMIT 1
> INTO row_test1, row_test2;
>
> END;
> $body$
> LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY DEFINER;
>
> Will throw error:
> ERROR: LIMIT #,# syntax is not supported
> HINT: Use separate LIMIT and OFFSET clauses.
> QUERY: SELECT test1, chunk_ad FROM test1 JOIN test2 ON(chunk.id =
> test2.chunk_id) LIMIT 1, 0, $1
> CONTEXT: SQL statement in PL/PgSQL function "bug" near line 8
>
> ********** Ошибка **********
>
> ERROR: LIMIT #,# syntax is not supported
> SQL state: 42601
> Подсказка:Use separate LIMIT and OFFSET clauses.
> Контекст:SQL statement in PL/PgSQL function "bug" near line 8
>
From | Date | Subject | |
---|---|---|---|
Next Message | Priyank Raj | 2009-01-22 06:10:22 | segmentation fault on Dynamic query using C |
Previous Message | Oleg Serov | 2009-01-21 11:55:41 | Bug in PL/PgSQL "SELECT .. INTO" statement parser |