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

RE: ODBC SELECT WHERE a IN ('frob') returns where a = '' too

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Adam Haberlach" <adam(at)newsnipple(dot)com>
Cc: <bugs(at)postgresql(dot)org>
Subject: RE: ODBC SELECT WHERE a IN ('frob') returns where a = '' too
Date: 2000-05-23 07:57:09
Message-ID: 000901bfc48c$7f1dfb00$2801007e@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugs
> -----Original Message-----
> From: pgsql-bugs-owner(at)hub(dot)org [mailto:pgsql-bugs-owner(at)hub(dot)org]On
> Behalf Of Adam Haberlach
>
> On Tue, May 23, 2000 at 01:33:56AM -0400, Tom Lane wrote:
> > Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> > > When I do a query of the form
> > > SELECT a FROM tbl WHERE a IN ('frob');
> > > where a is an indexed text field containing 'frob', 'dingus', '', and
> > > NULL
> > > I get a set that includes rows both where
> > > a == 'frob'
> > > a == ''
> >
> > > This happens when I use ODBC from Microsoft Access's
> pass-through, but
> > > does not seem to happen from the psql
> > > command-line.  This seems to confuse my coworker who is more familiar
> > > with non-Postgres databases then I.
> >
> > I'm confused too.  Best theory I can think of is that Access is
> > transforming the query into something different before sending it to the
> > backend.  That'd be incredibly braindead, but then this is M$ software
> > we're talking about.  Anyway, the first thing to do is confirm or deny
> > that theory by looking at the exact query the backend is getting.
> > If you can't get Access to log what it sends, restart the postmaster
> > with "-d2" or higher, and see what gets logged...
>
>
> Here is what actually seems to happen.  Put your "Oh My GOD that is so
> DUMB hats on now."
>
> /*************/
> query: declare SQL_CUR071E7D04 cursor for SELECT
> "rawbebugs"."bbcnum" FROM
> "rawbebugs" WHERE ("bestatus" IN ('fixed' ) )
>
.
.

This seems to be the behavior of DAO-Jet with declare/fetch option
of psqlodbc driver.
Is this really a result of Access's *pass-through* query ?

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp


In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-05-23 13:03:41
Subject: Re: [PORTS] Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64
Previous:From: Adam HaberlachDate: 2000-05-23 06:50:22
Subject: Re: ODBC SELECT WHERE a IN ('frob') returns where a = '' too

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