You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@predictionio.apache.org by "Naoki Takezoe (JIRA)" <ji...@apache.org> on 2018/09/22 11:59:00 UTC

[jira] [Created] (PIO-169) Foreign key problem in MySQL

Naoki Takezoe created PIO-169:
---------------------------------

             Summary: Foreign key problem in MySQL
                 Key: PIO-169
                 URL: https://issues.apache.org/jira/browse/PIO-169
             Project: PredictionIO
          Issue Type: Bug
          Components: Core
    Affects Versions: 0.13.0
            Reporter: Naoki Takezoe


In the following situation, database initialization process causes SQLSyntaxErrorException.
 * MySQL with utf8mb4 as the default charset
 * INDEX option is enabled

I guess this exception is caused here: [https://github.com/apache/predictionio/blob/49b64ee1538bdba7b6c5958773fa7908ee9f80a2/storage/jdbc/src/main/scala/org/apache/predictionio/data/storage/jdbc/JDBCLEvents.scala#L72]

Originaly, this problem was reported on the users list: [https://lists.apache.org/thread.html/71d645b0c877fd5063981d814505ece28d15e6b8e2403a6692822734@%3Cuser.predictionio.apache.org%3E]

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)