From 754339e7c39cb1b057231bf8e8fe4609d7100fc0 Mon Sep 17 00:00:00 2001 From: Nagappan Alagappan Date: Wed, 30 May 2007 10:59:08 +0000 Subject: 2007-05-30 Nagappan A * sqlserver.sql: Fixed sqlserver sql statements and its respective values. svn path=/trunk/mcs/; revision=78188 --- mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog | 5 +++++ mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql | 13 +++---------- 2 files changed, 8 insertions(+), 10 deletions(-) (limited to 'mcs/class/System.Data/Test/ProviderTests/sql') diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog index 13841b6d36e..d7851f6da9c 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog +++ b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog @@ -1,3 +1,8 @@ +2007-05-30 Nagappan A + + * sqlserver.sql: Fixed sqlserver sql statements and its respective + values. + 2007-02-02 Amit Biswas * MySQL_5.sql: Added this new sql script. This sql script performs diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql index 4c1cad0956f..26f8533384e 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql +++ b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql @@ -1,10 +1,3 @@ -if exists (select name from sysdatabases where - name = 'mono-test') - drop database [mono-test]; -create database [mono-test]; -grant all privileges on [mono-test] to monotester; -go - use monotest; -- =================================== OBJECT NUMERIC_FAMILY============================ @@ -61,7 +54,7 @@ go grant all privileges on binary_family to monotester; go -insert into binary_family values (1, convert (binary, '555555'), convert (varbinary, '0123456789012345678901234567890123456789012345678901234567890123456789'), +insert into binary_family values (1, convert (binary, '5'), convert (varbinary, '0123456789012345678901234567890123456789012345678901234567890123456789'), convert (image, '66666666'), convert (image, '777777'), convert (image, '888888'), convert (image, '999999')); --insert into binary_family values (2, @@ -92,7 +85,7 @@ go grant all privileges on string_family to monotester; go -insert into string_family values (1,newid(),"char","varchar","text","ntext"); +insert into string_family values (1,newid(),'char','varchar','text','ntext'); insert into string_family values (4,null,null,null,null,null); go -- =================================== END OBJECT STRING_FAMILY ======================== @@ -114,7 +107,7 @@ create table datetime_family ( grant all privileges on datetime_family to monotester; go -insert into datetime_family values (1,'2079-06-06 23:59:00','9999-12-31 23:59:59.997'); +insert into datetime_family values (1,'2079-06-06 23:59:00','9999-12-31 23:59:59:00'); insert into datetime_family values (4,null,null); go -- cgit v1.2.3