maria-discuss team mailing list archive

[최혁규 <gurrbrj@xxxxxxxxx>]

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.