phpmyadmin / phpmyadmin/phpmyadmin
Obvious functions missing in type autocomplete suggestions
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
Describe the bug
The whole SQL autocomplete is a complete disaster.
However here's one particular instance in which it miserably fails to do its job
To Reproduce
Steps to reproduce the behavior:
- Go to the SQL tab
- Start typing: "SELECT UNIX_" (without quotes)
Expected behavior
The autocomplete should suggest at least the function UNIX_TIMESTAMP(). That's certainly a result that exists. I don't know if there are more.
Observed behavior
No automplete suggestions
Screenshots
If applicable, add screenshots to help explain your problem.
Server configuration
https://demo.phpmyadmin.net/master-config/
Client configuration
- Browser: Chrome
- Operating system: Ubuntu 20.04
Additional context
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 in the SQL tab's autocomplete behavior and reproduce the issue with SELECT UNIX_. Check how function suggestions are sourced and matched for MySQL/MariaDB; the work is done when UNIX_TIMESTAMP() appears among the suggestions for that input.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, mysql, php
- Domain
- databases, frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100