Bug #13048 maxQuerySizeToLog is not applied
Submitted: 7 Sep 2005 21:43 Modified: 22 Nov 2005 22:17
Reporter: Quartz12h
Status: Closed
Category:Connector/J Severity:S3 (Non-critical)
Version:3.1.7+ OS:
Assigned to: Mark Matthews Target Version:

[7 Sep 2005 21:43] Quartz12h 
Description:
My url defines the SQL string length to profile, but it gets truncated to ~1023 chars
anyway, even if the default seams to be 2048 and I asked 20480.
jdbc:mysql://127.0.0.1:3306/?profileSQL=true&maxQuerySizeToLog=20480

tested on 3.1.7 and 3.1.10 and found on both.

How to repeat:
create long SQL statement and try to profile them.
[12 Sep 2005 1:07] John Bradford 
I was able to reproduce the problem using the attached Java code and table.  I tried
several different values for maxQuerySizeToLog: 500, 1500, 2048, and 20480.  I even tried
letting it default.  In all cases the SQL statement was truncated in the exact same spot. 
I was using the 3.1.10 connector.
[12 Sep 2005 1:08] John Bradford 
Files used by John Bradford

Attachment: Bug13048.zip (application/x-zip-compressed, text), 21.40 KiB.
[22 Nov 2005 22:17] Mark Matthews 
Fixed for 3.1.12 and 5.0.0, see nightly snapshot build after 00:00 GMT Nov 23, or pull
from current subversion repository (sources) at
http://svn.mysql.com/svnpublic/connector-j/branches/branch_3_1

Thanks for the bug report!