Why does matlab crash when I try to query from my database(MySql)?

Question

Öyvind Karlsson 2018-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/414968-why-does-matlab-crash-when-i-try-to-query-from-my-database-mysql

评论： Öyvind Karlsson 2018-8-23

crashreport.txt

After updating MySQL (ver.: 8.0.12) MATLAB crashes every time I try to query from the database (MATLAB has encountered an internal problem and needs to close.). I can successfully connection to the DB, but it crashes when I ty to query. I only encounter the problem when trying to query from the DB, otherwise MATLAB seems to run as normal. I encounter the same problem in 2017b and 2018a.

2 个评论
显示无隐藏无

Geoff Hayes 2018-8-15

Öyvind - what is your query? What do you expect it to return? (i.e. how many records are querying for?)

Öyvind Karlsson 2018-8-15

在 MATLAB Online 中打开

I have used the following query, which should return approximately 360 rows/8 columns:

SELECT days.user_id, days.year, days.period, attributes as sickday
FROM days
LEFT JOIN day_results ON days.id = day_results.day_id
LEFT JOIN workout_parts ON day_results.workout_id = workout_parts.workout_id
LEFT JOIN parts ON workout_parts.part_id = parts.id
WHERE (days.user_id = 245 or days.user_id = 64 or days.user_id = 81 or days.user_id = 512 or days.user_id = 244 or days.user_id = 154 or days.user_id = 153 or days.user_id = 449 or days.user_id = 432 or days.user_id = 255 or days.user_id = 210 or days.user_id = 212 or days.user_id = 697 or days.user_id = 730 or days.user_id = 1064  or days.user_id = 553 or days.user_id = 169 or days.user_id = 476 or days.user_id = 172 or days.user_id = 881 or days.user_id = 70 or days.user_id = 167)
AND (days.year < 2018 and days.year >= 2012)
GROUP BY days.id
ORDER BY days.year, days.period, days.week, days.day;