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

From Apache OpenOffice Wiki
Jump to: navigation, search
(framework error)
(wizard)
 
(3 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 29: Line 29:
 
- Close window<br>
 
- Close window<br>
 
[[File:Close_Window_after_Create_Base_file.png]]
 
[[File:Close_Window_after_Create_Base_file.png]]
 +
 +
 +
'''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )'''
 +
 +
-Open file PatientOne.odb [OK]<br>
 +
-Connect to internal database [ok]<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>
 +
 +
  
 
1.8/1.9 functionality via GUI
 
1.8/1.9 functionality via GUI
Line 40: 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 53: Line 66:
 
<br>
 
<br>
  
**Cached
+
**Delete
 +
'''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )'''
 +
 
 +
- using file SakilaHSQL.odb<br>
 +
- delete table Table1 [ OK [
 +
 
 
**Edit
 
**Edit
  
Line 66: 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
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