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

Query builder doesn't work when selected column is * #14049

Closed
nulll-pointer opened this Issue Mar 1, 2018 · 0 comments

Comments

Projects
None yet
2 participants
@nulll-pointer
Contributor

nulll-pointer commented Mar 1, 2018

Steps to reproduce

  1. Open query builder
  2. select any table and column to be *
  3. Update and then submit query.

Expected behaviour

Query should be executed

Actual behaviour

Doesn't execute the query, query doesn't show up on the console.

Server configuration

Operating system:
Ubuntu 16.04 LTS

Web server:
Apache/2.4.29 (Unix)

Database:
mysqlnd 5.0.12-dev

PHP version:
7.1.14

phpMyAdmin version:
4.8.0-dev

Client configuration

Firefox 58.0.2

Edit

The following error is sent in the response.
error

I think the problem is with mysql as executing SELECT test.* FROM test; in cli gives the same error, it converts the query into SELECT 'test.* FROM 'test'; which is not an existing column.

aswaniprakash added a commit to aswaniprakash/phpmyadmin that referenced this issue Mar 13, 2018

query builder issue phpmyadmin#14049 fix
Signed-off-by: aswani <aswani15prakash@gmail.com>

aswaniprakash added a commit to aswaniprakash/phpmyadmin that referenced this issue Mar 13, 2018

query builder issue phpmyadmin#14049 fix
Signed-off-by: aswani <aswani15prakash@gmail.com>

aswaniprakash added a commit to aswaniprakash/phpmyadmin that referenced this issue Mar 13, 2018

query builder issue phpmyadmin#14049 fix
Signed-off-by: aswani <aswani15prakash@gmail.com>

@mauriciofauth mauriciofauth added the bug label Mar 30, 2018

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

phpmyadmin#14049 query builder issue fix
Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>

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

phpmyadmin#14049 issue fix Query builder doesn't work when the select…
…ed column is *

Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>

@mauriciofauth mauriciofauth self-assigned this Apr 24, 2018

@mauriciofauth mauriciofauth added this to the 4.8.1 milestone Apr 24, 2018

mauriciofauth added a commit that referenced this issue Apr 24, 2018

#14049 issue fix Query builder doesn't work when the selected column …
…is *

Signed-off-by: Aswani Prakash <aswani15prakash@gmail.com>
(cherry picked from commit 5f3f484)
Signed-off-by: Maurício Meneghini Fauth <mauriciofauth@gmail.com>

mauriciofauth added a commit that referenced this issue Apr 24, 2018

Add ChangeLog entry for #14049
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