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

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

Revision: 61556
          http://sourceforge.net/p/firebird/code/61556
Author:   tabloid
Date:     2015-05-16 06:28:58 +0000 (Sat, 16 May 2015)
Log Message:
-----------
See added / modified .fbt file(s)

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

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

Added: qa/fbt-repository/trunk/tests/bugs/core_4735.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_4735.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_4735.fbt	2015-05-16 06:28:58 UTC (rev 61556)
@@ -0,0 +1,38 @@
+{
+'id': 'bugs.core_4735',
+'qmid': None,
+'tracker_id': 'CORE-4735',
+'title': "Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)",
+'description': '',
+'min_versions': '3.0',
+'versions': [
+{
+ 'firebird_version': '3.0',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'test_type': 'ISQL',
+ 'init_script': 
+  """
+  """,
+ 'test_script': 
+  """
+    recreate table test(bar boolean primary key using index test_pk, foo boolean, "Foo" boolean, "Bar" boolean);
+    commit;
+    create index test_compound1 on test(foo, bar);
+    create index test_compound2 on test("Foo", "Bar", foo, bar);
+    commit;
+
+    set plan on;
+    select * from test where bar IS true; -- PK
+    select * from test where foo IS NOT true and bar IS distinct from foo; -- compound1
+    select * from test where "Foo" IS NOT false and "Bar" IS true and foo is not distinct from bar; -- compound2
+  """,
+ 'expected_stdout':
+  """
+    PLAN (TEST INDEX (TEST_PK))
+    PLAN (TEST INDEX (TEST_COMPOUND1))
+    PLAN (TEST INDEX (TEST_COMPOUND2))
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_4735.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/1fbreplace.bat.txt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbreplace.bat.txt	2015-05-16 00:09:59 UTC (rev 61555)
+++ qa/fbt-repository/trunk/tests/functional/tabloid/batches/1fbreplace.bat.txt	2015-05-16 06:28:58 UTC (rev 61556)
@@ -23,18 +23,20 @@
 setlocal enabledelayedexpansion enableextensions
 
 @rem check that 7-Zip is avaliable:
-7z 1>%~n0.log 2>&1
+7za 1>%~n0.log 2>&1
 findstr /i /c /b "7-Zip" %~n0.log 1>nul 2>&1
 if errorlevel 1 (
   del %~n0.log
-  echo 7-Zip archiver is required for this batch.
+  echo,
+  echo 7za.exe - command line stand alone version of 7-Zip archiver - is required for this batch for backups.
+  echo Download it from: http://sourceforge.net/projects/sevenzip/files/7-Zip and save in some of PATH folder
   goto end
 )
 del %~n0.log 2>nul
 
 @rem List of Firebird services to be upgraded:
-set FB_SERVICES=fb30Cs fb30sC fb30sS
-@rem set FB_SERVICES=fb30Cs
+set FB_SERVICES=%1
+if .%1.==.. set FB_SERVICES=fb30Cs fb30sC fb30sS
 
 @rem Folder where downloaded snapshot files are:
 set SNAPSHOT_DIR=C:\1INSTALL\FIREBIRD\snapshot_builds\30
@@ -112,12 +114,15 @@
 
   echo !time! Packing previous FB build to !archname!>>%log%
   @rem set cmd_run=rar u -m5 -ep1 -idp -r -dh !archname! !fp!\doc !fp!\include !fp!\intl !fp!\lib !fp!\plugins !fp!\*.conf !fp!\*.dll !fp!\*.exe !fp!\*.bat !fp!\firebird.msg !fp!\security*.fdb
-  set cmd_run=7z u -bd -r -ssw !archname! !fp!\doc !fp!\include !fp!\intl !fp!\lib !fp!\plugins !fp!\*.conf !fp!\*.dll !fp!\*.exe !fp!\*.bat !fp!\firebird.msg !fp!\security*.fdb
+  set cmd_run=7za u -bd -r -ssw !archname! !fp!\doc !fp!\include !fp!\intl !fp!\lib !fp!\plugins !fp!\*.conf !fp!\*.dll !fp!\*.exe !fp!\*.bat !fp!\firebird.msg !fp!\security*.fdb
   echo !time! !cmd_run!
   cmd /c !cmd_run! 1>>%log% 2>&1
 
   echo Done.
   echo !time! Done.>>%log%
+  dir !archname! | findstr /i /c:!archname! 1>%~n0.err 2>&1
+  type %~n0.err>>%log%
+  type %~n0.err
 
   set fn=!fp!\fbclient.dll
   if exist !fn! (

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