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

Revision as of 16:46, 15 October 2009 (view source) DrewJensen (Talk | contribs) m (start)		Latest revision as of 23:36, 17 October 2009 (view source) DrewJensen (Talk | contribs) (→‎wizard)
(10 intermediate revisions by the same user not shown)
Line 1:		Line 1:
		+	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>
		+	<br>[[File:Upgrade_db_yes.png‎]]
		+	<br> Reply No and at least simple queries of the data seems to work properly
		+
		+
		+	-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>
		+
		+
	1.8/1.9 functionality via GUI		1.8/1.9 functionality via GUI
Line 4:		Line 44:
	*Table		*Table
	**Create		**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		**Edit
Line 17:		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
    

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