[pgpool-general: 6418] Re: Unable to parse the query

[Tatsuo Ishii]

> Tested in pgpool dev, 2 version of queries:
> A. select * from (select branch_type as A from branch where parent_id in
> (1813) order by branch_id) limit 1;
> B. select * from (select branch_type as A from branch where parent_id in
> (1813) order by branch_id) AS TMP limit 1;
> 
> in pgpool log:
> A. there is log error unable to parse query.
> B. no error

Pgpool-II has an SQL parser which is ported from open source
PostgreSQL, not edb. The query A can only be parsed by edb, not by
either Pgpool-II or PostgreSQL. I bet PostgreSQL will give an error
with A too.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp