Issue Details (XML | Word | Printable)

Key: CORE-4320
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Simonov Denis
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Regression: isql crash when receiving statistics of execution of sql query

Created: 19/Jan/14 09:24 AM   Updated: 26/Dec/15 12:48 PM
Component/s: None
Affects Version/s: None
Fix Version/s: 3.0 Beta 1

Environment: Windows 7 x64, isql, Firebird 3.0.0.30849 x64

QA Status: Cannot be tested


 Description  « Hide
c:\Program Files\Firebird\Firebird_3_0>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> SET NAMES WIN1251;
SQL> CONNECT 'localhost/3051:test' USER 'sysdba' PASSWORD 'masterkey';
Database: 'localhost/3051:test', User: sysdba
SQL> SELECT
CON> T1_ID AS T1_ID,
CON> SUM(ID) AS S
CON> FROM T2
CON> GROUP BY 1;

       T1_ID S
============ =====================
           0 50500
           1 49600
           2 49700
           3 49800
           4 49900
           5 50000
           6 50100
           7 50200
           8 50300
           9 50400

SQL> SET STAT ON;
SQL> SELECT
CON> T1_ID AS T1_ID,
CON> SUM(ID) AS S
CON> FROM T2
CON> GROUP BY 1;

There is a window to terminate the program Firebird SQL Server

IBExpert through query is executed and statistics obtained

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 19/Jan/14 10:17 AM
Field Original Value New Value
Assignee Alexander Peshkov [ alexpeshkoff ]
Dmitry Yemanov made changes - 19/Jan/14 10:19 AM
Affects Version/s 3.0 Alpha 2 [ 10560 ]
Vlad Khorsun made changes - 20/Jan/14 09:08 AM
Assignee Alexander Peshkov [ alexpeshkoff ] Vlad Khorsun [ hvlad ]
Vlad Khorsun made changes - 20/Jan/14 09:14 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 22/Sep/15 09:40 AM
Status Resolved [ 5 ] Closed [ 6 ]
Pavel Zotov made changes - 26/Dec/15 12:48 PM
Status Closed [ 6 ] Closed [ 6 ]
QA Status Cannot be tested