[Firebird-checkins] SF.net SVN: firebird: [105] qa/trunk/testsuite/bugs.qms

[<pc...@us...>]

Revision: 105
          http://svn.sourceforge.net/firebird/?rev=105&view=rev
Author:   pcisar
Date:     2007-03-29 10:03:13 -0700 (Thu, 29 Mar 2007)

Log Message:
-----------
Test skeletons for CORE-1005, CORE-1006, CORE-1010 and CORE-1029

Added Paths:
-----------
    qa/trunk/testsuite/bugs.qms/core_1005.qmt
    qa/trunk/testsuite/bugs.qms/core_1006.qmt
    qa/trunk/testsuite/bugs.qms/core_1010.qmt
    qa/trunk/testsuite/bugs.qms/core_1029.qmt

Added: qa/trunk/testsuite/bugs.qms/core_1005.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1005.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1005.qmt	2007-03-29 17:03:13 UTC (rev 105)
@@ -0,0 +1,15 @@
+<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0.1</text></argument><argument name="description"><text/></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text>CORE-1005</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text>create table T (A int, B int) ;
+commit ;
+
+insert into T values (1,1);
+insert into T values (1,1);
+insert into T values (2,2);
+insert into T values (3,3);
+insert into T values (null,null);
+insert into T values (null,null);
+insert into T values (4,4);
+commit ;
+</text></argument><argument name="source_code"><text>select distinct A, B from T order by A, B nulls last ;
+select distinct A, B from T order by A nulls last ;
+select distinct A, B from T order by B nulls last ;
+</text></argument><argument name="test_id"><text>core_1005</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>DISTINCT vs NULLS LAST clause: wrong order of NULLs</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Added: qa/trunk/testsuite/bugs.qms/core_1006.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1006.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1006.qmt	2007-03-29 17:03:13 UTC (rev 105)
@@ -0,0 +1,20 @@
+<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Restore From Backup</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text>core1006.fbk</text></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0.1</text></argument><argument name="description"><text>This test takes the server down.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1006</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>set term ^;
+
+EXECUTE BLOCK
+AS
+  DECLARE F1 INT;
+  DECLARE F2 INT;
+BEGIN
+  FOR SELECT T1.ID, T2.ID
+    FROM TABLE1 T1, TABLE2 T2
+    WHERE T1.ID = T2.ID
+    INTO :F1, :F2
+    AS CURSOR CUR
+  DO
+    UPDATE TABLE1 SET NAME = :F1 + :F2 WHERE CURRENT OF CUR;
+END^
+
+set term ;^
+
+rollback;
+</text></argument><argument name="test_id"><text>core_1006</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Added: qa/trunk/testsuite/bugs.qms/core_1010.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1010.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1010.qmt	2007-03-29 17:03:13 UTC (rev 105)
@@ -0,0 +1,27 @@
+<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0.1</text></argument><argument name="description"><text>We have a local buffer overrun in DYN_error(), while copying tdbb_status_vector to local_status. It seems to be the first time (DYN errors + stack trace facility) when 20 status words are not enough to store the complete error info. </text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1010</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>CREATE EXCEPTION RDB$TEST 'Test';
+
+commit;
+
+set term ^ ;
+
+CREATE OR ALTER TRIGGER RDB$PROCEDURES_BIU FOR RDB$PROCEDURES
+ACTIVE AFTER UPDATE OR DELETE POSITION 0
+as
+begin
+    EXCEPTION RDB$TEST;
+end^
+
+commit^
+
+create or alter procedure proctest
+ returns (result integer)
+as
+begin
+  result = 0;
+  suspend;
+end^
+
+set term ; ^
+
+commit;
+</text></argument><argument name="test_id"><text>core_1010</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Local buffer overrun in DYN_error() that takes down the server</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Added: qa/trunk/testsuite/bugs.qms/core_1029.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1029.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1029.qmt	2007-03-29 17:03:13 UTC (rev 105)
@@ -0,0 +1,19 @@
+<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0.1</text></argument><argument name="description"><text/></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text>CORE-1029</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text>create table tb1 (id int, col int) ;
+create index tbi1 on tb1 (id) ;
+create index tbi2 on tb1 (col) ;
+
+insert into tb1 values (1, 1) ;
+insert into tb1 values (2, 2) ;
+insert into tb1 values (1, null) ;
+
+commit;
+</text></argument><argument name="source_code"><text>set plan on;
+
+select * from tb1 a
+  left join tb1 b on a.id = b.id
+  where a.col is null and a.col+0 is null;
+
+select * from tb1 a
+  left join tb1 b on a.id = b.id
+  where a.col+0 is null and a.col is null;
+</text></argument><argument name="test_id"><text>core_1029</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.