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

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

Revision: 60765
          http://sourceforge.net/p/firebird/code/60765
Author:   tabloid
Date:     2015-02-23 17:52:41 +0000 (Mon, 23 Feb 2015)
Log Message:
-----------
See added .fbt file(s)

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

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

Added: qa/fbt-repository/trunk/tests/bugs/core_4694.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_4694.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_4694.fbt	2015-02-23 17:52:41 UTC (rev 60765)
@@ -0,0 +1,97 @@
+{
+'id': 'bugs.core_4694',
+'qmid': None,
+'tracker_id': 'CORE-4694',
+'title': '"Column unknown" error while preparing a recursive query if the recursive part contains ALIASED datasource in the join with anchor table',
+'description': '',
+'min_versions': '2.5.4',
+'versions': [
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+    recreate table xcall_stack (
+        xcall_id int
+        ,xcaller_id int
+    );
+    commit;
+    
+    set planonly;
+    
+    with recursive
+    r as (
+        select c.xcall_id
+        from xcall_stack c
+        where c.xcaller_id is null
+    
+        UNION ALL
+    
+        select
+               c.xcall_id
+        from xcall_stack c
+        join r
+          AS h -- <<<<<<<<<<<<<<<<<<<<<< ::: NB ::: `r` is aliased
+          on c.xcaller_id = h.xcall_id
+    )
+    select r.xcall_id
+    from r;
+  """,
+ 'expected_stdout': 
+  """
+    PLAN (R C NATURAL)
+    PLAN (R C NATURAL)
+  """,
+ 'expected_stderr': 
+  """
+  """
+},
+{
+ 'firebird_version': '3.0',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+    recreate table xcall_stack (
+        xcall_id int
+        ,xcaller_id int
+    );
+    commit;
+    
+    set planonly;
+    
+    with recursive
+    r as (
+        select c.xcall_id
+        from xcall_stack c
+        where c.xcaller_id is null
+    
+        UNION ALL
+    
+        select
+               c.xcall_id
+        from xcall_stack c
+        join r
+          AS h -- <<<<<<<<<<<<<<<<<<<<<< ::: NB ::: `r` is aliased
+          on c.xcaller_id = h.xcall_id
+    )
+    select r.xcall_id
+    from r;
+  """,
+ 'expected_stdout': 
+  """
+    PLAN (R C NATURAL, R C NATURAL)
+  """,
+ 'expected_stderr': 
+  """
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_4694.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/fbt-run.bat.txt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/tabloid/fbt-run.bat.txt	2015-02-23 15:50:23 UTC (rev 60764)
+++ qa/fbt-repository/trunk/tests/functional/tabloid/fbt-run.bat.txt	2015-02-23 17:52:41 UTC (rev 60765)
@@ -1,4 +1,5 @@
 @echo off
+setlocal enabledelayedexpansion enableextensions
 cls
 @rem File name: C:\firebird\QA\fbt-repo\fbt-run.bat 
 @rem It is recommended to put this file in the 'top-level' folder - "QA\fbt-repo".
@@ -13,6 +14,17 @@
 set /p curdir= < tmp.tmp.tmp
 del tmp.tmp.tmp
 
+set cdprefix=
+set find_what=%~dp0
+set repl_with=
+for /f "tokens=* delims=\" %%a in ("%curdir%") do (
+  echo %%a
+  set string=%%a
+  set cdprefix=!string:%find_what%=%repl_with%!
+  set cdprefix=!cdprefix:tests\=%repl_with%!
+  set cdprefix=!cdprefix:\=.!
+)
+
 set fbt_name=%~n1
 set fb25home=C:\MIX\firebird\fb25\bin
 set fb30home=C:\MIX\firebird\fb30
@@ -30,15 +42,32 @@
 echo ------------------------------------------------------->>fbt-run.30.log
 %fb30home%\fbsvcmgr localhost/%fb30port%:service_mgr user %isc_user% password %isc_password% info_server_version 1>>fbt-run.30.log 2>&1
 echo.
-echo Running for 2.5 . . .
-fbt_run -b %fb25home% bugs.%fbt_name% -o localhost/%fb25port% 1>>fbt-run.25.log 2>fbt-run.25.err
-echo Running for 3.0 . . .
-fbt_run -b %fb30home% bugs.%fbt_name% -o localhost/%fb30port% 1>>fbt-run.30.log 2>fbt-run.30.err
+set fbt_run=fbt_run -b %fb25home% %cdprefix%.%fbt_name% -o localhost/%fb25port%
+echo Command: %fbt_run%>>fbt-run.25.log
+echo Running for 2.5: %fbt_run%
+cmd /c %fbt_run% 1>>fbt-run.25.log 2>fbt-run.25.err
 
+set fbt_run=fbt_run -b %fb30home% %cdprefix%.%fbt_name% -o localhost/%fb30port%
+echo Command: %fbt_run%>>fbt-run.30.log
+echo Running for 3.0: %fbt_run%
+cmd /c %fbt_run% 1>>fbt-run.30.log 2>fbt-run.30.err
+
 set overall=0
 set e25size=0
 set e30size=0
 
+:chkn25
+findstr /B /I "Nothing to run" fbt-run.25.log 1>nul 2>&1
+if errorlevel 1 goto chkn30
+set overall=1
+goto showlog
+
+:chkn30
+findstr /B /I "Nothing to run" fbt-run.30.log 1>nul 2>&1
+if errorlevel 1 goto chk_25
+set overall=1
+goto showlog
+
 :chk_25
 findstr /B /I "FAIL ERROR" fbt-run.25.log 1>nul 2>&1
 if errorlevel 1 goto chk_30
@@ -62,6 +91,8 @@
   set overall=1
 )
 
+:showlog
+
 echo ^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^| Log25: start  ^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|
 type fbt-run.25.log
 echo ^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^| Log25: finish ^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|^|

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