commit 1bd19cba4b2c4d43fd78a5a56172ad8bcb153e73
Author: Mike Hanlon <email address hidden>
Date: Fri Nov 14 17:44:16 2014 +0000
Query Invalidation triggered by DDL, phase 1
This first check-in implements most of the framework which will
be used to complete the QI DDL feature. It redefines the old
security invalidation key (SQL_SIKEY) to handle DDL operations in
addition to REVOKE. In a limited number of DDL operations, the object
UIDs of affected Seabase objects are propagated to all nodes for
use by the compiler to invalidate NATable cache entries, as
well as a limited number of types of cached queries. Later this
month, the framework will be complete by allowing prepared queries
that have already been returned from the compiler to be invalidated.
Then the next step for the framework will be support for invalidating
the HTable cache. Finally an effort will be made to cover all of
the necessary DDL operations and all types of cached queries.
The check-in include a new regression test (executor/TEST122) that
demonstrates the cases that are covered. Specifically, a table will
be dropped and recreated with the same name but different definition
in one sqlci session. In another session, which has already populated
NATable cache and query cache for INSERT, UPDATE, DELETE, SELECT,
SELECT COUNT(*), INVOKE and SHOWDDL statements, those some types
of statements will be resubmitted and correctly compiled.
Reviewed: https:/ /review. trafodion. org/693 /github. com/trafodion/ core/commit/ 1bd19cba4b2c4d4 3fd78a5a56172ad 8bcb153e73
Committed: https:/
Submitter: Trafodion Jenkins
Branch: master
commit 1bd19cba4b2c4d4 3fd78a5a56172ad 8bcb153e73
Author: Mike Hanlon <email address hidden>
Date: Fri Nov 14 17:44:16 2014 +0000
Query Invalidation triggered by DDL, phase 1
This first check-in implements most of the framework which will
be used to complete the QI DDL feature. It redefines the old
security invalidation key (SQL_SIKEY) to handle DDL operations in
addition to REVOKE. In a limited number of DDL operations, the object
UIDs of affected Seabase objects are propagated to all nodes for
use by the compiler to invalidate NATable cache entries, as
well as a limited number of types of cached queries. Later this
month, the framework will be complete by allowing prepared queries
that have already been returned from the compiler to be invalidated.
Then the next step for the framework will be support for invalidating
the HTable cache. Finally an effort will be made to cover all of
the necessary DDL operations and all types of cached queries.
The check-in include a new regression test (executor/TEST122) that
demonstrates the cases that are covered. Specifically, a table will
be dropped and recreated with the same name but different definition
in one sqlci session. In another session, which has already populated
NATable cache and query cache for INSERT, UPDATE, DELETE, SELECT,
SELECT COUNT(*), INVOKE and SHOWDDL statements, those some types
of statements will be resubmitted and correctly compiled.
Change-Id: Ie61ce751089b57 ce1894f1764c338 e9400bb7b8a invalidation
Closes-Bug: #1329358
Implements: blueprint ddl-query-