maria-discuss team mailing list archive

Thread
Date
Re: A federation bug was identified.

To: 최혁규 <gurrbrj@xxxxxxxxx>
From: Sergei Golubchik <serg@xxxxxxxxxxx>
Date: Wed, 11 May 2022 10:40:38 +0200
Cc: maria-discuss@xxxxxxxxxxxxxxxxxxx
In-reply-to: <CADYUqMfptp-GnWTcDu2cJiDHg2Qi=+yg-Kj41bzZ4+Ss+1ezxA@mail.gmail.com>
Hi, 최혁규,

It might be a bug, but it's impossible to tell for sure with the
information you've provided. Please, report a bug at jira.mariadb.org
and answer questions there as needed.

You can also specify there whether you use Federated or FederatedX,
what is the version of the second server and what is the structure of
the remote table.

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx

On May 11, 최혁규 wrote:
> 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:입점??88가)',
>   `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.
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
References

A federation bug was identified.
From: 최혁규, 2022-05-11