diff options
author | Sureshkumar T <suresh@mono-cvs.ximian.com> | 2005-10-08 13:57:37 +0400 |
---|---|---|
committer | Sureshkumar T <suresh@mono-cvs.ximian.com> | 2005-10-08 13:57:37 +0400 |
commit | 88683eb2b226c25b3c7b059eb66356cb470b798e (patch) | |
tree | b25ab4df5c0b8ebe77a7d793b305c36342ab6e9e /mcs/class/System.Data/Test/ProviderTests/sql | |
parent | 3f3bceed39d7b5243b2bf2e281ecd11d949134f9 (diff) |
In System.Data.Odbc:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* OdbcParameterTest.cs (OdbcTypeTest): Disconnected Tests for
OdbcParameter class.
In ProviderTests/sql:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* mysql.sql: impact from sqlserver.sql.
In ProviderTests/System.Data.Odbc:
2005-10-08 Sureshkumar T <tsureshkumar@novell.com>
* OdbcParameterTest.cs: Corrections.
svn path=/trunk/mcs/; revision=51461
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/sql')
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog | 4 | ||||
-rw-r--r-- | mcs/class/System.Data/Test/ProviderTests/sql/mysql.sql | 54 |
2 files changed, 54 insertions, 4 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog index 7d1a0926a6a..9cebc26ef0b 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog +++ b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog @@ -1,3 +1,7 @@ +2005-10-08 Sureshkumar T <tsureshkumar@novell.com> + + * mysql.sql: impact from sqlserver.sql. + 2005-09-24 Sureshkumar T <tsureshkumar@novell.com> * sybase.sql: grant permissions on objects diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/mysql.sql b/mcs/class/System.Data/Test/ProviderTests/sql/mysql.sql index f31407bcfc8..a70e59bffb0 100644 --- a/mcs/class/System.Data/Test/ProviderTests/sql/mysql.sql +++ b/mcs/class/System.Data/Test/ProviderTests/sql/mysql.sql @@ -18,13 +18,16 @@ create table numeric_family ( type_decimal decimal (38, 0) NULL, type_numeric numeric (38, 0) NULL, type_money numeric (38,0) NULL, - type_smallmoney numeric (12,0) NULL); + type_smallmoney numeric (12,0) NULL, + type_float real NULL, + type_double float NULL); -- does not have money & smallmoney types // -insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647); -insert into numeric_family values (2,0,0,-32768,-2147483648,-9223372036854775808,-1000,-1000,-922337203685477.5808,-214748.3648); -insert into numeric_family values (3,0,0,0,0,0,0,0,0,0); insert into numeric_family values (4,null,null,null,null,null,null,null,null,null); // +insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647,3.40E+38,1.79E+308); +insert into numeric_family values (2,0,0,-32768,-2147483648,-9223372036854775808,-1000,-1000,-922337203685477.5808,-214748.3648,-3.40E+38,-1.79E+308); +insert into numeric_family values (3,0,0,0,0,0,0,0,0,0,0,0); +insert into numeric_family values (4,null,null,null,null,null,null,null,null,null,null,null); -- =================================== END OBJECT NUMERIC_FAMILY ======================== @@ -52,6 +55,49 @@ insert into binary_family values (4,null,null,null,null,null,null); -- =================================== END OBJECT BINARY_FAMILY ======================== +-- =================================== OBJECT STRING_FAMILY============================ +-- TABLE : string_family +-- data with id above 6000 is not gaurenteed to be read-only. +drop table if exists string_family; +// + +create table string_family ( + id int PRIMARY KEY NOT NULL, + type_char char(10) NULL, + type_varchar varchar(10) NULL, + type_text text NULL, + type_ntext longtext NULL); +// + +grant all privileges on string_family to monotester; +// + +insert into string_family values (1,"char","varchar","text","ntext"); +insert into string_family values (4,null,null,null,null); +// +-- =================================== END OBJECT STRING_FAMILY ======================== + +-- =================================== OBJECT DATETIME_FAMILY============================ +-- TABLE : datetime_family +-- data with id above 6000 is not gaurenteed to be read-only. + +drop table if exists datetime_family; +// + +create table datetime_family ( + id int PRIMARY KEY NOT NULL, + type_smalldatetime timestamp NULL, + type_datetime datetime NULL); + +grant all privileges on datetime_family to monotester; +// + +insert into datetime_family values (1,'2079-06-06 23:59:00','9999-12-31 23:59:59.997'); +insert into datetime_family values (4,null,null); +// + +-- =================================== END OBJECT DATETIME_FAMILY======================== + -- =================================== OBJECT EMPLOYEE ============================ -- TABLE : EMPLOYEE |