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
There are no subversion log entries for this issue yet.