My Oracle Support Banner

Incorrect Cache Group DDL Syntax Is Not Rejected With An Error (Doc ID 1105914.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version to [Release 7.0 to 11.2]
Information in this document applies to any platform.
This Note is of interest to all developers and DBAs creating applications running on TimesTen which use the Cache Grid facility to create Cache Groups.


Given the following Cache Group DDL:

This syntax is incorrect. The where-clause on TABLEA is misplaced and should be included in the reference to TABLEA and not at the end of the cache group definition. The various AND clauses are redundant as they are implied in the various foreign key relationships defined in the cache group; there is no need for them in the DDL statement.

However, even though the syntax is incorrect, no error is generated and a cache group will be created. However, the  where-clause restrictions for TABLEA and TABLEC will be ignored because they are improperly positioned. The resulting cache group will have many more rows then intended because the where-clause restrictions are ignored.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.