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: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 21/Jan/14 05:44 PM
Edited details for brevity/readability.

Sean Leyne made changes - 21/Jan/14 05:44 PM
Field Original Value New Value
Summary ISQL does not destroy the SQL statement Regression: ISQL does not destroy the SQL statement
Description 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;

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

SQL> select 1 from rdb$database;

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

SQL> select 1 from rdb$database;

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

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

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

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

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

SQL> select 1 from rdb$database;

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

SQL> select 1 from rdb$database;

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

SQL> select 1 from rdb$database;

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

SQL> select 1 from rdb$database;

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

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

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

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

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

SQL>

In Firebird 2.5 query returns always the same value

select count(*) from mon$statements;
                COUNT
=====================
                   1
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
Dmitry Yemanov made changes - 21/Jan/14 05:47 PM
Assignee Alexander Peshkov [ alexpeshkoff ]
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.

Alexander Peshkov made changes - 22/Jan/14 11:26 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 29/Mar/14 05:50 PM
Link This issue is related to QA-587 [ QA-587 ]
Pavel Zotov made changes - 28/May/15 02:31 PM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Test min_version = 2.5 rather than 3.0: output the same.
QA Status Done successfully
Pavel Cisar added a comment - 23/Sep/15 12:43 PM
Test created.

Pavel Cisar made changes - 23/Sep/15 12:43 PM
Status Resolved [ 5 ] Closed [ 6 ]