User:DrewJensen/HSQLdb/1.9QATests

From Apache OpenOffice Wiki
Jump to: navigation, search

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
Tools Options Connections.png
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

Upgrade db yes.png
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
Close Window after Create Base file.png


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
Close dataview.png

-Select Continue and one more error display,
Close dataview secondTime.png
-One more ignore
Close dataview three 125528.png

    • 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

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
  • 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
Personal tools