[JBoss JIRA] (TEIIDDES-3217) Error reading Foreign Keys from Mysql 8.0
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIIDDES-3217?page=com.atlassian.jira.plu...
]
Christoph John edited comment on TEIIDDES-3217 at 11/18/18 8:05 PM:
--------------------------------------------------------------------
Hello Steven,
sorry for the late reply. I could now solve the issue. I had no primary key in the table.
Therefore the foreign key was probably not correctly imported. Now the import is working
with mysql8
was (Author: cjohn001):
Hello Steven,
sorry for the late reply. I could now solve the issue. I had no primary key in the table.
Therefore the foreign key was probably not correctly imported. No the import is working
with mysql8
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)
2236
days inactive
2236
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Christoph John (Jira)