[Mono-bugs] [Bug 75686][Min] New - DataTable.Select does not do escaping for '.

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by tsureshkumar at novell.com.

http://bugzilla.ximian.com/show_bug.cgi?id=75686

--- shadow/75686	2005-08-02 08:31:22.000000000 -0400
+++ shadow/75686.tmp.16016	2005-08-02 08:31:22.000000000 -0400
@@ -0,0 +1,27 @@
+Bug#: 75686
+Product: Mono: Class Libraries
+Version: 1.0
+OS: 
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Minor
+Component: Sys.Data
+AssignedTo: tsureshkumar at novell.com                            
+ReportedBy: tsureshkumar at novell.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Summary: DataTable.Select does not do escaping for '.
+
+pasted from mail from banditaras at gmail.com
+
+I'm using mono 1.1.8.2 and the MySql connector (1.0.4.20163)
+First, I'm having this problem with the RowFilter expression. 
+I want to do a DataTable.Select(someFilterHere), but if the filter
+contains a single quote, I cannot escape it. For example
+string filter = "ProductTitle = 'aa''aa'"; //invalid expression
+string filter = "ProductTitle = 'aa\\'aa'"; //invalid expression
+string filter = @"ProductTitle = 'aa\'aa'"; //invalid expression
+The first expression works fine in .Net.