Difference between revisions of "QA/AOO40 Database"
| (3 intermediate revisions by the same user not shown) | |||
| Line 116: | Line 116: | ||
Select fields, set types and formats, set primary key; | Select fields, set types and formats, set primary key; | ||
Insert data; | Insert data; | ||
| + | Update table | ||
Create view | Create view | ||
| | | | ||
| Line 164: | Line 165: | ||
| | | | ||
Failed/Bug 122603, 122604, 122605 | Failed/Bug 122603, 122604, 122605 | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
| + | Windows7 64bit | ||
| + | | | ||
| + | r 1478648 | ||
| + | | | ||
| + | ODF Database | ||
| + | | | ||
| + | Register database: | ||
| + | Register database automatically; | ||
| + | Register database manually; | ||
| + | Check registered database; | ||
| + | Remove a registered database | ||
| + | | | ||
| + | Passed | ||
| | | | ||
Yu Zhen Fan(fanyuzhen@gmail.com) | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| Line 196: | Line 214: | ||
Select fields, set types and formats, set primary key; | Select fields, set types and formats, set primary key; | ||
Insert data; | Insert data; | ||
| − | Create view | + | Create view; |
| + | Update table | ||
| | | | ||
Failed/Bug 122596 | Failed/Bug 122596 | ||
| Line 224: | Line 243: | ||
| | | | ||
Tables: | Tables: | ||
| − | + | Update table; | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| | | | ||
Failed/Bug 122611 | Failed/Bug 122611 | ||
| Line 282: | Line 298: | ||
Mac OS X | Mac OS X | ||
| | | | ||
| − | + | r 1478648 | |
| | | | ||
| − | + | DB2 via JDBC | |
| | | | ||
| − | + | Databases: | |
| + | Connect to an existing DB2: | ||
| + | Install driver; | ||
| + | Test class to check driver can be loaded; | ||
| + | Test connection to check connection can be established; | ||
| | | | ||
| − | + | Passed | |
| − | + | ||
| | | | ||
| − | + | Yu Zhen Fan(fanyuzhen@gmail.com) | |
|- | |- | ||
| | | | ||
| + | Mac OS X | ||
| + | | | ||
| + | r 1496831 | ||
| + | | | ||
| + | Text/CSV Database | ||
| + | | | ||
| + | Databases: | ||
| + | Connect to an existing CSV database | ||
| + | | | ||
| + | Passed | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
| + | Mac OS X | ||
| + | | | ||
| + | r 1496831 | ||
| + | | | ||
| + | Text/CSV Database | ||
| + | | | ||
| + | Tables: | ||
| + | Update table; | ||
| + | | | ||
| + | Failed/Bug 122611 | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
| + | Mac OS X | ||
| + | | | ||
| + | r 1496831 | ||
| + | | | ||
| + | Text/CSV Database | ||
| + | | | ||
| + | Queries: | ||
| + | Create query in design view; | ||
| + | Create query with wizard; | ||
| + | Add table or query | ||
| + | | | ||
| + | Failed/Bug 122612 | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
| + | Mac OS X | ||
| + | | | ||
| + | r 1496831 | ||
| + | | | ||
| + | Text/CSV Database | ||
| + | | | ||
| + | Form: | ||
| + | Create form in design view; | ||
| + | Create form with wizard | ||
| + | | | ||
| + | Passed | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
| + | Mac OS X | ||
| + | | | ||
| + | r 1496831 | ||
| + | | | ||
| + | Text/CSV Database | ||
| + | | | ||
| + | Report: | ||
| + | Create report with wizard | ||
| + | | | ||
| + | Failed/Bug 122603, 122604, 122605 | ||
| + | | | ||
| + | Yu Zhen Fan(fanyuzhen@gmail.com) | ||
| + | |- | ||
| + | | | ||
Ubuntu 64bit | Ubuntu 64bit | ||
| | | | ||
Latest revision as of 10:22, 4 July 2013
Database General Testing
|
Platform |
Build |
Database |
Tested scenario/Steps |
Test result/defect |
Tester |
|
[For example]Windows7 64bit |
r 1489073 |
Oracle |
Create Embedded database/Create a new database |
Passed |
Tester(contact email address) |
|
[For example]Windows7 64bit |
r 1489073 |
JDBC |
Create Embedded database/create table in design view |
Failed/Bug 20000 |
Tester(contact email address) |
|
Mac OS X |
|
||||
|
Ubuntu 64bit |
|
|
Platform |
Build |
Database |
Tested scenario/Steps |
Test result/defect |
Tester |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Databases: Create a new database |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Tables: Create table in design view; Create table with wizard; Select fields, set types and formats, set primary key; Insert data; Update table Create view |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Queries: Create query in design view; Create query with wizard; Add table or query |
Failed/Bug 122589 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Form: Create form in design view; Create form with wizard |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Report: Create report with wizard |
Failed/Bug 122603, 122604, 122605 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
ODF Database |
Register database: Register database automatically; Register database manually; Check registered database; Remove a registered database |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
DB2 via JDBC |
Databases: Connect to an existing DB2: Install driver; Test class to check driver can be loaded; Test connection to check connection can be established; |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
DB2 via JDBC |
Tables: Create table in design view; Create table with wizard; Select fields, set types and formats, set primary key; Insert data; Create view; Update table |
Failed/Bug 122596 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
Text/CSV Database |
Databases: Connect to an existing CSV database |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
Text/CSV Database |
Tables: Update table; |
Failed/Bug 122611 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
Text/CSV Database |
Queries: Create query in design view; Create query with wizard; Add table or query |
Failed/Bug 122612 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
Text/CSV Database |
Form: Create form in design view; Create form with wizard |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Windows7 64bit |
r 1478648 |
Text/CSV Database |
Report: Create report with wizard |
Failed/Bug 122603, 122604, 122605 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1478648 |
DB2 via JDBC |
Databases: Connect to an existing DB2: Install driver; Test class to check driver can be loaded; Test connection to check connection can be established; |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1496831 |
Text/CSV Database |
Databases: Connect to an existing CSV database |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1496831 |
Text/CSV Database |
Tables: Update table; |
Failed/Bug 122611 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1496831 |
Text/CSV Database |
Queries: Create query in design view; Create query with wizard; Add table or query |
Failed/Bug 122612 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1496831 |
Text/CSV Database |
Form: Create form in design view; Create form with wizard |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Mac OS X |
r 1496831 |
Text/CSV Database |
Report: Create report with wizard |
Failed/Bug 122603, 122604, 122605 |
Yu Zhen Fan(fanyuzhen@gmail.com) |
|
Ubuntu 64bit |
|
