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 220.127.116.11.0 to 18.104.22.168.0 [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