HOME > Community > Projects > qa

SQL Editor - multiple sql statement support

Author: Lukasz Grela
Version: 1.0
Last update: Fri Mar 3 11:56:36 CET 2006
Introduction: This test specification guides tester through SQL Editor future that make possible to execute more than one sql statement.

Opening SQL Editor
SQL Editor - executing statements

Test suite: Opening SQL Editor

Purpose: Tests that it is possible to execute multiple sql statements
Setup: connection with database should be established

#	Test case	Description
1	Opening Sql Editor	1. Expand the Databases node in the Runtime window 2. Right-click the node for the connected database and choose Execute Command from the pop-up menu to open the SQL Editor 3. Check that current database connection is selected in the Connection drop-down list.
1	Opening Sql Editor	RESULT: SQL Editor should be visible.

Test suite: SQL Editor - executing statements

Purpose: Test executing multiple sql statement using SQL Editor
Setup: Connection to database should be established and SQL Editor should be opened.

#	Test case	Description
1	Executing multiple statements	1. Enter in SQL Editor at least two sql statements each statement must be separated by ";" 2. Click Run SQL to run the statement.
		RESULT: The Output window should appear. All actions are done correctly and in Output window there is a result of executing sql statement
2	Executing not valid sql statement.	1. Enter fiew sql statements separated by ";" some of them should be not valid 2. Click Run SQL to run the statement. 3. In output window should be result of executing, each statements which was not valid should hava a link, this link points at this not valid statement in sql editor. 4. Click on this link to check that it will leads to wrong statement.
		RESULT: All actions are done correctly.
2	Executing single select statement	1. Enter one sql select statement 2. Click Run SQL to run the statement. 3. The results of the statement is displayed in the lower pane of the SQL Editor.
		RESULT: All actions are done correctly.
2	Opening fiew SQL Editor	1. Enter some sql statement in each SQL Editor 2. Click Run SQL to run the statement for each Sql Editor 3. Close all SQL Editor window 4. Check that also Output window are closing automatically during closing SQL Editors window.
		RESULT: All actions are done correctly.