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

Add way to retrieve statement BLR with Statement::getInfo and ISQL's SET EXEC_PATH_DISPLAY BLR #6910

Closed
asfernandes opened this issue Jul 26, 2021 · 2 comments

Comments

@asfernandes
Copy link
Member

asfernandes commented Jul 26, 2021

Info codes to be used with Statement::getInfo:

#define isc_info_sql_exec_path_blr_bytes	31
#define isc_info_sql_exec_path_blr_text		32

To make isc_info_sql_exec_path_blr_* work, session must be first execute set debug option dsql_keep_blr = true.

ISQL command:

In ISQL, set debug option must not be used directly, instead user should use set exec_path_display blr.

SET EXEC_PATH_DISPLAY BLR/OFF

Retrieves the execution path of a DML statement formatted as BLR text.

Warning: this feature is very tied to engine internals and its usage is discouraged
if you do not understand very well how these internals are subject to change between
versions.
@pavel-zotov
Copy link

Sent letter to Adriano, 28.07.2021 17:32, waiting for reply.

asfernandes added a commit that referenced this issue Jul 28, 2021
asfernandes added a commit that referenced this issue Jul 28, 2021
asfernandes added a commit that referenced this issue Jul 28, 2021
…ent::getInfo and ISQL's SET EXEC_PATH_DISPLAY BLR."

This reverts commit ddc8b7a.
asfernandes added a commit that referenced this issue Jul 28, 2021
asfernandes added a commit that referenced this issue Jul 28, 2021
asfernandes added a commit that referenced this issue Jul 28, 2021
…ent::getInfo and ISQL's SET EXEC_PATH_DISPLAY BLR."

This reverts commit c93e848.
@asfernandes
Copy link
Member Author

Sent letter to Adriano, 28.07.2021 17:32, waiting for reply.

Unfortunately it was only working with embedded.

I've rolled back the feature and will think in another way to implement it.

asfernandes added a commit that referenced this issue Jul 30, 2021
…Info and ISQL's SET EXEC_PATH_DISPLAY BLR.
asfernandes added a commit that referenced this issue Jul 30, 2021
…Info and ISQL's SET EXEC_PATH_DISPLAY BLR.
asfernandes added a commit that referenced this issue Jul 30, 2021
asfernandes added a commit that referenced this issue Jul 30, 2021
…Info and ISQL's SET EXEC_PATH_DISPLAY BLR.
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