77324[TASK] Show explain selection in DB check only for Mysql
Commit message
Review
-
Code review CR +2 Done
- Christian Kuhn +2
- Stefan Bürk +1
-
Verified V +2 Done
- Christian Kuhn +2
- Stefan Bürk +1
- core-ci +1 CI
Issues 1
Files 1
Review log 1518
-
Georg Ringer uploaded patch set 1 01/11/23, 07:24
-
Georg Ringer commented on patch set 1 01/11/23, 07:24
This change is ready for review. -
core-ci voted on patch set 1 V +1 01/11/23, 07:32 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/35669
-
Andreas Kienast commented on patch set 1 01/11/23, 08:17
DatabaseIntegrityController.php:157IMO `$connection->getDatabasePlatform() instanceof AbstractMySQLPlatform` is more stable here. -
Andreas Kienast commented on patch set 1 01/11/23, 08:23
DatabaseIntegrityController.php:157ReplyOf course with the according negation... -
Georg Ringer uploaded patch set 2
V +101/11/23, 11:11 -
core-ci voted on patch set 2 V +1 01/11/23, 11:18 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/35677
-
Christian Kuhn commented on patch set 2 01/11/23, 11:44
maybe v11 as well? -
Georg Ringer updated the commit message in patch set 3
V +101/11/23, 11:51 -
core-ci voted on patch set 3 V +1 01/11/23, 11:59 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/35679
-
Stefan Bürk commented on patch set 3 CR -1 01/11/23, 13:18
Basicly, all supported dbms types and versions supports query explains, not only "MySQL". At least so far I know and could look up in quick search. So,we should recheck this here more precisly. Beside this, if we need a check - the check should be based upon the platform class, as already mentioned by Andreas in the commend of the check. `AbstractMySQLPlatform` would match MySQL and MariaDB connections in all versions, what `MySQLPlatform` would do also. doctrine/dbal 2.x (TYPO3 v11) does not have `AbstractMySQLPlatform`, thus this *must* be changed on the backport or we use `MySQLPlatform` directly if we want to really narrow this down to only a specific set of dbms. What have to be checked, if the "result" does differ between the differnt dbms. For example MSSQL would return a "xml" if I remember it right. (v11 as dropped in v12). So far as a quick look comment. Well do a detailed look later and come back, thus -1 for now. And I think there is reason why dbal do not have a abstraction for that. -
Christian Kuhn commented on patch set 3 01/12/23, 09:10
Stefan, I think adding support in our db-api for explain is overkill: currently, the query just crashes with sqlite/postgres and we don't have any api to express 'explain' in our API. As such, the patch is reasonable: have it for maria/mysql, skip it for others. If someone really needs 'explain' in this edge feature, it could be requested later for other dbms and we may *then* want to look at possible api along the way. what do you think? -
Christian Kuhn commented on patch set 3 01/12/23, 09:13
Reply
If we agree on that, the only question is if we keep the test for 'AbstractMySQLPlatform', or go with something different, or keep in main and change in backport. what's your opinion on that? -
Stefan Bürk commented on patch set 3 CR +1 01/12/23, 09:24
Reply
Had a look yesterday, just forgot to update the comment here. You are right, extending the API for that is an overkill. If really needed, we can enhance this eventually in this module for other dbms if requested, but leaving it out for now. Patch is fine imo, just in the backport we should change to `MySQLPlatform` for the instanceof check.Reply
DoneReply
DoneDatabaseIntegrityController.php:157ReplyDone -
Stefan Bürk voted on patch set 3 V +1 01/12/23, 09:32
-
Christian Kuhn commented on patch set 3 V +1 CR +1 01/12/23, 11:40
Reply
Ack -
Christian Kuhn voted on patch set 3 V +2 CR +2 01/16/23, 16:40
-
Christian Kuhn merged patch set 4 01/16/23, 16:40