Thread: Re: [INTERFACES] 7.1 beta 3 Linux ODBC BEGIN Behaviour

Steve Wranovsky wrote:
>
> Hello,
>
> I found another slight behavior change with the Linux
> client ODBC library between 7.0.3 and the 7.1 beta 3
> release.  We are running under Redhat 6.0.
>
> We have set the ODBC driver in autocommit off mode.  With
> the 7.0.3 driver, a BEGIN was automatically issued
> before the driver encountered a INSERT/UPDATE/DELETE.  With
> the 7.1 beta 3 ODBC driver, it now also issues a BEGIN when it
> encounters a SELECT.
>
> Is this the expected behavior under 7.1?
>

Probably not.
I would put back the behabior in a few days.

Regards,
Hiroshi Inoue

I wrote:
>
> Steve Wranovsky wrote:
> >
> >
> > We have set the ODBC driver in autocommit off mode.  With
> > the 7.0.3 driver, a BEGIN was automatically issued
> > before the driver encountered a INSERT/UPDATE/DELETE.  With
> > the 7.1 beta 3 ODBC driver, it now also issues a BEGIN when it
> > encounters a SELECT.
> >
> > Is this the expected behavior under 7.1?
> >
>
> Probably not.
> I would put back the behabior in a few days.
>

I've just committed a change.
However I couldn't test it sufficiently in my environment.
Please try the current snapshot.

Regards,
Hiroshi Inoue

Hiroshi Inoue wrote
>
> Steve Wranovsky wrote:
> >
> > Hello,
> >
> > I found another slight behavior change with the Linux
> > client ODBC library between 7.0.3 and the 7.1 beta 3
> > release.  We are running under Redhat 6.0.
> >
> > We have set the ODBC driver in autocommit off mode.  With
> > the 7.0.3 driver, a BEGIN was automatically issued
> > before the driver encountered a INSERT/UPDATE/DELETE.  With
> > the 7.1 beta 3 ODBC driver, it now also issues a BEGIN when it
> > encounters a SELECT.
> >
> > Is this the expected behavior under 7.1?
>
> Probably not.
> I would put back the behabior in a few days.

  There must be "SELECT ~ FOR UPDATE" of inside of the transaction.

=====
Hiroki Kataoka