diff options
author | Nagappan Alagappan <nagappan@gmail.com> | 2007-05-30 14:59:08 +0400 |
---|---|---|
committer | Nagappan Alagappan <nagappan@gmail.com> | 2007-05-30 14:59:08 +0400 |
commit | 754339e7c39cb1b057231bf8e8fe4609d7100fc0 (patch) | |
tree | 6cda667b39a63397eb6613daf4a763f039969d35 /mcs/class/System.Data/Test/ProviderTests/sql | |
parent | 48c392c9a898f6e220b4a6912dcb266d63f8b6f2 (diff) |
2007-05-30 Nagappan A <anagappan@novell.com>
* sqlserver.sql: Fixed sqlserver sql statements and its respective
values.
svn path=/trunk/mcs/; revision=78188
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/sql')
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog | 5 | ||||
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql | 13 |
2 files changed, 8 insertions, 10 deletions
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 <anagappan@novell.com> + + * sqlserver.sql: Fixed sqlserver sql statements and its respective + values. + 2007-02-02 Amit Biswas <amit@amitbiswas.com> * 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 |