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





Reply via email to