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-automations opened this issue Jan 21, 2014 · 9 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Edited details for brevity/readability.

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA587 [ QA587 ]

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test created.

@firebird-automations
Copy link
Collaborator Author

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