1) "Auto On All Schemas" is on for MySQL DB. Look at attached screenshot auto-on-all. Are the values for 1 & 2 correct? For "2", should it be "<schema name"> (e.g. "root") instead of "[<ALL>]"?
2) "Auto On All Schemas" if off for MySQL DB. Look at attached screenshot auto-all-off. Are the values for 3 & 4 correct?
|
18 KB
|
19 KB
This is correct, even though it looks weird. See SQLStdCompletionQuery.Line-518
Top left of window is either "<ALL>" or the current schema which is indicated in the toolbar. See SQLStdCompletionQuery.Line-484
Schema column is the name of the schema for the table. See SQLStdCompletionQuery.Line-624, SQLTableResultItem.Line-62
Jenny -- lets follow what MySQL does. Even though it's a bit inconsistent, we haven't received any user complaints. Also, the code changes for MySQL might have also have some unintended consequences.
So, the behavior for sqlite should be:
Jenny -- lets follow what MySQL does. Even though it's a bit inconsistent, we haven't received any user complaints. Also, the code changes for MySQL might have also have some unintended consequences.
So, the behavior for sqlite should be:
When "Auto On All Schemas", schema name is now set to "<ALL>" instead of "<DEFAULT>".
For the Schema and Username values in the Query Analyzer toolbar, it has been decided to leave them as blank. See Issue #7950.
When "Auto On All Schemas", schema name is now set to "<ALL>" instead of "<DEFAULT>".
For the Schema and Username values in the Query Analyzer toolbar, it has been decided to leave them as blank. See Issue #7950.
Verified for MySQL and SQLite.
Fixed in Version: 13.0-rc-4 and Build #: 31199
Verified for MySQL and SQLite.
Fixed in Version: 13.0-rc-4 and Build #: 31199
Issue #7885 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 30191 |
No time estimate |
This is correct, even though it looks weird. See SQLStdCompletionQuery.Line-518
Top left of window is either "<ALL>" or the current schema which is indicated in the toolbar. See SQLStdCompletionQuery.Line-484
Schema column is the name of the schema for the table. See SQLStdCompletionQuery.Line-624, SQLTableResultItem.Line-62