> -----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 ?
In response to
pgsql-bugs by date
|Next:||From: Peter Eisentraut||Date: 2000-05-23 13:03:41|
|Subject: Re: [PORTS] Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64 |
|Previous:||From: Adam Haberlach||Date: 2000-05-23 06:50:22|
|Subject: Re: ODBC SELECT WHERE a IN ('frob') returns where a = '' too|