| Bug #51517 | Connector/.Net - query normalizer doesn't handle inserting binary value | ||
|---|---|---|---|
| Submitted: | 25 Feb 2010 16:41 | Modified: | 9 Jan 2015 10:33 |
| Reporter: | Bill Weber | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Enterprise Monitor: Connector Plugins | Severity: | S3 (Non-critical) |
| Version: | 1.0.3.0 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[5 Mar 2010 20:22]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/102476
[30 Nov 2010 13:23]
Enterprise Tools JIRA Robot
Mark Leith writes: Setting to Patch Pushed for workflow (QA testing), this appears to have been fixed.
Description: When inserting a binary file into the db, the following exception occurs in the c/.net plugin (and the query is not shown on the dashboard): at QueryNormalizer.CollapseValueList(List`1 tok, Int32& pos) at QueryNormalizer.CollapseValueLists(List`1 tok) at QueryNormalizer.Normalize(String sql) at ServerAggregation.AddNewQuery(MySqlTraceQuery qi) at EMTraceListener.processingThread_DoWork(Object sender, DoWorkEventArgs e) at BackgroundWorker.OnDoWork(DoWorkEventArgs e) at BackgroundWorker.WorkerThreadStart(Object argument) at StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink) at AgileAsyncWorkerItem.DoAsyncCall() at AgileAsyncWorkerItem.ThreadPoolCallBack(Object o) at _ThreadPoolWaitCallback.WaitCallback_Context(Object state) at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack) at _ThreadPoolWaitCallback.PerformWaitCallback(Object state) How to repeat: - create a table with a blob field - insert a .png file into the table snippet: cmd.CommandText = "INSERT INTO staff VALUES('My', 'Name', @PngFile)"; cmd.Parameters.AddWithValue("@PngFile", pngData);