Bug #26647 Prepared Statements don't work

• Submitted: 26 Feb 2007 21:19
• Modified: 27 Apr 2007 8:13
• Reporter: William Chiquito
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.2.10, 1.2.8 beta
• OS: Windows (Windows)
• CPU Architecture: Any
• Tags: prepared statements

[26 Feb 2007 21:19] William Chiquito

Description:
Prepared Statements don't work.

I do not obtain result at the time of executing query.

How to repeat:
START TRANSACTION;
SET @a=20;
PREPARE STMT FROM 'SELECT * FROM city LIMIT ?';
EXECUTE STMT USING @a;
DEALLOCATE PREPARE STMT;
COMMIT;

[27 Feb 2007 7:22] Valeriy Kravchuk

Thank you for a problem report. Do you use Script Tab or ResultSet tab for this test?

[27 Feb 2007 12:38] William Chiquito

I used ResultSet tab.

[28 Feb 2007 17:01] Valeriy Kravchuk

Try to use Script Tab and inform about the results. QB may use separate connection for each statement in ResultSet tab (known feature/problem).

[28 Feb 2007 18:23] William Chiquito

Used Script Tab and I obtain equal result.

[28 Feb 2007 18:24] William Chiquito

Used Script Tab and I obtain equal result.

[2 Mar 2007 19:07] Valeriy Kravchuk

Verified just as described with QB 1.2.10 on Windows XP. I'd expect same results as in mysql command line client, but I do not get results of SELECT in any form.

[2 Mar 2007 19:08] Valeriy Kravchuk

Verified just as described with QB 1.2.10 on Windows XP. I'd expect same results as in mysql command line client, but I do not get results of SELECT in any form.

[2 Mar 2007 19:09] Valeriy Kravchuk

Verified just as described with QB 1.2.10 on Windows XP. I'd expect same results as in mysql command line client, but I do not get results of SELECT in any form.

[27 Apr 2007 8:13] Michael G. Zinner

Prepared statements are not supported by the Query Browser at this point in time.