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
Some queries raises bugcheck 232 - EVL_expr: invalid operation [CORE2829] #1185
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: @asfernandes They seems related (in the sense of wrong BLR instead of proper error, and the bugcheck message). The cause should also be related, that seems missing nodes not being visited, but different ones. So if you like to mark that as duplication, feel free. I current have no solution and real knowledge of what exactly is wrong. |
Commented by: @asfernandes Another type of query raising this error. When aggregate is used as the second argument of LIST: |
Commented by: @asfernandes Another problematic query (per CORE2872): |
Modified by: @asfernandes |
Commented by: Miroslav Djorov (miro) Firebird version 2.1.3 I have two queries that use similar statements. In the first the statements are in SELECT section, in the second they are in the WHERE section: and SELECT After I've added the part with -SUM(...) in the second query the execution gives this error: |
Commented by: @dyemanov What exactly do you mean by "DB is corrupted"? |
Commented by: Miroslav Djorov (miro) When I've wrote the last message, database validation showed errors in the database. But today I'm making more tests and I can't reproduce the corruption of the database. |
Commented by: @asfernandes After a bugcheck, any command raises bugchecks until you close a database, to prevent more problems. *This* bugcheck do not corrupt the databases. |
Modified by: @pavel-zotovstatus: Open [ 1 ] => Open [ 1 ] QA Status: Covered by another test(s) Test Details: See test for core-2872 |
Submitted by: @asfernandes
Is duplicated by CORE2872
If some aggregate expression of a lower context is inside some expressions like IN, ANY, ALL, it's generated invalid BLR. Example:
select id from account where id in (select count(id) from rdb$database);
====== Test Details ======
See test for core-2872
The text was updated successfully, but these errors were encountered: