[Firebird-checkins] SF.net SVN: firebird: [327] qa/trunk/testsuite

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

Revision: 327
          http://svn.sourceforge.net/firebird/?rev=327&view=rev
Author:   pcisar
Date:     2007-07-10 04:41:35 -0700 (Tue, 10 Jul 2007)

Log Message:
-----------
QA-47 - Test for CORE-1153
Changed database initialization from backup restore to initialization from SQL script.

Modified Paths:
--------------
    qa/trunk/testsuite/bugs.qms/core_1153.qmt

Removed Paths:
-------------
    qa/trunk/testsuite/fbk/core1153.fbk

Modified: qa/trunk/testsuite/bugs.qms/core_1153.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1153.qmt	2007-07-09 11:39:32 UTC (rev 326)
+++ qa/trunk/testsuite/bugs.qms/core_1153.qmt	2007-07-10 11:41:35 UTC (rev 327)
@@ -1,4 +1,4 @@
-<?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>PLAN SORT (JOIN (MM NATURAL, DD NATURAL))
+<?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>PLAN SORT (JOIN (MM NATURAL, DD NATURAL))
 
 MID                                      DID                                      
 ======================================== ======================================== 
@@ -24,8 +24,39 @@
 Bbb Bbb                                  BBB                                      
 DDD Ddd                                  &lt;null&gt;                                   
 
-</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>core1153.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.1</text></argument><argument name="description"><text/></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1153</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 PLAN ON;
+</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.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-1153</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE D (
+    ID  VARCHAR(40)
+);
 
+
+CREATE TABLE M (
+    ID  VARCHAR(40)
+);
+
+
+INSERT INTO D (ID) VALUES ('AAA');
+INSERT INTO D (ID) VALUES ('aaa');
+INSERT INTO D (ID) VALUES ('Aaa Aaa');
+INSERT INTO D (ID) VALUES ('BBB');
+INSERT INTO D (ID) VALUES ('BBB');
+INSERT INTO D (ID) VALUES ('CCC');
+
+COMMIT WORK;
+
+INSERT INTO M (ID) VALUES ('AAA Aaa');
+INSERT INTO M (ID) VALUES ('AAA Bbb');
+INSERT INTO M (ID) VALUES ('DDD Ddd');
+INSERT INTO M (ID) VALUES ('Bbb Aaa');
+INSERT INTO M (ID) VALUES ('Bbb Bbb');
+
+COMMIT WORK;
+
+CREATE INDEX D_IDX1 ON D COMPUTED BY (upper(id));
+CREATE INDEX M_IDX1 ON M COMPUTED BY (UPPER(ID));
+
+COMMIT WORK;
+</text></argument><argument name="source_code"><text>SET PLAN ON;
+
 ALTER INDEX D_IDX1 INACTIVE;
 
 select distinct mm.ID as MID, dd.ID as DID

Deleted: qa/trunk/testsuite/fbk/core1153.fbk
===================================================================
(Binary files differ)


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