Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Regression: ISQL does not destroy the SQL statement [CORE4321] #4644

Closed
firebird-issue-importer opened this issue Jan 21, 2014 · 9 comments
Closed

Comments

@firebird-issue-importer

Submitted by: @sim1984

Is related to QA587

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

Commits: 9f0f251 FirebirdSQL/fbt-repository@2d6624b

====== Test Details ======

Test min_version = 2.5 rather than 3.0: output the same.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 21, 2014

Commented by: Sean Leyne (seanleyne)

Edited details for brevity/readability.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 21, 2014

Modified by: Sean Leyne (seanleyne)

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 

summary: ISQL does not destroy the SQL statement => Regression: ISQL does not destroy the SQL statement

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 21, 2014

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 22, 2014

Commented by: @AlexPeshkoff

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.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 22, 2014

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 29, 2014

Modified by: @pcisar

Link: This issue is related to QA587 [ QA587 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 28, 2015

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

Test Details: Test min_version = 2.5 rather than 3.0: output the same.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 23, 2015

Commented by: @pcisar

Test created.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 23, 2015

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants