Difference between revisions of "QA/AOO40 Database"
Liupingtan (Talk | contribs) (Created page with " {| class="wikitable" |- | '''Platform''' | '''Build''' | '''Component''' | '''Tested scenario/Steps''' | '''Test result/defect''' |- | Windows7 64bit | r 1489073 | Database ...") |
|||
(25 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
+ | |||
+ | ==Database General Testing == | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 7: | Line 9: | ||
'''Build''' | '''Build''' | ||
| | | | ||
− | ''' | + | '''Database''' |
| | | | ||
'''Tested scenario/Steps''' | '''Tested scenario/Steps''' | ||
| | | | ||
'''Test result/defect''' | '''Test result/defect''' | ||
+ | | | ||
+ | '''Tester''' | ||
|- | |- | ||
| | | | ||
− | Windows7 64bit | + | [For example]Windows7 64bit |
| | | | ||
r 1489073 | r 1489073 | ||
| | | | ||
− | + | Oracle | |
| | | | ||
Create Embedded database/Create a new database | Create Embedded database/Create a new database | ||
| | | | ||
Passed | Passed | ||
+ | | | ||
+ | Tester(contact email address) | ||
|- | |- | ||
| | | | ||
− | Windows7 64bit | + | [For example]Windows7 64bit |
| | | | ||
r 1489073 | r 1489073 | ||
| | | | ||
− | + | JDBC | |
| | | | ||
Create Embedded database/create table in design view | Create Embedded database/create table in design view | ||
| | | | ||
Failed/Bug 20000 | Failed/Bug 20000 | ||
+ | | | ||
+ | |||
+ | Tester(contact email address) | ||
|- | |- | ||
| | | | ||
+ | Mac OS X | ||
| | | | ||
Line 42: | Line 52: | ||
| | | | ||
+ | |||
+ | | | ||
+ | |||
| | | | ||
Line 48: | Line 61: | ||
| | | | ||
+ | Ubuntu 64bit | ||
| | | | ||
Line 53: | Line 67: | ||
| | | | ||
+ | |||
+ | | | ||
+ | |||
| | | | ||
|} | |} | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | | | ||
+ | '''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 | ||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
+ | | | ||
+ | |||
+ | |||
+ | | | ||
+ | |||
+ | |} | ||
+ | |||
+ | |||
+ | [[Category:Quality Assurance]] |
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 |
|