View Issue Details

IDProjectCategoryView StatusLast Update
0008411VALENTINA STUDIOTool - Schema Editorpublic2018-11-22 10:52
ReporterTimo RautiainenAssigned ToSergey Pashkov 
PrioritylowSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSWindowsOS Version10
Product Version8.6.x 
Target Version8.7.xFixed in Version8.7.x 
Summary0008411: Schema editor in tree mode does not show primary key values when multi column PK (MySQL)
DescriptionImage has the view for tables, below create table for same table

CREATE TABLE `kilo_lake` (
  `lake_id` tinyint(2) unsigned NOT NULL,
  `lake_name` varchar(64) NOT NULL,
  `lake_key` varchar(64) NOT NULL,
  `mandatory` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`lake_id`,`lake_key`,`lake_name`),
  KEY `lake_idx` (`lake_key`,`lake_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Primary key has multiple columns for primary key and no auto_increment column. Could this be the problem? Even using MariaDB would guess that same problem exists with Percona server and Oracle MySQL. Just noticed this by accident, I do not use the schema editor for much except viewing columns which is easier than sql query.
TagsNo tags attached.
Working with DB:mySQL Server
Version of your DBMariaDB 10.0.36

Activities

Timo Rautiainen

Timo Rautiainen

2018-11-18 07:49

reporter  

pk_issue.png (8,746 bytes)
Timo Rautiainen

Timo Rautiainen

2018-11-18 07:50

reporter  

pk_describe.png (8,324 bytes)
Sergey Pashkov

Sergey Pashkov

2018-11-18 09:05

developer   ~0010556

Thank you, fix will be available in the next version (8.7)

Issue History

Date Modified Username Field Change
2018-11-18 07:49 Timo Rautiainen New Issue
2018-11-18 07:49 Timo Rautiainen File Added: pk_issue.png
2018-11-18 07:50 Timo Rautiainen File Added: pk_describe.png
2018-11-18 07:59 Sergey Pashkov Assigned To => Sergey Pashkov
2018-11-18 07:59 Sergey Pashkov Status new => assigned
2018-11-18 08:43 Sergey Pashkov Status assigned => confirmed
2018-11-18 09:04 Sergey Pashkov Product Version => 8.6.x
2018-11-18 09:04 Sergey Pashkov Fixed in Version => 8.6.x
2018-11-18 09:04 Sergey Pashkov Target Version => 8.6.x
2018-11-18 09:04 Sergey Pashkov Summary Schema editor does not show primary key values when multi column PK (MySQL) => Schema editor in tree mode does not show primary key values when multi column PK (MySQL)
2018-11-18 09:05 Sergey Pashkov Note Added: 0010556
2018-11-18 09:05 Sergey Pashkov Status confirmed => resolved
2018-11-18 09:05 Sergey Pashkov Resolution open => fixed
2018-11-22 10:52 Ruslan Zasukhin Fixed in Version 8.6.x => 8.7.x
2018-11-22 10:52 Ruslan Zasukhin Target Version 8.6.x => 8.7.x