COUNT(DISTINCT <DECFLOAT_FIELD>) leads FB to crash when there are duplicate
values of this field
------------------------------------------------------------------------------------------------
Key: CORE-6218
URL: http://tracker.firebirdsql.org/browse/CORE-6218
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 Beta 1
Reporter: Pavel Zotov
Attachments:
firebird.20200109_102731.704191.WI-T4_0_0_1714.stack_trace.7z
Consider following script:
==========
recreate table test0(n decfloat);
commit;
insert into test0 values( 0 );
insert into test0 values( 0 );
commit;
set sqlda_display on;
select n as test0_n from test0;
set sqlda_display off;
commit;
set list on;
set explain on;
select n as n_grouped_from_test0 from test0 group by 1; --- [ 1 ]
select distinct n as n_uniq_from_test0 from test0; -- [ 2 ]
select count(distinct n) as count_uniq_from_test0 from test0; -- [ 3 ]
==========
Statement [ 3 ] will raise crash on recent FB 4.x.
firebird.log will contain after this:
=======
IMAGE-PC1 Thu Jan 9 10:27:31 2020
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.
IMAGE-PC1 Thu Jan 9 10:27:31 2020
INET/inet_error: read errno = 10054, server host = Image-PC1, address =
fe80::fcf1:e33c:e924:969d%16/3439
IMAGE-PC1 Thu Jan 9 10:27:31 2020
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost.
Error writing data to the connection.
send_packet/send
=======
Stack trace can be seen in attached .7z
PS.
If replace records with unique values:
=====
insert into test0 values( 0 );
insert into test0 values( 1 );
=====
-- then count(distinct N) works OK.
Checked on WI-T4.0.0.1714
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
