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

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

Revision: 322
          http://svn.sourceforge.net/firebird/?rev=322&view=rev
Author:   pcisar
Date:     2007-07-07 12:11:18 -0700 (Sat, 07 Jul 2007)

Log Message:
-----------
QA-47 - Test for CORE-1153

Added Paths:
-----------
    qa/trunk/testsuite/bugs.qms/core_1153.qmt
    qa/trunk/testsuite/fbk/core1153.fbk

Added: qa/trunk/testsuite/bugs.qms/core_1153.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1153.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1153.qmt	2007-07-07 19:11:18 UTC (rev 322)
@@ -0,0 +1,44 @@
+<?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))
+
+MID                                      DID                                      
+======================================== ======================================== 
+AAA Aaa                                  AAA                                      
+AAA Aaa                                  Aaa Aaa                                  
+AAA Aaa                                  aaa                                      
+AAA Bbb                                  AAA                                      
+AAA Bbb                                  aaa                                      
+Bbb Aaa                                  BBB                                      
+Bbb Bbb                                  BBB                                      
+DDD Ddd                                  &lt;null&gt;                                   
+
+PLAN SORT (JOIN (MM NATURAL, DD NATURAL))
+
+MID                                      DID                                      
+======================================== ======================================== 
+AAA Aaa                                  AAA                                      
+AAA Aaa                                  Aaa Aaa                                  
+AAA Aaa                                  aaa                                      
+AAA Bbb                                  AAA                                      
+AAA Bbb                                  aaa                                      
+Bbb Aaa                                  BBB                                      
+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;
+
+ALTER INDEX D_IDX1 INACTIVE;
+
+select distinct mm.ID as MID, dd.ID as DID
+from m mm
+left outer join d dd
+  on upper(mm.id) starting upper(dd.id)
+order by mm.id ;
+
+ALTER INDEX D_IDX1 ACTIVE;
+
+select distinct mm.ID as MID, dd.ID as DID
+from m mm
+left outer join d dd
+  on upper(mm.id) starting upper(dd.id)
+order by mm.id ;
+</text></argument><argument name="test_id"><text>core_1153</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>Activating index change &quot;STARTING&quot; working as &quot;LIKE&quot; in join condition</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/fbk/core1153.fbk
===================================================================
(Binary files differ)


Property changes on: qa/trunk/testsuite/fbk/core1153.fbk
___________________________________________________________________
Name: svn:mime-type
   + application/octet-stream


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