[Firebird-devel] [FB-Tracker] Created: (CORE-4360) group by from derived table which contains group by on field with LITERAL value returns wrong result

[Pavel Zotov (JIRA)]

group by from derived table which contains group by on field with LITERAL value 
returns wrong result
----------------------------------------------------------------------------------------------------

                 Key: CORE-4360
                 URL: http://tracker.firebirdsql.org/browse/CORE-4360
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 3.0 Alpha 2
            Reporter: Pavel Zotov


LI-T3.0.0.30889

Sample 1.
########
SQL> select c from( select 'a' c from rdb$database group by 'a' ) x group by c;

C
======


SQL>

(record with letter 'a' does not appear)

Sample 2.
########
SQL> select c from( select 123 c from rdb$database group by 1 ) x group by c;

           C
============
           0

(why ZERO ??)

Sample 3.
########
SQL> select c from( select current_timestamp c from rdb$database group by 1 ) x 
group by c;

                        C
=========================
1858-11-17 00:00:00.0000

(this date is known as Modified Julian Day, but it is NOT 'begin of epoch' in 
FB; so, why it is here ?)


PS. Results in LI-V2.5.3.26744 looks OK:

SQL> select c from( select 'a' c from rdb$database  group by 'a' ) x group by c;

C
======
a

SQL> select c from( select 123 c from rdb$database group by 1 ) x group by c;

           C
============
         123

SQL>  select c from( select current_timestamp c from rdb$database group by 1 ) 
x group by c;

                        C
=========================
2014-03-09 09:46:42.0180


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works. 
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel