phpmyadmin / phpmyadmin/phpmyadmin
valid query using IS NULL: no auto-suggestion and returns no results
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
Using 5.2.0-rc1
Regarding this query: UPDATE categories SET categories_image='' WHERE categories_image IS NULL;
Firstly if building the query in the SQL window there is no auto-suggestion for NULL after the IS....which leads me to think the query is incorrect. But, subsequently it is executed but returns no results.
Using the same query in a sql tool integrated into the actual application works as expected so I take it that the query is valid. That particular tool is more finiquity than phpmyadmin so (until this issue), queries would get rejected in that tool but allowed in phpmyadmin, so it seems something is amiss here.
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
Reproduce the query in phpMyAdmin 5.2.0-rc1, checking both the SQL window's NULL suggestion and the UPDATE result against the other SQL tool. Trace the SQL window's suggestion and execution paths, then verify that an IS NULL query is accepted and updates matching rows.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100