Description:
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."