Difference between revisions of "Database/Drivers/MySQL Native/WhatWeHaveTested"
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
(→Manually tested) |
B michaelsen (Talk | contribs) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 22: | Line 22: | ||
* [UlfW - in progress] Foreign Key relations | * [UlfW - in progress] Foreign Key relations | ||
| − | ** detection of simple FK relation works | + | ** detection of simple single column FK relation works |
** delete restriction detected, little issue with error messages (see known problems) | ** delete restriction detected, little issue with error messages (see known problems) | ||
** ON DELETE CASCASE, ON DELETE RESTRICT (= NO ACTION), ON DELETE SET NULL seems OK | ** ON DELETE CASCASE, ON DELETE RESTRICT (= NO ACTION), ON DELETE SET NULL seems OK | ||
| + | ** ON UPDATE - can't test, update and insert not working | ||
== Connector/C++ == | == Connector/C++ == | ||
Connector/OpenOffice.org is a wrapper on top of the MySQL Connector/C++. About 400 API tests are run routinely on about 40 platforms to check the MySQL Connector/C++. The second alpha version of the driver does pass about 95% of the tests. Large parts of the tests are ported JDBC compliance tests. | Connector/OpenOffice.org is a wrapper on top of the MySQL Connector/C++. About 400 API tests are run routinely on about 40 platforms to check the MySQL Connector/C++. The second alpha version of the driver does pass about 95% of the tests. Large parts of the tests are ported JDBC compliance tests. | ||
| + | [[Category:MySQL]] | ||
Latest revision as of 21:42, 15 December 2009
Contents
"Ramdom" protocol of what has been tested
Connector/OpenOffice.org
Currently we focus on "manual" testing: we create a database connection using the driver and try to cause issues in Base. Depending on the bug inflow rate we will decide on further automated tests.
Manually tested
- [UlfW - done] All MySQL data types listed in the MySQL Reference Manual
- test pattern: create table, add column of the type X, insert min/max/null value and check column attributes not null/default, check values in Base
- define column type x - insert null
- define column type x not null - insert min allowed value
- define column type x default 0/1/"" or similar - insert max allowed value
- define column type x default 0/1/"" or similar - don't insert any value
- add a column of type x to the table using base
- some issues exist when displaying meta data (see known issues page)
- we should document the data type mappings for end users - its not always intuitive from a MySQL user perspective
- test pattern: create table, add column of the type X, insert min/max/null value and check column attributes not null/default, check values in Base
- [UlfW - in progress] Primary key and column types
- test pattern: create table with compound primary key and a random column, the column types of the primary key vary
- Most issues seem to have been identified by Andrey already, not worth to follow up?
- test pattern: create table with compound primary key and a random column, the column types of the primary key vary
- [UlfW - in progress] Foreign Key relations
- detection of simple single column FK relation works
- delete restriction detected, little issue with error messages (see known problems)
- ON DELETE CASCASE, ON DELETE RESTRICT (= NO ACTION), ON DELETE SET NULL seems OK
- ON UPDATE - can't test, update and insert not working
Connector/C++
Connector/OpenOffice.org is a wrapper on top of the MySQL Connector/C++. About 400 API tests are run routinely on about 40 platforms to check the MySQL Connector/C++. The second alpha version of the driver does pass about 95% of the tests. Large parts of the tests are ported JDBC compliance tests.
