BUG #4633: Bug in PL/PgSQL "SELECT .. INTO" statement parser
От | Oleg |
---|---|
Тема | BUG #4633: Bug in PL/PgSQL "SELECT .. INTO" statement parser |
Дата | |
Msg-id | 200901272115.n0RLFXuw062425@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4633: Bug in PL/PgSQL "SELECT .. INTO" statement parser
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4633 Logged by: Oleg Email address: serovOv@gmail.com PostgreSQL version: PostgreSQL 8.3 Operating system: CentOS Description: Bug in PL/PgSQL "SELECT .. INTO" statement parser Details: 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, test2 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, test2 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
В списке pgsql-bugs по дате отправления: