Difference between revisions of "QA/AOO40 Database"
(→Database General Testing) |
(→Database General Testing) |
||
Line 112: | Line 112: | ||
| | | | ||
Tables: | Tables: | ||
− | Create table in design view | + | Create table in design view; |
− | Create table with wizard | + | Create table with wizard; |
− | 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 | ||
| | | | ||
Line 130: | Line 130: | ||
| | | | ||
Queries: | Queries: | ||
− | Create query in design view | + | Create query in design view; |
− | Create query with wizard | + | Create query with wizard; |
− | Add table or query | + | Add table or query; |
| | | | ||
Failed | Failed | ||
Line 148: | Line 148: | ||
Databases: | Databases: | ||
Connect to existing DB2: | Connect to existing DB2: | ||
− | Install driver | + | Install driver; |
− | Test class to check driver can be loaded | + | Test class to check driver can be loaded; |
− | Test connection to check connection can be established | + | Test connection to check connection can be established; |
| | | | ||
Passed | Passed | ||
Line 165: | Line 165: | ||
| | | | ||
Tables: | Tables: | ||
− | Create table in design view | + | Create table in design view; |
− | Create table with wizard | + | Create table with wizard; |
− | 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 | ||
| | | |
Revision as of 12:12, 25 June 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; 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 |
DB2 via JDBC |
Databases: Connect to 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 |
Passed |
Yu Zhen Fan(fanyuzhen@gmail.com) |
Mac OS X |
|
||||
Ubuntu 64bit |
|