Database/Drivers/MySQL Native/WhatWeHaveTested
From Apache OpenOffice Wiki
< Database | Drivers | MySQL Native
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
"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.
