Issue Details (XML | Word | Printable)

Key: CORE-3024
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Denis Nosov
Votes: 0
Watchers: 0

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

Error "no current record for fetch operation" after ALTER VIEW

Created: 28/May/10 04:27 PM   Updated: 04/Feb/11 01:05 PM
Component/s: Engine
Affects Version/s: 2.5 RC2
Fix Version/s: 2.5.1, 3.0 Alpha 1

OS: Windows Seven (win32)
FB Classic

Target: 2.5.1

 Description  « Hide
When I add field in view (use ALTER VIEW), in parallel connections there is an error.
Use 2 windows isql.

1. In FIRST isql:

create database 'localhost:d:\Program Files\Firebird\bases\test_view.fdb' user 'SYSDBA' password 'masterke' page_size 16384;
create table t(a integer, b integer, c integer);
insert into t values(1,2,3);
create view v(a, b) as
select a, b from t;
select * from v;

           A B
============ ============
           1 2

2. In SECOND isql:

connect 'localhost:d:\Program Files\Firebird\bases\test_view.fdb' user 'SYSDBA' password 'masterke';
select * from v;

           A B
============ ============
           1 2

3. In FIRST isql:

alter view v(a, b, c) as
select a, b, c from t;

4. In SECOND isql:
select * from v;

           A B C
============ ============ ============
Statement failed, SQLSTATE = 22000
no current record for fetch operation

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 31/May/10 01:33 PM
Can you reproduce it in latest snapshot build?

Adriano dos Santos Fernandes added a comment - 31/May/10 01:35 PM
Also, what architecture: super or classic?

Adriano dos Santos Fernandes added a comment - 31/May/10 01:38 PM
Ooops, sorry! I now saw you reported Classic and the bug is presented in latest 2.5.

Alexander Peshkov added a comment - 13/Oct/10 09:30 AM
2.5.1 is using conservative approach - use old format
3.0 is getting ready for requests cache - to support it better we should throw an error when format used in cached request is out of date