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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > 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 > >>> > >> > >> > > > >
