[go: nahoru, domu]

Skip to content
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

CREATE ... SELECT #13141

Closed
paigeweber13 opened this issue Mar 31, 2017 · 2 comments
Closed

CREATE ... SELECT #13141

paigeweber13 opened this issue Mar 31, 2017 · 2 comments
Assignees
Labels
Bug A problem or regression with an existing feature duplicate
Milestone

Comments

@paigeweber13
Copy link

Steps to reproduce

  1. Open table in phpMyAdmin
  2. Click on "SQL" tab
  3. Input a CREATE ... SELECT query, such as "CREATE TEMPORARY TABLE test SELECT * FROM assets_file;"
  4. "SELECT" will be underlined, and phpmyadmin will give the errors "An opening bracket was expected (near SELECT )" and "At least one column definition was expected (near )"
    screen shot 2017-03-31 at 3 29 00 pm
  5. Clicking "go" will succesfully submit the query.

Expected behaviour

The same, but phpmyadmin should not report these errors on a syntactically correct statement.

Actual behaviour

phpMyAdmin reports an error

Server configuration

Operating system: Ubuntu Server 16.04.1 LTS

Web server: Apache/2.4.18 (Ubuntu)

Database: MySQL 5.7.17-0ubuntu0.16.04.1

PHP version: PHP 7.0.15-0ubuntu0.16.04.4 (cli) ( NTS )

phpMyAdmin version: 4.5.4.1

Client configuration

Browser: Google Chrome

Operating system: MacOS Sierra 10.12.4

I recognize that I'm not running the most recent version of myPhpAdmin, but I did not find a bugfix in the later versions and I want to make sure the developers know about this. I did my best to confirm that this bug has not already been reported, but my apologies if I missed something.

@nijel nijel self-assigned this Apr 4, 2017
@nijel nijel added Bug A problem or regression with an existing feature duplicate labels Apr 4, 2017
@nijel
Copy link
Contributor
nijel commented Apr 4, 2017

Please upgrade phpMyAdmin, this issue has been already fixed, see #12109.

@nijel nijel closed this as completed Apr 4, 2017
@nijel nijel added this to the 4.6.0 milestone Apr 4, 2017
@paigeweber13
Copy link
Author

Thank you for directing me to the other issue. My apologies for the duplicate.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Bug A problem or regression with an existing feature duplicate
Projects
None yet
Development

No branches or pull requests

2 participants