Difference between revisions of "User:DrewJensen/HSQLdb/1.9QATests"

Revision as of 05:22, 16 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

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]

• • Dataview

- Open dataview on Table1 [OK]
- Close dataview window

• • Cached
  • Edit

• Index
  • Create
  • Drop

• View
  • Create
  • Drop/Recreate

1.8 functionality via SQL

• Table
  • Create / Alter
  • 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