Description:
Here's the important bits from C:\Users\User\AppData\Roaming\MySQL\Workbench\log\wb.log
11:08:43 [INF][ Workbench]: UI is up
11:08:43 [INF][ Workbench]: Running the application
11:09:37 [INF][SQL Editor Form]: Opened connection 'Local instance MySQL80' to MySQL Community Server - GPL version 8.0.23
11:09:37 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
11:09:37 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object
11:09:37 [INF][ WQE.net]: Launching SQL IDE
11:09:38 [INF][ WQE.net]: SQL IDE UI is ready
11:09:47 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png
11:09:47 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png
11:09:47 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
11:09:47 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png
11:09:47 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab partitions: Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_tableman_ext.py", line 1183, in show_table
tab.show_table(schema, table)
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_tableman_ext.py", line 854, in show_table
self.refresh()
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_catalogman_ext.py", line 373, in refresh
self.preload_data(self.get_query())
File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_catalogman_ext.py", line 367, in preload_data
node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field)))
SystemError: invalid column partition_name for resultset
How to repeat:
CREATE TABLE `jo` (
`a` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
PARTITION BY HASH (`a`)
PARTITIONS 3
(PARTITION p0 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEA',
PARTITION p1 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEB',
PARTITION p3 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEC');
Then hit information on the table from the schema navigator.
Go to the partition tab. It shows as blank (prob 1)
Hit refresh and Workbench crashes (prob 2)
Suggested fix:
Don't crash ;)
I'm guessing the slashes are causing a problem
Description: Here's the important bits from C:\Users\User\AppData\Roaming\MySQL\Workbench\log\wb.log 11:08:43 [INF][ Workbench]: UI is up 11:08:43 [INF][ Workbench]: Running the application 11:09:37 [INF][SQL Editor Form]: Opened connection 'Local instance MySQL80' to MySQL Community Server - GPL version 8.0.23 11:09:37 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object 11:09:37 [ERR][SQL Editor Form]: Unable to create db_mgmt_SSHConnectionRef object 11:09:37 [INF][ WQE.net]: Launching SQL IDE 11:09:38 [INF][ WQE.net]: SQL IDE UI is ready 11:09:47 [WRN][ mforms]: Resource file not found: db.Constraints.16x16.png 11:09:47 [WRN][ mforms]: Resource file not found: db.Partitions.16x16.png 11:09:47 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 11:09:47 [WRN][ mforms]: Resource file not found: db.Grants.16x16.png 11:09:47 [ERR][sqlide_tableman_ext.py:show_table:1186]: Error initializing tab partitions: Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_tableman_ext.py", line 1183, in show_table tab.show_table(schema, table) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_tableman_ext.py", line 854, in show_table self.refresh() File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_catalogman_ext.py", line 373, in refresh self.preload_data(self.get_query()) File "C:\Program Files\MySQL\MySQL Workbench 8.0\modules\sqlide_catalogman_ext.py", line 367, in preload_data node.set_string(i, rset.stringFieldValueByName(field) or "" if format_func is None else format_func(rset.stringFieldValueByName(field))) SystemError: invalid column partition_name for resultset How to repeat: CREATE TABLE `jo` ( `a` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci PARTITION BY HASH (`a`) PARTITIONS 3 (PARTITION p0 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEA', PARTITION p1 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEB', PARTITION p3 ENGINE = InnoDB DATA DIRECTORY = 'C:/temp/DRIVEC'); Then hit information on the table from the schema navigator. Go to the partition tab. It shows as blank (prob 1) Hit refresh and Workbench crashes (prob 2) Suggested fix: Don't crash ;) I'm guessing the slashes are causing a problem