Bug #97995 Manual give preference defaults than show in MWB
Submitted: 16 Dec 2019 9:05 Modified: 24 Jan 2020 19:44
Reporter: Paul Weiss Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Documentation Severity:S3 (Non-critical)
Version:8, revision: 64534 OS:Any
Assigned to: CPU Architecture:Any
Tags: preferences

[16 Dec 2019 9:05] Paul Weiss
Description:
The manual give preference defaults that are different from those showing in MWB, in a fresh install on a new computer, and sometimes the manual is internally inconsistent:

General Editors >  SQL Identifiers are Case Sensitive 
	MWB = off
	manual = image shows on, text says on, but the brackets show off

SQL Editor > DBMS connection read timeout interval (in seconds) 
	MWB = 30
	manual = image shows 30, but brackets show 600

SQL Editor > Safe Updates
	MWB = on
	manual = image is cut off, but brackets show off

SQL Editor > Query Editor > Change keywords to UPPER CASE 
	MWB = on
	manual= image shows on, text says on, but brackets show off

Modeling > MySQL > Default Target MySQL Version
	MWB = 8.0.18
	manual = 5.7

Modeling > MySQL > SQL_MODE to be used in generated scripts

Others > Log Level
	MWB = info
	manual = image shows debugs, text says info
	(differencespreceded by asterisk)
	MWB = 
		ERROR_FOR_DIVISION_BY_ZERO
		NO_ENGINE_SUBSTITUTION
		NO_ZERO_DATE
		NO_ZERO_IN_DATE
		*ONLY_FULL_GROUP_BY
		STRICT_TRANS_TABLES
	manual = TRADITIONAL,ALLOW_INVALID_DATES, which is:
		*ALLOW_INVALID_DATES
		ERROR_FOR_DIVISION_BY_ZERO
		NO_ENGINE_SUBSTITUTION
		NO_ZERO_DATE
		NO_ZERO_IN_DATE
		*STRICT_ALL_TABLES
		STRICT_TRANS_TABLES (which should not be needed if STRICT_ALL_TABLES is set, right?)

Modeling > Diagram > Expand New Objects; Propagate Object Color Changes to All Diagrams; Show Column Types 
	MWB = on
	manual = image and text show on, but brackets show off

SSH > SSH BufferSize 
	MWB = 10240
	manual = image and text show 500

SSH > SSH Maximum File Size 
	MWB = 104857600
	manual = image and text show 500

How to repeat:
Display MWB preferences on a fresh install, and relevant manual pages.

Suggested fix:
Update manual.
[16 Dec 2019 10:03] MySQL Verification Team
Hello Paul,

Thank you for the report and feedback!

Thanks,
Umesh
[24 Jan 2020 19:44] Christine Cole
Posted by developer:
 
Adjusted to MySQL Workbench 8.0.19 values.

Thank you for the report.