TEIID30118 Cannot create temporary table "table name" error in DV6
Issue
CREATE LOCAL TEMPORARY TABLE <table name>
fails with
TEIID30118 Cannot create temporary table `<table name>`. An object with the same name already exists.
Environment
- Red Hat JBoss Data Virtualization (DV) 6.0
- Red Hat JBoss Developer Studio (JBDS) 7.1.0
- Teiid Designer plugin 8.3.1.Final-v20140122-1920-B21
<table name>
s are unique within a single stored procedure
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.