Bug #6752 The default schema cannot be changed to 'x'
Submitted: 22 Nov 2004 17:33 Modified: 23 Nov 2004 18:54
Reporter: Shane D Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.1 OS:Microsoft Windows (Windows)
Assigned to: CPU Architecture:Any

[22 Nov 2004 17:33] Shane D
While inserting data into a table dealing with both varchar and integer objects I would get an error informing that the default schema cannot be changed to...  As it turns out the error occurs when a word in a varchar object contains the string 'use' in any part of the object.  For example: '900 Rough Grouse Way' would return the error "The default schema could not be changed to 'way'."

How to repeat:
Using the Administrator create a new schema with any chosen name.  Within the schema create a table such as bugtest with 3 columns.  Make the first an Integer without the autofill, make the second a varchar(45), make the third column another integer.  Apply the changes.

Open the MySQL Query Browser v 1.1.1 Gamma and begin a new query.  Attempt an insert as follows:

Insert Into TestSchema.BugTest
Values (1,'Text With Use In It',987)

Executing this query will return the result: "The default schema could not be changed to In."
[23 Nov 2004 18:54] MySQL Verification Team
Duplicate for #6654