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

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

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

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_3611.fbt
    qa/fbt-repository/trunk/tests/functional/tabloid/core_3611_aux.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_3611.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_3611.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_3611.fbt	2015-02-23 15:50:23 UTC (rev 60764)
@@ -0,0 +1,105 @@
+{
+'id': 'bugs.core_3611',
+'qmid': None,
+'tracker_id': 'CORE-3611',
+'title': 'Wrong data while retrieving from CTEs (or derived tables) with same column names',
+'description': '',
+'min_versions': '2.5.2',
+'versions': [
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+    recreate table t(
+      tab_name char(31) character set unicode_fss,
+      sum1_abc int,
+      sum1_oth int,
+      sum2_abc int,
+      sum2_oth int
+    );
+    commit;
+    
+    insert into t(tab_name, sum1_abc, sum1_oth)
+    with
+    fields_abc as (
+        select rdb$relation_name, count(*) cnt
+        from rdb$relation_fields
+        where rdb$field_name<'rdb$d'
+        group by 1
+    ),
+    fields_other as (
+        select rdb$relation_name, count(*) cnt
+        from rdb$relation_fields
+        where rdb$field_name>='rdb$d'
+        group by 1
+    )
+    ,fields_all as (
+        select
+            substring(r.rdb$relation_name from 1 for 5) tab_name,
+            sum(f1.cnt) sum_abc,
+            sum(f2.cnt) sum_other
+        from rdb$relations r
+        left join fields_abc f1 on f1.rdb$relation_name=r.rdb$relation_name
+        left join fields_other f2 on f2.rdb$relation_name=r.rdb$relation_name
+        where r.rdb$flags is null
+        group by 1
+    )
+    select tab_name, sum_abc, sum_other from fields_all
+    ;
+    
+    insert into t(tab_name, sum2_abc, sum2_oth)
+    with
+    fields_abc as (
+        select rdb$relation_name, count(*) cnt
+        from rdb$relation_fields
+        where rdb$field_name<'rdb$d'
+        group by 1
+    ),
+    fields_other as (
+        select rdb$relation_name, count(*) cnt____________
+        from rdb$relation_fields
+        where rdb$field_name>='rdb$d'
+        group by 1
+    )
+    ,fields_all as (
+        select substring(r.rdb$relation_name from 1 for 5) tab_name,
+        sum(f1.cnt) sum_abc,
+        sum(f2.cnt____________) sum_other
+        from rdb$relations r
+        left join fields_abc f1 on f1.rdb$relation_name=r.rdb$relation_name
+        left join fields_other f2 on f2.rdb$relation_name=r.rdb$relation_name
+        where r.rdb$flags is null
+        group by 1
+    )
+    select tab_name, sum_abc, sum_other from fields_all
+    ;
+    commit;
+    
+    select
+        tab_name
+        ,min(sum1_abc) as sum1_abc
+        ,min(sum2_abc) as sum2_abc
+        ,min(sum1_oth) as sum1_oth
+        ,min(sum2_oth) as sum2_oth
+    from t
+    group by tab_name
+    having
+        min(sum1_abc) is distinct from min(sum2_abc)
+        or
+        min(sum1_oth) is distinct from min(sum2_oth)
+    ;
+  """,
+ 'expected_stdout': 
+  """
+  """,
+ 'expected_stderr': 
+  """
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_3611.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
Added: qa/fbt-repository/trunk/tests/functional/tabloid/core_3611_aux.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/tabloid/core_3611_aux.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/functional/tabloid/core_3611_aux.fbt	2015-02-23 15:50:23 UTC (rev 60764)
@@ -0,0 +1,41 @@
+{
+'id': 'functional.tabloid.core_3611_aux',
+'qmid': None,
+'tracker_id': 'CORE-3611',
+'title': 'Wrong data while retrieving from CTEs (or derived tables) with same column names',
+'description': 'See another sample in this ticket (by dimitr, 30/Oct/12 07:13 PM)',
+'min_versions': '2.5.2',
+'versions': [
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'init_script':
+  """
+  """,
+ 'test_script':
+  """
+    set planonly;
+    with tab as
+    (
+    select 1 as p1
+    from rdb$relations
+    )
+    select f1.p1, f2.p1 as p2
+    from tab f1 cross join tab f2
+    group by f1.p1
+    ;
+  """,
+ 'expected_stdout': 
+  """
+  """,
+ 'expected_stderr': 
+  """
+    Statement failed, SQLSTATE = 42000
+    Dynamic SQL Error
+    -SQL error code = -104
+    -Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/functional/tabloid/core_3611_aux.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
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.