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

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

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

@@ Line 1: / Line 1: @@
-OO.o/Base configuration
+OO.o configuration
 Tools>Options/OO.o Database <br>
 Win 7 ( 10/15 build from qa-upload ) <br>
 - Try to open either Connections or Databses <br>
 - This was from opening the Database page<br>
 [[File:Tools_Options_Connections.png]]
 <br>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 <br>
@@ Line 12: / Line 16: @@
 <br> Reply No and at least simple queries of the data seems to work properly
--Using a bug document from issue tracker, with 2 forms that open under 3.1.1 but not 3.2 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), when trying to open either of the forms that do not open in 3.2. (the first two)
-<br> Database access: Existing embedded forms not opens [http://www.openoffice.org/issues/show_bug.cgi?id=105907]
+-Using a bug document from issue tracker
+<br> Database access: Existing embedded forms not opens http://www.openoffice.org/issues/show_bug.cgi?id=105907
+<br> 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)
+<br>
+'''Base file operations'''<br>
+- File>New>Finished<br>
+- Save<br>
+- Close window<br>
+[[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>
@@ Line 20: / Line 44: @@
 *Table
 **Create
-**Cached
+Win 7 (10/15/09 build)<br>
+- Open odb from above test (PatientZero.odb) [OK]<br>
+- Save as PatientOne.odb [OK]<br>
+- Create new Table in design view [OK]<br>
+- Add 5 fields with PK (Int, auto_inc) [OK]<br>
+- Save table as Table1 [OK]<br>
+**Wizard
+[[User:DrewJensen/HSQLdb/1.9QATest/Wizard]]
+*Dataview
+- Open dataview on Table1 [OK]<br>
+- Close dataview window<br>
+[[File:close_dataview.png]]
+-Select Continue and one more error display, <br>
+[[File:Close_dataview_secondTime.png]]
+<br>
+-One more ignore<br>
+[[File:Close_dataview_three_125528.png]]
+<br>
+**Delete
+'''10-16-2009 (Win 7, Build 9427, CWShsqldb19 )'''
+- using file SakilaHSQL.odb<br>
+- delete table Table1 [ OK [
 **Edit
@@ Line 33: / Line 84: @@
 .8 functionality via SQL
 *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
 **Temp

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

Latest revision as of 23:36, 17 October 2009

Views

Personal tools

Navigation

Search

Tools