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

Jump to bottom

Consistency Check - Firebird 2.1.2.18118 [CORE2605] #3015

Closed
firebird-automations opened this issue Aug 28, 2009 · 6 comments
Closed

Consistency Check - Firebird 2.1.2.18118 [CORE2605] #3015

firebird-automations opened this issue Aug 28, 2009 · 6 comments
Labels
affect-version: 2.1.2 priority: major resolution: duplicate type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Aticom (aticom)

Duplicates CORE2291

When I run a SQL on version 2.1.1.17910, it's all OK

but, when I run the same SQL on version 2.1.2.18118, that gives me the error

internal gds software consistency check (cannot restore singleton select data (284), file: rse.cpp line: 3426)

The SQL - with sub-select - if it canhelp us

Select
PED.OrdemCompra,
PED.CodEmpresa,
PED.NumPedido,
PED.CodVendedor,

(select VEN2.NOMEFANTASIA from VENDEDOR VEN2
where PED.CODVENDEDOR = VEN2.CODVENDEDOR) as DESCVENDEDOR_PEDIDO

from Pedido PED
where
PED.Date between '01/01/2009' and '08/01/2009'
@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

The error is valid!

The sub-select could return multiple rows, which makes it use incorrect.

You would need to use:

(select FIRST 1 VEN2.NOMEFANTASIA from VENDEDOR VEN2 where ...

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Duplicates CORE2291.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE2291 [ CORE2291 ]

@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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.1.2 priority: major resolution: duplicate type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations