Skip site navigation (1) Skip section navigation (2)

Re: Another bug with parse statements on

From: "Andrea Aime" <aaime(at)comune(dot)modena(dot)it>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Postgres ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Another bug with parse statements on
Date: 2001-04-23 06:24:06
Message-ID: 3AE3CA86.F8CCE044@comune.modena.it (view raw or flat)
Thread:
Lists: pgsql-odbc
> >
> > 'SELECT min(classe) as minimo, max(classe) as massimo
> > FROM tav974'
> > (
> >  is a carriage return...)
> >
> 
> What kind of errors do you see ?
> I couldn't find any related ERRORs in your log.
> 

Snip from log file:

parse_statement: entering...
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='SELECT',
ptr='min(classe) as minimo, max(classe) as massimo
FROM tav974'
SELECT
got ispunct: s[3] = '('
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='min',
ptr='(classe) as minimo, max(classe) as massimo
FROM tav974'
reallocing at nfld=0
got field='min', dot=''
got ispunct: s[0] = '('
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='(',
ptr='classe) as minimo, max(classe) as massimo
FROM tav974'
**** got function = 'min'
got ispunct: s[6] = ')'
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='classe',
ptr=') as minimo, max(classe) as massimo
FROM tav974'
in_expr=0 or func=1
got ispunct: s[0] = ')'
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token=')', ptr='as
minimo, max(classe) as massimo
FROM tav974'
in_expr=0 or func=1
blevel-- = 0
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='as',
ptr='minimo, max(classe) as massimo
FROM tav974'
in_expr=0 or func=1
unquoted=1, quote=0, dquote=0, numeric=0, delim=',', token='minimo',
ptr=', max(classe) as massimo
FROM tav974'
in_expr=0 or func=1
got ispunct: s[5] = '('
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='max',
ptr='(classe) as massimo
FROM tav974'
in_expr=0 or func=1
got ispunct: s[0] = '('
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='(',
ptr='classe) as massimo
FROM tav974'
in_expr=0 or func=1
blevel++ = 1
got ispunct: s[6] = ')'
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='classe',
ptr=') as massimo
FROM tav974'
in_expr=0 or func=1
got ispunct: s[0] = ')'
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token=')', ptr='as
massimo
FROM tav974'
in_expr=0 or func=1
blevel-- = 0
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='as',
ptr='massimo
FROM tav974'
in_expr=0 or func=1
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='massimo',
ptr='FROM tav974'
in_expr=0 or func=1
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='FROM',
ptr='tav974'
FROM
unquoted=1, quote=0, dquote=0, numeric=0, delim=' ', token='tav974',
ptr=''
got table = 'tav974'
--------------------------------------------
nfld=1, ntab=1
Field 0:  expr=0, func=1, quote=0, dquote=0, numeric=0, name='min',
alias='', dot=''
Table 0: name='tav974', alias=''

nfld = 1? There are two fields in the result of my query. Moreover it
seems that he's 
taking min as a the attribute name, not minimo... maybe it doesn't
recognize aggregate
function names?
Hope this helps
Andrea Aime

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-04-23 06:57:53
Subject: Re: Postgres 7.1, iODBC and PHP4
Previous:From: Hiroshi InoueDate: 2001-04-23 02:29:31
Subject: Re: Another bug with parse statements on

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group