View Issue Details

IDProjectCategoryView StatusLast Update
0002122Database Workbench v6MySQL Modulepublic2023-04-24 10:07
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version6.2.0 
Summary0002122: Binary defaults not handled when fetching meta data in older versions of MySQL due to MySQL bug
DescriptionExample:

CREATE TABLE enerwp_wfcrawlers (
  IP Binary(16) NOT NULL DEFAULT 0x0102030405060708,
  patternSig Binary(16) NOT NULL,
  status NChar(8) NOT NULL,
  lastUpdate int unsigned NOT NULL,
  PTR NVarChar(255) DEFAULT '',
  PRIMARY KEY (
    IP,
    patternSig
  )
) ENGINE=InnoDB AVG_ROW_LENGTH=390 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


TagsNo tags attached.

Activities

Martijn Tonies

2023-03-28 09:13

administrator   ~0000580

Database Workbench will work around the MySQL bug.

Issue History

Date Modified Username Field Change
2023-02-27 09:07 Martijn Tonies New Issue
2023-03-27 15:05 Martijn Tonies Assigned To => Martijn Tonies
2023-03-27 15:05 Martijn Tonies Status new => assigned
2023-03-27 15:05 Martijn Tonies Description Updated
2023-03-27 15:48 Martijn Tonies Summary Binary defaults not handled when fetching meta data => Binary defaults not handled when fetching meta data in older versions of MySQL
2023-03-28 09:13 Martijn Tonies Summary Binary defaults not handled when fetching meta data in older versions of MySQL => Binary defaults not handled when fetching meta data in older versions of MySQL due to MySQL bug
2023-03-28 09:13 Martijn Tonies Note Added: 0000580
2023-03-28 09:15 Martijn Tonies Status assigned => resolved
2023-03-28 09:15 Martijn Tonies Resolution open => fixed
2023-03-28 09:15 Martijn Tonies Fixed in Version => 6.2.0
2023-04-24 10:07 Martijn Tonies Status resolved => closed