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
Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit [CORE4708] #5016
Comments
Modified by: @livius2Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovFix Version: 3.0 RC 1 [ 10584 ] |
Modified by: @dyemanovFix Version: 3.0 RC 1 [ 10584 ] => |
Modified by: @dyemanovFix Version: 3.0.0 [ 10048 ] |
Modified by: @dyemanovsummary: content of MON$EXPLAINED_PLAN in MON$STATEMENTS is limited to 14 808 bytes => Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] Test Details: Test query has explained plan with length ~47 Kb (checked on WI-V3.0.0.32253). |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @livius2
I read that to get unlimited text of explained plan i should look into
TMP$STATEMENTS
but i got limited text in MON$EXPLAINED_PLAN in MON$STATEMENTS for some big
query
it end after 14 808 bytes as
"Select Expression
-"
nothing more
Commits: 3b04931 FirebirdSQL/fbt-repository@04e7897
====== Test Details ======
Test query has explained plan with length ~47 Kb (checked on WI-V3.0.0.32253).
Instead of checking explained plan text it is enough only to ensure that its
LENGTH is more than 32K and that text is not cuted off, i.e. it should end with
phrase: Table "MON$STATEMENTS" Full Scan
Another sample of query that has long plan see in core_5061.fbt
The text was updated successfully, but these errors were encountered: