phpmyadmin / phpmyadmin/phpmyadmin
[Feat]: Add an option to not modify the executed SQL in any way
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
phpMyAdmin version
5.2.1
Describe the feature
Currently, phpMyAdmin always prepends SET FOREIGN_KEY_CHECKS = OFF; before any executed SQL. This is magical and hides a lot of risks. I see many issues related to this. My current problem is that I want to use phpMyAdmin to query Doris, a supposedly MySQL-compatible database. However, it does not support setting the FOREIGN_KEY_CHECKS variable. But phpMyAdmin always forces adding that variable setting before the query, which prevents any query from being executed.
Describe the solution
Add an option to leave query statements unmodified
Describe the alternatives
No response
Additional context
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing the query execution path that prepends SET FOREIGN_KEY_CHECKS = OFF; and identify how query options are represented. Review the behavior with MySQL-compatible databases such as Doris, then define the option's scope and verify that selected SQL can be executed without modification.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100