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

BLR error on restore database with computed by Field [CORE1865] #2295

Closed
firebird-automations opened this issue Apr 24, 2008 · 10 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Armando Boza Gonçalves (armando.boza)

Is related to CORE374
Is related to CORE949

I have two tables, SALLES and ITENS, in the table SALLES i have a computed by field that the sum total value of products in the table ITENS, with the following sql: (select sum (i.total_value) from ITENS i
where i.SALLE_ID = SALLES.SALLE_ID).

I think that in the database restore the table ITENS is created after SALLES table and with it the error occurs.

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

Can reproduce only with "-o" command switch (thanks to dimitr for tip).

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE374 [ CORE374 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE949 [ CORE949 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

This bug (actually, a whole family of related bugs) is fixed in v2.1.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC1 [ 10201 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Not enough information

Test Details: Sent letter to dimitr, 06.03.20118 00:07. Waiting for reply.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

Test Details: Sent letter to dimitr, 06.03.20118 00:07. Waiting for reply. => Sent letter to dimitr, 06.03.20118 00:07. Waiting for reply.
Sent letters to dimitr, 09.03.18 00:30. Waiting for reply.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Not enough information => Done with caveats

Test Details: Sent letter to dimitr, 06.03.20118 00:07. Waiting for reply.
Sent letters to dimitr, 09.03.18 00:30. Waiting for reply.

=>

Could _NOT_ reproduce without use "-o" command switch (thanks to dimitr for tip).

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

Test Details: Could _NOT_ reproduce without use "-o" command switch (thanks to dimitr for tip). => Can reproduce only with "-o" command switch (thanks to dimitr for tip).

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

1 participant