Satheesh Bandaram (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-347?page=comments#action_12313495 > ] > > Satheesh Bandaram commented on DERBY-347: > ----------------------------------------- > > The patch looks good, though I would add more description to the CREATE > SYNONYM section. Can we also add the following information? > > * A synonym can be defined for a table/view that doesn't exists at the > synonym creation time. If it doesn't exists, a warning (SQLSTATE 01522) is > raised. The referenced object must be present when a synonym is used in a DML > statement. [snip] > * A synonym can't be defined on a temporary table. (SQLSTATE XCL51)
Is the temp table restriction a DDL time (CREATE SYNONYM) failure or a runtime (when the SYNONYM is used in a statement)? Because error XCL51 doesn't exactly match what you describe. XCL51 indicates the operation cannot reference a table in the SESSION schema, which is where temp tables are defined but that schema can also support normal tables. Dan.
