Issue Details (XML | Word | Printable)

Key: CORE-4321
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Simonov Denis
Votes: 0
Watchers: 4
Operations

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

Regression: ISQL does not destroy the SQL statement

Created: 21/Jan/14 05:37 PM   Updated: 23/Sep/15 12:43 PM
Component/s: ISQL
Affects Version/s: None
Fix Version/s: 3.0 Beta 1

Environment: Firebird 3.0.0.30854, isql
Issue Links:
Relate
 

QA Status: Done successfully
Test Details: Test min_version = 2.5 rather than 3.0: output the same.


 Description  « Hide
SQL> connect 'localhost:test' user 'sysdba' password 'masterkey';
Database: 'localhost:test', User: sysdba
SQL> select 1 from rdb$database;

    CONSTANT
============
           1

SQL> select 1 from rdb$database;
SQL> select 1 from rdb$database;
SQL> select 1 from rdb$database;

SQL> select count(*) from mon$statements;

                COUNT
=====================
                    5

SQL> commit;
SQL> select count(*) from mon$statements;

                COUNT
=====================
                    6

SQL> select 1 from rdb$database;
SQL> select 1 from rdb$database;
SQL> select 1 from rdb$database;
SQL> select 1 from rdb$database;

SQL> select count(*) from mon$statements;

                COUNT
=====================
                    6

SQL> commit;
SQL> select count(*) from mon$statements;

                COUNT
=====================
                   12


In Firebird 2.5 query returns always the same value

select count(*) from mon$statements;
                COUNT
=====================
                   1

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
Pavel Cisar added a comment - 23/Sep/15 12:43 PM
Test created.

Alexander Peshkov added a comment - 22/Jan/14 11:26 AM
Denis, it's much better to report regressions in snapshots into devel list instead of tracker. You see yourself - you can;t show a version affected by the bug.

Sean Leyne added a comment - 21/Jan/14 05:44 PM
Edited details for brevity/readability.