[Mono-bugs] [Bug 79880][Maj] New - "create view" fails

[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 prensing at cimetrics.com.

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

--- shadow/79880	2006-11-09 13:07:15.000000000 -0500
+++ shadow/79880.tmp.11569	2006-11-09 13:07:15.000000000 -0500
@@ -0,0 +1,53 @@
+Bug#: 79880
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Major
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: prensing at cimetrics.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: "create view" fails
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+I am using Mono 1.18 against a MS SqlServer 2000. Note that the server
+version is important.
+
+I am trying to create a new VIEW through the SqlClient and it is failing.
+The statement is something like:
+  create view PAUL_TEST_VIEW as select * from Region
+
+I put this into a SqlCommand and execute, and it fails with a sql syntax
+error back from the server.
+
+The problem is that the TDS70.cs code adds a ";" (semi-colon) at the end of
+the statement. This is *NOT* allow specifically for a "create view" statement. 
+
+Steps to reproduce the problem:
+1. Edit viewBug.cs (to be attached) to set a useful username and password.
+2. Compile and run against SqlServer 2000
+3. 
+
+Actual Results:
+Get:
+
+Unhandled Exception: System.Data.SqlClient.SqlException: Line 1: Incorrect
+syntax near ';'.
+
+
+Expected Results:
+View should be created. This program does work under MS .NET.
+
+How often does this happen? 
+Always.
+
+Additional Information: