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

Profiler should not miss query's top-level access paths nodes #7688

Closed
asfernandes opened this issue Jul 29, 2023 · 1 comment
Closed

Profiler should not miss query's top-level access paths nodes #7688

asfernandes opened this issue Jul 29, 2023 · 1 comment

Comments

@asfernandes
Copy link
Member

For example, when explaining this query:

SQL> select 1, (select 2 from rdb$database b) from rdb$database a;

Sub-query
    -> Singularity Check
        -> Table "RDB$DATABASE" as "B" Full Scan
Select Expression
    -> Table "RDB$DATABASE" as "A" Full Scan

The profiler plg$prof_record_sources table misses nodes for Sub-query and Select Expression.

@pavel-zotov
Copy link

pavel-zotov commented Aug 24, 2023

Issue is covered by test for #7687

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

2 participants