Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Partitions not showing in MariaDB 10.3

toonces67's profile image toonces67 posted 1 month ago in General Permalink

We upgraded our MariaDB from version 10.1 to version 10.3. After doing so the Partitions tab in HeidiSQL does not show any valid partitions for the table. The CREATE code tab is missing the partition creates as well. The developer was using HeidiSQL version 9.4 and I am using version 10. portable of Heidi with the same result. Any advice?

ansgar's profile image ansgar posted 1 month ago Permalink

Is it a nightly build or the official 10.3 release?

Please also post the result of SHOW CREATE TABLE yourtable here, so I can try to reproduce.

toonces67's profile image toonces67 posted 1 month ago Permalink

Official release, I believe.

This was taken from MySQP Workbench as the table option at the end is not in HeidiSQL.

CREATE TABLE `PKG_INFO` (
  `PKG_INFO_ID` int(11) NOT NULL AUTO_INCREMENT,
  `DAT_SRC_ID` varchar(20) NOT NULL,
  `PHMCY_ID` varchar(45) DEFAULT NULL,
  `SRC_FILL_ID` varchar(45) DEFAULT NULL,
  `FILL_TYP_CD` varchar(12) DEFAULT NULL,
  `PKG_NM` varchar(45) DEFAULT NULL,
  `CURR_PKG_STUS` varchar(45) DEFAULT NULL,
  `PKG_TYP` varchar(45) DEFAULT NULL,
  `PKG_CT` int(11) DEFAULT NULL,
  `NDC_ID` varchar(45) DEFAULT NULL,
  `FDB_MEDCN_ID` int(11) DEFAULT NULL,
  `PROD_ID` varchar(45) DEFAULT NULL,
  `DRUG_NM` mediumtext DEFAULT NULL,
  `LEGL_DRUG_CLS` varchar(45) DEFAULT NULL,
  `NB_OF_BUBL_TX` varchar(45) DEFAULT NULL,
  `PILL_PER_BUBL_TX` varchar(45) DEFAULT NULL,
  `NXT_PKG_STUS` varchar(45) DEFAULT NULL,
  `SRC_DLVRY_RTE_ID` varchar(45) DEFAULT NULL,
  `ORDR_RUN_TM` varchar(45) DEFAULT NULL,
  `ORDR_SHIP_DT` date DEFAULT NULL,
  `ORDR_RUN_TM_UTC` varchar(45) DEFAULT NULL,
  `ORDR_SHIP_DT_UTC` date DEFAULT NULL,
  `SUB_PKG_ID` varchar(25) DEFAULT NULL,
  `SRC_FILL_DTL_ID` varchar(25) DEFAULT NULL,
  `DLVRY_PRTY_CD` varchar(45) DEFAULT NULL,
  `FILL_MTHD_CD` varchar(45) DEFAULT NULL,
  `PKG_BTCH_ID` varchar(45) DEFAULT NULL,
  `NW_ADMT_IN` varchar(4) DEFAULT NULL,
  `DSPNG_SYS_IN` varchar(12) DEFAULT NULL,
  `HSC_DT` datetime DEFAULT NULL,
  `HSC_USR_ID` varchar(80) DEFAULT NULL,
  `HSU_DT` datetime DEFAULT NULL,
  `HSU_USR_ID` varchar(80) DEFAULT NULL,
  `ORDR_FILL_ID` int(11) DEFAULT NULL,
  `ARHVD_FLAG` char(1) DEFAULT NULL,
  `HSC_JOB_DT` varchar(150) DEFAULT NULL,
  `HSC_JOB_END_DT` datetime DEFAULT NULL,
  `SRC_HSC_DT` datetime DEFAULT NULL,
  `VER_NB` int(11) DEFAULT 0,
  PRIMARY KEY (`PKG_INFO_ID`,`DAT_SRC_ID`),
  UNIQUE KEY `IDX21_UNQ_DTL_FILL` (`DAT_SRC_ID`,`SRC_FILL_ID`,`SRC_FILL_DTL_ID`,`SUB_PKG_ID`),
  KEY `IDX1_ORDR_FILL` (`ORDR_FILL_ID`),
  KEY `IDX2_NXT_PKG_STUS` (`NXT_PKG_STUS`),
  KEY `PKG_INFO_IDX11` (`DLVRY_PRTY_CD`),
  KEY `PKG_INFO_IDX12` (`PHMCY_ID`),
  KEY `PKG_INFO_IDX13` (`DAT_SRC_ID`),
  KEY `PKG_INFO_IDX14` (`ORDR_SHIP_DT_UTC`),
  KEY `PKG_INFO_IDX15` (`ORDR_RUN_TM_UTC`),
  KEY `PKG_INFO_IDX16` (`SRC_DLVRY_RTE_ID`),
  KEY `PKG_INFO_IDX17` (`SRC_FILL_DTL_ID`),
  KEY `PKG_INFO_IDX18` (`SUB_PKG_ID`),
  KEY `PKG_INFO_IDX21` (`SRC_FILL_ID`),
  KEY `PKG_INFO_IDX22` (`FILL_TYP_CD`),
  KEY `PKG_INFO_IDX32` (`PKG_BTCH_ID`,`NW_ADMT_IN`),
  KEY `PKG_INFO_IDX31` (`LEGL_DRUG_CLS`),
  KEY `PKG_INFO_IDX33` (`PROD_ID`),
  KEY `IDX_SUMM_RPT` (`DAT_SRC_ID`,`PHMCY_ID`,`ORDR_SHIP_DT`,`ORDR_RUN_TM`,`SRC_DLVRY_RTE_ID`,`DLVRY_PRTY_CD`)
) ENGINE=InnoDB AUTO_INCREMENT=144532449 DEFAULT CHARSET=utf8
 PARTITION BY LINEAR KEY (`DAT_SRC_ID`)
PARTITIONS 50;

Please login to leave a reply, or register at first.