View Incident Report

Minor

Reported By: Adam Brett [Tropical Wholefoods]
Reported On: 3/15/2021
For: Version 2.33 Build 2

# 4798 Views Can Be Created that Reference Temporary Tables

It is possible to create a VIEW which references a Temporary Table.

When the user restarts the machine, the Temporary table does not exist and many actions in the database generate an error.

It would be preferable to either dis-allow creation of VIEWs against temporary tables, or to change how EDB tests a database to remove these errors.

CREATE TEMPORARY TABLE "MyTable"
  ("Date1" DATE,
   "Time1" VARCHAR(20))

CREATE View MyView AS
SELECT * FROM MyTable

Comments

ElevateDB now treats temporary tables as effectively being invisible for the purposes of being referenced in views. Any temporary table referenced in a view will now result in a "table not found" exception.

Resolution

Fixed Problem on 3/16/2021 in version 2.34 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap