Difference between revisions of "User:DrewJensen/HSQLdb/1.9QATests"
DrewJensen (Talk | contribs) (→save as hang) |
DrewJensen (Talk | contribs) (→wizard) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 23: | Line 23: | ||
<br> | <br> | ||
− | Base file operations<br> | + | '''Base file operations'''<br> |
- File>New>Finished<br> | - File>New>Finished<br> | ||
Line 31: | Line 31: | ||
− | 10-16-2009 (Win 7, | + | '''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )''' |
-Open file PatientOne.odb [OK]<br> | -Open file PatientOne.odb [OK]<br> | ||
-Connect to internal database [ok]<br> | -Connect to internal database [ok]<br> | ||
-Save as "SakilaHsql" [ OO.o hangs and must be terminated from OS, no error dialog ]<br> | -Save as "SakilaHsql" [ OO.o hangs and must be terminated from OS, no error dialog ]<br> | ||
− | + | -After resarting OO.o the file SakilaHsql.odb exists and opens no probelm<br> | |
Line 50: | Line 50: | ||
- Add 5 fields with PK (Int, auto_inc) [OK]<br> | - Add 5 fields with PK (Int, auto_inc) [OK]<br> | ||
- Save table as Table1 [OK]<br> | - Save table as Table1 [OK]<br> | ||
+ | |||
+ | **Wizard | ||
+ | [[User:DrewJensen/HSQLdb/1.9QATest/Wizard]] | ||
*Dataview | *Dataview | ||
Line 63: | Line 66: | ||
<br> | <br> | ||
− | ** | + | **Delete |
+ | '''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )''' | ||
+ | |||
+ | - using file SakilaHSQL.odb<br> | ||
+ | - delete table Table1 [ OK [ | ||
+ | |||
**Edit | **Edit | ||
Line 76: | Line 84: | ||
1.8 functionality via SQL | 1.8 functionality via SQL | ||
*Table | *Table | ||
− | **Create / Alter | + | **Create / Alter <BR> |
+ | '''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )''' | ||
+ | |||
+ | - using file SakilaHSQL.odb<br> | ||
+ | - Used SQL Window to run command: <br> | ||
+ | |||
+ | CREATE TABLE actor (<br> | ||
+ | actor_id IDENTITY,<br> | ||
+ | first_name VARCHAR(45) NOT NULL,<br> | ||
+ | last_name VARCHAR(45) NOT NULL,<br> | ||
+ | last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,<br> | ||
+ | )<br> | ||
+ | [ok] | ||
+ | |||
+ | |||
+ | |||
**Cached | **Cached | ||
**Temp | **Temp |
Latest revision as of 23:36, 17 October 2009
OO.o configuration
Tools>Options/OO.o Database
Win 7 ( 10/15 build from qa-upload )
- Try to open either Connections or Databses
- This was from opening the Database page
Selecting No the page in the dialog displays the correct data for registered datasources.
-Attempt to open existing odb file, last updated by DEV320m_1
Reply No and at least simple queries of the data seems to work properly
-Using a bug document from issue tracker
Database access: Existing embedded forms not opens http://www.openoffice.org/issues/show_bug.cgi?id=105907
with 2 forms that open under 3.1.1 but not 3.2 (the first two) this build generates a sequence of error messages, with some at least looking much like the one just above (and does include exactly that line)
Base file operations
- File>New>Finished
- Save
- Close window
10-16-2009 (Win 7, Build 9427, CWShsqldb19 )
-Open file PatientOne.odb [OK]
-Connect to internal database [ok]
-Save as "SakilaHsql" [ OO.o hangs and must be terminated from OS, no error dialog ]
-After resarting OO.o the file SakilaHsql.odb exists and opens no probelm
1.8/1.9 functionality via GUI Data Definition functions:
- Table
- Create
Win 7 (10/15/09 build)
- Open odb from above test (PatientZero.odb) [OK]
- Save as PatientOne.odb [OK]
- Create new Table in design view [OK]
- Add 5 fields with PK (Int, auto_inc) [OK]
- Save table as Table1 [OK]
- Wizard
User:DrewJensen/HSQLdb/1.9QATest/Wizard
- Dataview
- Open dataview on Table1 [OK]
- Close dataview window
-Select Continue and one more error display,
-One more ignore
- Delete
10-16-2009 (Win 7, Build 9427, CWShsqldb19 )
- using file SakilaHSQL.odb
- delete table Table1 [ OK [
- Edit
- Index
- Create
- Drop
- View
- Create
- Drop/Recreate
1.8 functionality via SQL
- Table
- Create / Alter
- Create / Alter
10-16-2009 (Win 7, Build 9427, CWShsqldb19 )
- using file SakilaHSQL.odb
- Used SQL Window to run command:
CREATE TABLE actor (
actor_id IDENTITY,
first_name VARCHAR(45) NOT NULL,
last_name VARCHAR(45) NOT NULL,
last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
)
[ok]
- Cached
- Temp
- TEXT
- Edit
- Index
- Create
- Drop
- View
- Create
- Drop/Recreate
1.9 functionality via SQL
- Table
- Create / Alter
- Triggers
- Cached
- Temp
- TEXT
- Edit
- Create / Alter
- Index
- Create
- Drop
- View
- Create
- Drop/Recreate
- Stored functions and procedures
- Create
Data Manipulation functions:
1.8/1.9 functionality via GUI
- Query Definition
- Create
- Designer
- SQL
- Escape Processing Enabled
- Escape Processing Disabled
- Create