335544721 when selecting view with round [CORE1338]

[firebird-automations]

Submitted by: ramengo (ramengo)

Is related to QA175

create table a (a numeric(15,15))

insert into a values(2)

create view b(a) as select round(a,2) from a

select * from b

The latter raises the following:
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements

Engine Code : 335544721
Engine Message :
Unable to complete network request to host "localhost".
Error reading data from the connection.

Then the Guardian blinks.

Commits: a2d61a0

[firebird-automations]

Commented by: ramengo (ramengo)

Sorry, the version used is 2.1 beta1 2.1.0.15999

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: Sean Leyne (seanleyne)

Version: 2.1 Beta 1 [ 10141 ]

Version: 2.1 Alpha 1 [ 10150 ] =>

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ] => Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 Beta 2 [ 10190 ]

[firebird-automations]

Commented by: Maciej Kaczkowski (maciejkaczkowski)

probably any function in view make this message, for example:
create view c(a) as select dateadd(1 DAY FOR CURRENT_DATE) from a
create view d(a) as select rand() from a

and the same error message appear in computed by field
CREATE TABLE v (
I INTEGER,
z COMPUTED BY (RAND())
);
SELECT * FROM v;

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA175 [ QA175 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 12483 ] => Firebird [ 14897 ]

[firebird-automations]

Commented by: @pmakowski

Q/A test ok

[firebird-automations]

Modified by: @pmakowski

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

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully