[phpmyadmin/phpmyadmin] 33315f: Add missing limit 1 to foreign key display query
Branch: refs/heads/master Home: https://github.com/phpmyadmin/phpmyadmin Commit: 33315fa209d9273902f29605bf525329a6408174 https://github.com/phpmyadmin/phpmyadmin/commit/33315fa209d9273902f29605bf52... Author: Maximilian Krög <maxi_kroeg@web.de> Date: 2026-07-05 (Sun, 07 July 2026) +02:00 Changed paths: M libraries/classes/Display/Results.php Log Message: ----------- Add missing limit 1 to foreign key display query Signed-off-by: Maximilian Krög <maxi_kroeg@web.de> Commit: b524b3ffefd8265d731a65dc6c853a4debdbb963 https://github.com/phpmyadmin/phpmyadmin/commit/b524b3ffefd8265d731a65dc6c85... Author: Maximilian Krög <maxi_kroeg@web.de> Date: 2026-07-05 (Sun, 07 July 2026) +02:00 Changed paths: M libraries/classes/Display/Results.php Log Message: ----------- Cache foreign key display values Avoid repeated sql queries for foreighn keys, speed things up when duplicate key values are in the result set to display. Signed-off-by: Maximilian Krög <maxi_kroeg@web.de> Commit: 1585f82b5811c9ae3118c1146d2020000d9a3221 https://github.com/phpmyadmin/phpmyadmin/commit/1585f82b5811c9ae3118c1146d20... Author: Maximilian Krög <maxi_kroeg@web.de> Date: 2026-07-05 (Sun, 07 July 2026) +02:00 Changed paths: M sql/create_tables.sql M test/classes/ConfigStorage/RelationTest.php Log Message: ----------- Use utf8mb4 when creating pma tables Signed-off-by: Maximilian Krög <maxi_kroeg@web.de> Commit: 32e55da31376e8217c73be518d8f7961f61cfbe4 https://github.com/phpmyadmin/phpmyadmin/commit/32e55da31376e8217c73be518d8f... Author: Maximilian Krög <maxi_kroeg@web.de> Date: 2026-07-12 (Sun, 07 July 2026) +02:00 Changed paths: M libraries/classes/Controllers/Table/GetFieldController.php M libraries/classes/InsertEdit.php M libraries/classes/Sql.php M test/classes/InsertEditTest.php M test/classes/Stubs/DbiDummy.php Log Message: ----------- Add LIMIT 1 to some queries This is mostly useful for tables that have no unique key. Except for the chnage in InsertEdit::getDisplayValueForForeignTableColumn, which is relevant for multi-column foreign keys. Signed-off-by: Maximilian Krög <maxi_kroeg@web.de> Commit: 411aa8e458abe9fef84755dcff24296348e77c81 https://github.com/phpmyadmin/phpmyadmin/commit/411aa8e458abe9fef84755dcff24... Author: Maurício Meneghini Fauth <mauricio@mfauth.com.br> Date: 2026-07-18 (Sat, 07 July 2026) -03:00 Changed paths: M sql/create_tables.sql M test/classes/ConfigStorage/RelationTest.php Log Message: ----------- Merge pull request #20361 from MoonE/pma-utf8mb4 Use utf8mb4 when creating pma tables Commit: f4b28bcebfae8fff2390e221de1b1d0b0f74b356 https://github.com/phpmyadmin/phpmyadmin/commit/f4b28bcebfae8fff2390e221de1b... Author: Maurício Meneghini Fauth <mauricio@mfauth.com.br> Date: 2026-07-18 (Sat, 07 July 2026) -03:00 Changed paths: M libraries/classes/Display/Results.php Log Message: ----------- Merge pull request #20353 from MoonE/foreigh-key-display-cache Cache foreign key display values and add limit 1 to query Commit: a016b28c7a0c1a0efabcd2e642fd1db63f21396b https://github.com/phpmyadmin/phpmyadmin/commit/a016b28c7a0c1a0efabcd2e642fd... Author: Maurício Meneghini Fauth <mauricio@mfauth.com.br> Date: 2026-07-18 (Sat, 07 July 2026) -03:00 Changed paths: M libraries/classes/Controllers/Table/GetFieldController.php M libraries/classes/InsertEdit.php M libraries/classes/Sql.php M test/classes/InsertEditTest.php M test/classes/Stubs/DbiDummy.php Log Message: ----------- Merge pull request #20372 from MoonE/add-limit-1 Add LIMIT 1 to some queries Commit: 6f427d87850c4c4cc3720adeb8b28b5272b51f79 https://github.com/phpmyadmin/phpmyadmin/commit/6f427d87850c4c4cc3720adeb8b2... Author: Maurício Meneghini Fauth <mauricio@mfauth.com.br> Date: 2026-07-18 (Sat, 07 July 2026) -03:00 Changed paths: M psalm-baseline.xml M resources/js/modules/common.ts M resources/sql/create_tables.sql M src/Controllers/Table/GetFieldController.php M src/Display/Results.php M src/InsertEdit.php M src/Sql.php M tests/unit/ConfigStorage/RelationTest.php M tests/unit/Controllers/CheckRelationsControllerTest.php M tests/unit/Controllers/Database/Fixtures/Export-testController.html M tests/unit/Controllers/Database/Fixtures/Import-testController.html M tests/unit/Controllers/Database/Fixtures/Search-testController.html M tests/unit/Controllers/Database/Fixtures/Sql-testController.html M tests/unit/Controllers/Table/GetFieldControllerTest.php M tests/unit/InsertEditTest.php M tests/unit/Stubs/DbiDummy.php Log Message: ----------- Merge branch 'QA_5_2' Signed-off-by: Maurício Meneghini Fauth <mauricio@mfauth.com.br>
participants (1)
-
Maximilian Krög