[Firebird-checkins] SF.net SVN: firebird:[61019] qa/fbt-repository/trunk/tests

[<ta...@us...>]

Revision: 61019
          http://sourceforge.net/p/firebird/code/61019
Author:   tabloid
Date:     2015-03-19 14:54:31 +0000 (Thu, 19 Mar 2015)
Log Message:
-----------
See added / modified .fbt file(s)

Modified Paths:
--------------
    qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.bat.txt
    qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.conf

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_1846.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_1846.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_1846.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_1846.fbt	2015-03-19 14:54:31 UTC (rev 61019)
@@ -0,0 +1,45 @@
+{
+'id': 'bugs.core_1846',
+'qmid': None,
+'tracker_id': 'CORE-1846',
+'title': 'Allow index walk (ORDER plan) when there is a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B',
+'description': '',
+'min_versions': '3.0',
+'versions': [
+{
+ 'firebird_version': '3.0',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'init_script': 
+  """
+  """,
+ 'test_type': 'ISQL',
+ 'test_script': 
+  """
+    recreate table test(
+       n1 int
+      ,n2 int
+    );
+    commit;
+    
+    insert into test select rand()*100, rand()*100 from rdb$types;
+    commit;
+    
+    create index test_n1_n2_asc on test(n1, n2);
+    commit;
+    create descending index test_n2_n1_desc on test(n2, n1);
+    commit;
+    
+    set planonly;
+    select * from test where n1 = ? order by n2 asc;
+    select * from test where n2 = ? order by n1 desc;
+  """,
+ 'expected_stdout': 
+  """
+    PLAN (TEST ORDER TEST_N1_N2_ASC)
+    PLAN (TEST ORDER TEST_N2_N1_DESC)
+  """,
+  'substitutions': [('=.*','')]
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_1846.fbt
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Modified: qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.bat.txt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.bat.txt	2015-03-19 14:52:00 UTC (rev 61018)
+++ qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.bat.txt	2015-03-19 14:54:31 UTC (rev 61019)
@@ -25,12 +25,13 @@
 copy e20.fd0 e20.fdb 1>nul
 echo.
 echo|set /p=%time%, test: 
-echo.|C:\MIX\firebird\oldfb20\bin\isql -z localhost/3207:C:\MIX\firebird\QA\fbt-repo\tmp\E20.FDB|findstr /i /b /c:"WI-"|findstr /i /e /c:"2.0"
+echo.|%fb20Cs_bin%\isql -z localhost/%fb20Cs_port%:%~dp0e20.fdb|findstr /i /b /c:"WI-"|findstr /i /e /c:"2.0"
 set run_isql=%fb20Cs_bin%\isql localhost/%fb20Cs_port%:%~dp0e20.fdb -i %1 2^>e20Cs.err ^| sed "s/ *$//" 1^>e20Cs.log
 echo "%run_isql%"
 cmd /c %run_isql% 
 @rem 1>e20Cs.log 2>e20Cs.err
 
+
 copy e21.fd0 e21.fdb 1>nul
 echo.
 echo|set /p=%time%, test: 

Modified: qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.conf
===================================================================
--- qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.conf	2015-03-19 14:52:00 UTC (rev 61018)
+++ qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbt-run-all.conf	2015-03-19 14:54:31 UTC (rev 61019)
@@ -1,9 +1,15 @@
-fb21sS_bin=C:\MIX\firebird\fb21\bin
-fb21sS_port=3217
+fb20Cs_bin=C:\MIX\firebird\oldfb20\bin
+fb20Cs_port=3207
 
+fb21Cs_bin=C:\MIX\firebird\oldfb21\bin
+fb21Cs_port=3217
+
 fb25sC_bin=C:\MIX\firebird\fb25\bin
 fb25sC_port=3050
 
+fb30Cs_bin=C:\MIX\firebird\fb30Cs
+fb30Cs_port=3329
+
 fb30sC_bin=C:\MIX\firebird\fb30
 fb30sC_port=3330
 

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