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