Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.7, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
Description
SELECT * FROM device ORDER BY moduleTypes ASC LIMIT 1000; |
Without ordering:
It looks right.
CREATE TABLE `device` ( |
`deviceId` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
`atmType` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci', |
`country` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci', |
`customer` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci', |
`flightRecordDir` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci', |
`ignoreSnr` BIT(1) AS (`system` like '%!IGSNR%' or `country` like 'EGT' or `country` like 'PRD%') stored, |
`isInternal` BIT(1) AS (octet_length(`country`) = 3 or `country` like 'PRD%' or `system` like '%!LAB%' or `system` like '%!CAT%' or `system` like '%!INT%' or `customer` like '%LAB') stored, |
`moduleTypes` SET('UNDEFINED','POS','CRS','ATS','ATM','CCDM2','RDS','RM4H','RM4V','CMDV6C','CK1','CMDV6A','FIB','AFD','CM4','ICASH40','ICASH45','ICASH60','ICASH65','OTHER_RETAIL','PROBASE_TRACE','OTHER') NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', |
`path` VARCHAR(255) AS (concat(`country`,'\\',`customer`,'\\',`atmType`,'\\',`system`,'\\',`flightRecordDir`)) virtual, |
`system` VARCHAR(255) NOT NULL COLLATE 'utf8mb3_general_ci', |
`systemHash` VARCHAR(32) AS (md5(concat(`country`,`customer`,`atmType`,`system`))) stored, |
`traceType` ENUM('UNDEFINED','POS','CRS','ATS','ATM','CCDM2','RDS','RM4H','RM4V','CMDV6C','CK1','CMDV6A','FIB','AFD','CM4','ICASH40','ICASH45','ICASH60','ICASH65','OTHER_RETAIL','PROBASE_TRACE','OTHER') NOT NULL COLLATE 'utf8mb3_general_ci', |
PRIMARY KEY (`deviceId`) USING BTREE, |
INDEX `country_index` (`country`) USING BTREE, |
INDEX `customer_index` (`customer`) USING BTREE, |
INDEX `atmType_index` (`atmType`) USING BTREE, |
INDEX `traceType_index` (`traceType`) USING BTREE, |
INDEX `hash_index` (`systemHash`) USING BTREE |
)
|
COLLATE='utf8mb3_general_ci' |
ENGINE=InnoDB
|
AUTO_INCREMENT=13777
|
;
|
Attachments
Issue Links
- relates to
-
MDEV-25056 Server crash in Protocol::net_store_data or corrupt result set upon SELECT with ORDER BY virtual column
- Open
-
MDEV-25120 MariaDB 10.5.6/10.5.8 crash (sig 11) during a SELECT
- Open