Bug #8630 Executing a query with the SchemaOnly option reads the entire resultset

• Submitted: 20 Feb 2005 2:52
• Modified: 25 Feb 2005 23:42
• Reporter: Henrik Johnson
• Status: Closed
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 1.0.4
• OS: Windows (Windows)
• Assigned to: Reggie Burnett
• CPU Architecture: Any

[20 Feb 2005 2:52] Henrik Johnson

Description:
If you execute a command using the SchemaOnly option although the result is correct it will result in the entire query will be fetched from the database even though none of it except the actual schema is of interest which can be really slow if you have a large query that you want to get the schema of.

How to repeat:
Executing any query with the schema only option should make it obvious.

Suggested fix:
There is already a set limit thing that is in place for single row operation that can be easily adapted for the schemaonly (Limit to 0 rows).

[25 Feb 2005 23:42] Reggie Burnett

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html