New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Simulating queries produces unexpected results #13893

Closed
UtopiaMint opened this Issue Dec 27, 2017 · 0 comments

Comments

Projects
None yet
2 participants
@UtopiaMint

UtopiaMint commented Dec 27, 2017

Steps to reproduce

  1. Type an UPDATE query against a table, setting some column to NULL and the WHERE condition actually match some rows. In my case, UPDATE api_keys SET fileid=NULL WHERE fileid='';
  2. Simulate the query
  3. phpMyAdmin shows 0 rows affected while simulating, upon investigating the SELECT query used in the simulation, I found "<> NULL", which is believed to be the cause of matching nothing.
  4. Run the query, and see rows updated != 0

Expected behaviour

Matched rows > 0

Actual behaviour

Matched rows == 0

Server configuration

Operating system:
Ubuntu 17.10 x64

Web server:
lighttpd

Database:
MariaDB 10.1.25

PHP version:
7.1.8-1ubuntu1

phpMyAdmin version:
4.6.6deb5

Client configuration

Browser:
Chromium 63.0.3239.84

Operating system:
Ubuntu 17.10 x64

aswaniprakash added a commit to aswaniprakash/phpmyadmin that referenced this issue Apr 25, 2018

phpmyadmin#13893 issue fix Simulating queries produce unexpected results
Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>

@mauriciofauth mauriciofauth added the bug label May 16, 2018

mauriciofauth added a commit that referenced this issue May 16, 2018

#13893 issue fix Simulating queries produce unexpected results
Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>

@mauriciofauth mauriciofauth self-assigned this May 16, 2018

@mauriciofauth mauriciofauth added this to the 4.8.1 milestone May 16, 2018

mauriciofauth added a commit that referenced this issue May 16, 2018

#13893 issue fix Simulating queries produce unexpected results
Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>
(cherry picked from commit 594cb7b)
Signed-off-by: Maurício Meneghini Fauth <mauriciofauth@gmail.com>

mauriciofauth added a commit that referenced this issue May 16, 2018

Add ChangeLog entry for #13893
Signed-off-by: Maurício Meneghini Fauth <mauriciofauth@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment