On 10/11/2021 11:41, Dmitry Yemanov wrote: > 09.11.2021 03:21, Adriano dos Santos Fernandes wrote: >> >> I think all statements should be split in MON$STATEMENTS and >> MON$COMPILED_STATEMENTS. > > What about execute_immediate? Should they be reported only inside > MON$STATEMENTS or also have a record in MON$COMPILED_STATEMENTS but as > not shareable (bound to the current attachment) or be globally shared > but "shortlived" (destroyed when the request is finished)? >
Considering that in the future even these statements may be stored in the compiled cache for reuse, I'd say they have no special thing. Also I think the mirroring in MON$STATEMENTS would be only due to compatibility. If new columns should be used and are related to Statement classes, they should only be in MON$COMPILED_STATEMENTS, so all statements (requests) must be in both (or only in MON$COMPILED_STATEMENTS when only prepared but not executing). Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
