[
https://issues.jboss.org/browse/TEIIDDES-3217?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-3217:
------------------------------------------
I can confirm that the import is successful on just the Teiid side, including the foreign
key:
{code}
CREATE FOREIGN TABLE "IMS_db.ClientCompany" (
idClientCompany long NOT NULL AUTO_INCREMENT OPTIONS (ANNOTATION '', NAMEINSOURCE
'`idClientCompany`', NATIVE_TYPE 'INT UNSIGNED'),
CompanyName string(255) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE
'`CompanyName`', CHAR_OCTET_LENGTH 765, NATIVE_TYPE 'VARCHAR'),
Street string(255) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE
'`Street`', CHAR_OCTET_LENGTH 765, NATIVE_TYPE 'VARCHAR'),
StreetNumber string(45) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE
'`StreetNumber`', CHAR_OCTET_LENGTH 135, NATIVE_TYPE 'VARCHAR'),
CityCode string(45) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE
'`CityCode`', CHAR_OCTET_LENGTH 135, NATIVE_TYPE 'VARCHAR'),
City string(255) NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE '`City`',
CHAR_OCTET_LENGTH 765, NATIVE_TYPE 'VARCHAR'),
fkCountry long NOT NULL OPTIONS (ANNOTATION '', NAMEINSOURCE
'`fkCountry`', NATIVE_TYPE 'INT UNSIGNED'),
CONSTRAINT "PRIMARY" PRIMARY KEY(idClientCompany),
CONSTRAINT fkCountry FOREIGN KEY(fkCountry) REFERENCES IMS_db.Country (idCountry)
) OPTIONS (ANNOTATION '', NAMEINSOURCE '`IMS_db`.`ClientCompany`',
UPDATABLE TRUE, "teiid_rel:fqn" 'catalog=IMS_db/table=ClientCompany',
"teiid_rel:source_type" 'TABLE');
{code}
Error reading Foreign Keys from Mysql 8.0
-----------------------------------------
Key: TEIIDDES-3217
URL:
https://issues.jboss.org/browse/TEIIDDES-3217
Project: Teiid Designer
Issue Type: Bug
Components: Teiid Integration
Affects Versions: 11.1.3
Reporter: Christoph John
Priority: Major
I am currently trying to use TEIID designer together with a mysql 8.0 database to import
a source model. Unfortunately, foreign keys cannot be read correctly. I assume it has to
do with the VISIBLE flag on the index. Is there a known workaround available for mysql
8.0?
--
This message was sent by Atlassian Jira
(v7.12.1#712002)