From: | "Faith, Jeremy" <jfaith(at)tycoint(dot)com> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: [BUGS] BUG #11767: ODBC driver bug when fetching constant string columns |
Date: | 2014-12-02 12:28:46 |
Message-ID: | 55BAADA01D8C504993894EAEA7517CF80BA6C3@003FCH1MPN2-001.003f.mgd2.msft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> On Fri, Oct 24, 2014 at 9:36 AM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
> wrote:
>
> > On Wed, Oct 22, 2014 at 11:22 PM, <keyurgovande(at)gmail(dot)com> wrote:
> > > The following bug has been logged on the website:
> > >
> > > Bug reference: 11767
> > > Logged by: Keyur Govande
> > > Email address: keyurgovande(at)gmail(dot)com
> > > PostgreSQL version: 9.0.3
> > You should update to 9.0.18, you are 3.5 years of bug fixes.
> >
>
> Ah I apologize, I chose the wrong version in the bug report dropdown. This
> bug was observed with the latest driver: psqlodbc-09.03.0300 connecting to
> a Postgres server 9.1.14.
>
I can confirm that this bug exists in psqlodbc-09.03.0300 connecting to PostgreSQL 9.3.5.
>
> >
> > > If we run a SELECT statement like: SELECT id, varchar_col, date_col,
> > 'random
> > > string' as random;
> > > via ODBC, then the last column comes back as junk into PHP.
> > >
> > > In PHP we use the SQL_DESC_OCTET_LENGTH to figure out how many bytes to
> > > allocate. But for that column, SQL_DESC_OCTET_LENGTH returns 0 and we
> > don't
> > > allocate enough space.
> > >
> > > The driver issue seems to be that when SQLColAttributes() is called with
> > > SQL_COLUMN_TYPE for column 'random', it returns SQL_VARCHAR even though
> > the
> > > PG type is PG_TYPE_UNKNOWN. The promotion is happening here:
> > >
> > http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=blob;f=pgtypes.c;h=4ce7636b69d371d9f511d492c68013f070e3b32a;hb=HEAD#l665
> > >
> > > I think the same promotion needs to happen when fetching octet-length
> > here:
> > >
> > http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=blob;f=pgtypes.c;h=4ce7636b69d371d9f511d492c68013f070e3b32a;hb=HEAD#l1275
> > >
> > > Thoughts? This is not a problem when using the Vertica ODBC driver for
> > > example.
> > >
> > > A temporary workaround is to use a cast thusly: SELECT id, varchar_col,
> > > date_col, varchar 'random string' as random;
> > > This was reported to the PHP project (
> > https://bugs.php.net/bug.php?id=68087)
> > > but it seems like a Postgres ODBC driver bug.
> > pgsql-odbc is more adapted for a bug report on the ODBC driver. I am
> > moving the thread there.
> > --
> > Michael
> >
Jeremy Faith
Tyco Safety Products/CEM Systems Ltd.
________________________________
This e-mail contains privileged and confidential information intended for the use of the addressees named above. If you are not the intended recipient of this e-mail, you are hereby notified that you must not disseminate, copy or take any action in respect of any information contained in it. If you have received this e-mail in error, please notify the sender immediately by e-mail and immediately destroy this e-mail and its attachments.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-12-02 14:02:16 | Re: Re: [BUGS] BUG #11767: ODBC driver bug when fetching constant string columns |
Previous Message | Washington Leung | 2014-12-01 20:50:06 | Re: Local SQL connection PsotgreSQL in cloud |