Bug #16448 create table does not work

• Submitted: 12 Jan 2006 11:54
• Modified: 30 Nov 2006 10:00
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Query Browser
• Severity: S4 (Feature request)
• Version: 1.1.18
• OS: MacOS (mac os x 10.4.4)
• CPU Architecture: Any

[12 Jan 2006 11:54] [ name withheld ]

Description:

create table statement returns error code -1, but same statement works in command line tool mysql.

is query browser limited to select statements, ie. is create table unsupported maybe ?

How to repeat:
- type "create table foo (bar int);" in query area
- execute

gives error code -1 and empty message

Suggested fix:
use command line tool mysql

[16 Jan 2006 13:38] Valeriy Kravchuk

Thank you for a problem report. Surely, QB can be used for all kinds of SQL statements, not only selects. Please, try to repeat with newer version (1.1.18) available at http://dev.mysql.com/downloads/query-browser/1.1.html. And don't forget to select database from the Catalogs first (or add db name, CREATE TABLE db.tab ...). Inform about the results.

[16 Jan 2006 15:02] [ name withheld ]

still there in 1.1.18.

however, not really a bug but more of a usability or documentation problem. one must do a "create table" by first opening a script tab, not the query tab which is displayed by default. not at all obvious.

doing a create table in query tab just returns error -1 with no message.

[30 Nov 2006 10:00] Sveta Smirnova

Thank you for the report.

I can not repeat it in MySQL Query Browser 1.2.6beta