From: | "sean song" <seanpssong(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3226: ODBC driver 8.02.02 parses subqueries incorrectly |
Date: | 2007-04-13 14:30:49 |
Message-ID: | 200704131430.l3DEUni8020793@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3226
Logged by: sean song
Email address: seanpssong(at)yahoo(dot)com
PostgreSQL version: 8.2.3
Operating system: Windows XP sp2 (happen on all versions of Windows OS)
Description: ODBC driver 8.02.02 parses subqueries incorrectly
Details:
Problem description:
the ODBC driver seems confused by suqueries. e.g.
select test1.*, testsub.t1
from test1
left join
(select t1 from test2) as testsub
I get error from ODBC while debuging my code, saying returned E_FAIL. This
did not happen on version 8.0.
here is the ODBC log:
Global Options: Version='08.02.0200', fetch=100, socket=8192,
unknown_sizes=0, max_varchar_size=8192, max_longvarchar_size=32768
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0,
bools_as_char=0 NAMEDATALEN=64
extra_systable_prefixes='dd_', conn_settings=''
conn_encoding='OTHER'
and errors logged just after the query:
conn=06430048, query='select nspname from pg_namespace n, pg_class c where
c.relnamespace=n.oid and c.oid='"select"'::regclass'
ERROR from backend during send_query: 'ERROR: relation "select" does not
exist'
STATEMENT ERROR: func=parse_statement, desc='', errnum=1, errmsg='Table not
found'
looks like function parse_statement didn't understand subquery, instead it
treats 'select' after 'join' as a table name.
* this query runs perfectly on pgAdmin.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-04-13 14:45:11 | Re: BUG #3225: BitmapOr plan node does not show currect row count |
Previous Message | Jens-Wolfhard Schicke | 2007-04-13 12:31:05 | BUG #3225: BitmapOr plan node does not show currect row count |