[mythtv] Play from last played position
piotr.oniszczuk at gmail.com
Sun May 29 10:46:35 UTC 2022
> This is all what I expected.
> I found my problem.
> It *is* mariadb. From 10.2.1 onwards there is a stricter check on the string used for datetime type for DELETE FROM only. The Z at the end of an ISO8601 is not allowed. Thus the old bookmark/lastplayedpos was not being deleted before the new one was injected.
> phpmyadmin with EXPLAIN pointed me in the correct direction. Strangely enough, SELECT, UPDATE, REPLACE all work ok with a Z suffix on the iso8601 string. The mariadb doco does indicate that trailing Z is not allowed but the DELETE FROM only behaviour is unexpected.
> I have made a PR for further testing as I'm not able to test with mysql. Merge when you think its ok and delete the feature branch.
You may look https://github.com/MythTV/mythtv/issues/490
Root cause is not in MariaDB - but in Qt5 i think....
More information about the mythtv-dev