A federation bug was identified.
I have confirmed that the select where query does not work in the multi
index field of some federated tables.
A field in the table is used as a multi index.
My server version : 10.8.2-MariaDB
However, there is no problem with the server used in the previous version.
The previous version is Server version: 10.5.10-MariaDB.
The tested method was compared by creating a federated table on two servers
with different versions.
1. 10.5.10 - MariaDB
-> All queries are normally searched.
2. 10.8.2 - MariaDB
-> Symptoms were confirmed in some multi index types.
--> The table field datatype is (int, datetime)
This is the table I created and the select query.
Table Created
CREATE TABLE `fd_partner_detail` (
`partner_id` varchar(100) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '파트너ID',
`business_name` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '사업자상호명',
`business_no` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '사업자번호',
`online_marketing_business_no` varchar(45) NOT NULL DEFAULT '' COMMENT
'통신판매업 신고번호',
`representative` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '대표자명',
`business_category` char(50) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '종목',
`business_status` char(50) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '업종형태',
`contact` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT
'연락처',
`courier_code` varchar(45) NOT NULL DEFAULT '0' COMMENT '택배사코드',
`postal_code` varchar(45) DEFAULT NULL COMMENT '우편번호',
`address` varchar(45) DEFAULT NULL COMMENT '주소(도로명)',
`address_detail` varchar(45) DEFAULT NULL COMMENT '상세주소',
`officer` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT '' COMMENT
'대표담당자명',
`officer_contact` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '대표담당자연락처',
`officer_email` varchar(45) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '대표담당자이메일',
`order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'발주담당자명',
`order_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '발주담당자연락처',
`order_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '발주담당자이메일',
`calculate_order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '정산담당자명',
`calculate_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '정산담당자연락처',
`calculate_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '정산담당자이메일',
`cs_order_officer` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'CS담당자명',
`cs_officer_contact` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'CS담당자연락처',
`cs_officer_email` varchar(45) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'CS담당자이메일',
`product_name` varchar(100) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '대표상품명',
`product_url` varchar(255) CHARACTER SET utf8mb3 NOT NULL DEFAULT ''
COMMENT '대표상품URL',
`product_type` int(1) NOT NULL DEFAULT 0 COMMENT '대표상품제조구분 (1: 제조, 2:벤더)',
`add_product_name_1` varchar(100) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '선택상품명1',
`add_product_url_1` varchar(255) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'선택상품URL1',
`add_product_type_1` int(1) DEFAULT 0 COMMENT '선택상품제조구분1',
`add_product_name_2` varchar(100) CHARACTER SET utf8mb3 DEFAULT ''
COMMENT '선택상품명2',
`add_product_url_2` varchar(255) CHARACTER SET utf8mb3 DEFAULT '' COMMENT
'선택상품URL2',
`add_product_type_2` int(1) DEFAULT 0 COMMENT '선택상품제조구분2',
`calculate_bank_code` varchar(45) NOT NULL DEFAULT '' COMMENT '정산은행코드',
`calculate_bank_no` varchar(45) NOT NULL DEFAULT '' COMMENT '정산계좌번호',
`calculate_bank_name` varchar(45) NOT NULL DEFAULT '' COMMENT '정산예금주명',
`file_bankbook` varchar(255) DEFAULT '' COMMENT '통장사본',
`original_bankbook` varchar(255) DEFAULT '' COMMENT '통장사본원본명',
`file_business_license` varchar(255) DEFAULT '' COMMENT '사업자등록증',
`original_business_license` varchar(255) DEFAULT '' COMMENT '사업자등록증원본명',
`file_document` varchar(255) DEFAULT '' COMMENT '기타서류',
`original_document` varchar(255) DEFAULT '' COMMENT '기타서류원본명',
`is_terms_service` int(1) NOT NULL DEFAULT 0 COMMENT '쇼핑몰이용약관동의여부',
`is_privacy_consent` int(1) NOT NULL DEFAULT 0 COMMENT '개인정보처리방침동의여부',
`join_status` int(1) NOT NULL DEFAULT 1 COMMENT '가입승인상태(1: 입점대기, 2: 입점반려,
3:입점승인, 4:입점불가)',
`return_cause` text CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '가입반려사유',
`calculate_type` int(1) NOT NULL DEFAULT 1 COMMENT '정산주기유형(1:15일, 2:30일)',
`dormant_change_date` datetime DEFAULT NULL COMMENT '휴면전환일',
`dormant_cancel_date` datetime DEFAULT NULL COMMENT '휴면해제일',
`join_date` datetime DEFAULT NULL COMMENT '가입승인일',
`is_withdraw` int(1) NOT NULL DEFAULT 0 COMMENT '탈퇴회원여부',
`introduce` text DEFAULT NULL COMMENT '회사소개',
`memo` varchar(255) DEFAULT '' COMMENT '관리자 메모',
`corporation_code` varchar(45) CHARACTER SET utf8mb3 NOT NULL COMMENT
'회사코드',
`marketplace_code` varchar(45) CHARACTER SET utf8mb3 NOT NULL COMMENT
'쇼핑몰코드',
`is_abolished` int(1) NOT NULL DEFAULT 0 COMMENT '삭제여부',
`is_popup` int(1) DEFAULT 0 COMMENT '입점 승인',
`application_code` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT
'어플리케이션코드',
`created_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT '생성자',
`created_date` datetime DEFAULT NULL COMMENT '생성일',
`modified_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT
'수정자',
`modified_date` datetime DEFAULT NULL COMMENT '수정일',
`abolished_by` varchar(45) CHARACTER SET utf8mb3 DEFAULT NULL COMMENT
'삭제자',
`abolished_date` datetime DEFAULT NULL COMMENT '삭제일',
PRIMARY KEY (`partner_id`),
KEY `IDX_R_1` (`is_abolished`),
KEY `IDX_R_2` (`created_date`),
KEY `IDX_U_1` (`courier_code`),
KEY `IDX_U_2` (`postal_code`),
KEY `IDX_U_3` (`calculate_bank_code`)
) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC
COMMENT='파트너상세정보' CONNECTION='fdc_partner_bh/fo_partner_detail'
Table Select Query
SELECT business_no, representative, business_name, contact, partner_id
,is_abolished FROM fd_partner_detail WHERE created_date = '1';
Select Query Result
business_no representative business_name contact partner_id
is_abolished
----------- -------------- ------------- ------- ----------
--------------
I want to know if what I checked is a bug.