I never use auto-increment, so I didn't test that. I can't look at it
tonight, but perhaps in a day or two. Thanks for the update!
/dev/mrg
On Jan 2, 2008 11:41 AM, Andrus Adamchik <andru..bjectstyle.org> wrote:
> Found one issue with the new logging today - insert queries with auto
> incremented PK incorrectly shift the labels to include the PK. E.g.,
> assuming auto-increment PK column name is "C2":
>
> INSERT INTO mytable (C1, C3, C4) VALUES (?, ?, ?)
> [bind: 1->C1:V1, 2->C2:V3, 3->C3:V4]
>
> At position #2, the PK label that is not used in the statement SQL is
> shown, and from there, all the values are off by one position.
>
> Andrus
>
>
>
> On Dec 28, 2007, at 5:07 PM, Michael Gentry wrote:
>
> > That's what I was hoping. Thanks for the update!
> >
> > /dev/mrg
> >
> > On Dec 28, 2007 9:53 AM, Andrus Adamchik <andru..bjectstyle.org>
> > wrote:
> >> I deployed this in production some time back. I am really happy with
> >> the new format - makes log analysis much easier.
> >>
> >> Cheers,
> >> Andrus
> >>
> >>
> >> On Nov 30, 2007, at 4:39 AM, Michael Gentry wrote:
> >>
> >>> Changes are checked in. Please let me know if you have problems,
> >>> etc.
> >>>
> >>> Thanks,
> >>>
> >>> /dev/mrg
> >>>
> >>
> >>
> >
>
>
This archive was generated by hypermail 2.0.0 : Wed Jan 02 2008 - 12:01:48 EST