Bug #105534 The Aggregate Functions Count, Sum, Min and Max are not working,
Submitted: 11 Nov 2021 15:40 Modified: 18 Nov 2021 12:56
Reporter: Charles Yagle Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:8.0.27 OS:Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[11 Nov 2021 15:40] Charles Yagle
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Bob\AppData\Roaming\MySQL\Workbench\log\wb.log]

09:58:08 [ERR][      Workbench]: Console redirection failed.
09:58:08 [INF][      Workbench]: Starting up Workbench
09:58:09 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 35406859
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41902080
09:58:09 [INF][      Workbench]: Environment variables:
	SystemDrive = C:
	ProgramFiles(x86) = C:\Program Files (x86)
	ProgramW6432 = C:\Program Files
	PROCESSOR_IDENTIFIER = AMD64 Family 22 Model 48 Stepping 1, AuthenticAMD
	TMP = C:\Users\Bob\AppData\Local\Temp
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files\Common Files\Oracle\Java\javapath;C:\app\Bob\product\18.0.0\dbhomeXE\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Hewlett-Packard\SimplePass\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\QuickTime\QTSystem\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\Tools\Binn\;C:\Program Files\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files\Azure Data Studio\bin;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\dotnet\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Bob\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\Bob\AppData\Local\Programs\Python\Python39\;C:\Users\Bob\AppData\Local\Microsoft\WindowsApps;;C:\Program Files\Azure Data Studio\bin;C:\Program Files\JetBrains\PyCharm Community Edition 2020.3.3\bin;;C:\Users\Bob\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\Bob\.dotnet\tools
	PyCharm Community Edition = C:\Program Files\JetBrains\PyCharm Community Edition 2020.3.3\bin;
	QTJAVA = C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip
	PROCESSOR_REVISION = 3001
	TEMP = C:\Users\Bob\AppData\Local\Temp
	USERPROFILE = C:\Users\Bob
	LOGONSERVER = \\CHARLES-HP
	USERNAME = Bob
	SystemRoot = C:\WINDOWS
	FP_NO_HOST_CHECK = NO
	OneDrive = C:\Users\Bob\OneDrive
	USERDOMAIN_ROAMINGPROFILE = CHARLES-HP
	CommonProgramFiles = C:\Program Files\Common Files
	PROCESSOR_LEVEL = 22
	ProgramData = C:\ProgramData
	HOMEPATH = \Users\Bob
	OneDriveConsumer = C:\Users\Bob\OneDrive
	COMPUTERNAME = CHARLES-HP
	PCBRAND = Pavilion
	CommonProgramW6432 = C:\Program Files\Common Files
	MOZ_PLUGIN_PATH = C:\Program Files (x86)\Foxit PhantomPDF\plugins\
	SESSIONNAME = Console
	DriverData = C:\Windows\System32\Drivers\DriverData
	HOMEDRIVE = C:
	windir = C:\WINDOWS
	CLASSPATH = .;C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip
	NUMBER_OF_PROCESSORS = 4

How to repeat:
The aggregate functions appear in gray in the coding section, all other commands appear blue. This h.appens when I attempt to use an aggregate function
[18 Nov 2021 12:56] MySQL Verification Team
Hello Charles Yagle,

Thank you for the report and feedback.

regards,
Umesh