diff --git a/mysql-test/suite/innodb/include/bug91091.inc b/mysql-test/suite/innodb/include/bug91091.inc new file mode 100644 index 00000000000..c792bd5dbc8 --- /dev/null +++ b/mysql-test/suite/innodb/include/bug91091.inc @@ -0,0 +1,159 @@ +DELETE FROM t WHERE c2 = '*****12889aaTHLIN_ACQS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****12889aaTHLIN_FRFT_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****12889aaTNM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****12889aaTTNOF_r2aaT_N5' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****12889aaTPRGP_PSSG_r2aaT_N5' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****r2889aaTHLIN_ACQS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****r2889aaTHLIN_FRFT_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****r2889aaTBUSI_NO_S10' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****r2889aaTNM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****r2889aaTTNOF_r2aaT_N5' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_SGI_CUR_TNOF_TRM_N5' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_SGI_ANIN_AMT_N17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_ANUL_HLTH_INPM_PAYM_TOT_AMT_N17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MN3_AVG_PAY_MM_AMT_N17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_INCM_YR_HLIN_RAT_N9' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_INPM_NPAM_YN_S1' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'OCUP_CD' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'SINDS_CD' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_SUSPBZ_CLBS_DIV_S1' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'ENCM_BIZ_OPNG_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'WRST_BZPL_TLNO_S14' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'CUR_WRST_FRFT_YN_S1' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'TNOF_INFO_BASE_DENL_TRGT_YN_S1' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_FLNM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_SBSR_DIV_S20' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_BZPL_NM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_ACQS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_FRFT_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_RBF_SBSR_DIV_S20' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_RBF_BZPL_NM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_RBF_ACQS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_RBF_FRFT_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_QLFC_CFNT_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1GieBoo3iISS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1GieBoo3iISS_NO_S64' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1GieBoo3iBZPL_NM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1GieBoo3iPAYR_NO_S64' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1GieBoo3iS4' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i01Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i02Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i03Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i04Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i05Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i06Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i07Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i08Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i09Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i10Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i11Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****ieBoo3i12Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1G_RBYR_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1G_RBYR_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1G_RBYR_BZPL_NM_S60' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1G_RBYR_PAYR_NO_S64' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****eWioc1G_RBYR_S4' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_01Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_02Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_03Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_04Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_05Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_06Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_07Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_08Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_09Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_10Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_11Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RBYR_12Ahzei9u17' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = 'HLIN_PBCR_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haHLIN_PBCR_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CHCR2889aaTAMT_RATE_N9' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CHCR2889aaTAMT_N17' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CHCR_CSVC2889aaTAMT_RATE_N9' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CHCR_CSVC2889aaTAMT_N17' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_30_TTW_EXCS_DONT_EXIS_YN_S1' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_IDVD_PNSN_HOLD_YN_S1' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = 'equ4aiH_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haequ4aiH_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RIID_TRSF_roo2aaT_MCNT_N5' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_RIID_MN6_PAYAM_N17' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FRDM_INDP_TRSF_roo2aaT_MCNT_N5' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FRDM_INDP_MN6_PAYAM_N17' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DEP_ACCO_TOT_AMT_N17' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = 'FNNS_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haFNNS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CMCM_NROM_PAYM_MCNT_N5' AND c1 = 'Eid4i*******11372012******haCMCM_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CMCM_USE_FARE_N17' AND c1 = 'Eid4i*******11372012******haCMCM_*****_******00'; +DELETE FROM t WHERE c2 = 'CMCM_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haCMCM_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_FLNM_S60' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_MRGE_YN_S1' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_SPOS_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_SPOS_NTIV_YN_S1' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_FMLY_RLT_****_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = 'FMLY_RLT_PRF_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BSIC_****_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BSIC_****_FLNM_S60' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BSIC_****_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BSIC_****_SELF_NTRED_YN_S1' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BSIC_****_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = 'SUPCR_BSIC_PRF_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_FLNM_S60' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_RSDTNO_S24' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_SPOS_RSDTNO_S24' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_YR5_WN_YN_S1' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_MDRLT_****_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = 'MRDT_PRF_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haMRG_RLT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_FRNM_S100' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_BISNO_S24' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_RPTV_S60' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSIgooN3aePRF_BZPL_LCTN_S100' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BZPL_ZPCD_S6' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BZPL_LCTN_ZADR_S200' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BZPL_LCTN_DTAD_S100' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_NM_OPBS_DT_S8' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_NMgooN3aeDT_S8' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_BUSI_RGCR_NM_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = 'BUSIgooN3aePRF_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF_FLNM_S60' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF_RVRS_YR_S4' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF128890aaTN17' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****128890aaTPRF_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = 'INCM_AMT_PRF_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haINCM_AMT_PRF_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_FLNM_S60' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_HHLD_RLT_S30' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_CRSD_ADDR_S100' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CRSD_ZPCD_S6' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CRSD_ZADR_S200' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_CRSD_DTAD_S100' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_CRSD_MVIN_DT_S8' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_MNRT_CHLD_CNT_N3' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_HSPR_CNT_N3' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_**********_CRCP_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '**********_CRCP_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******ha**********_CRCP_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_FLNM_S60' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_LTLY_ADDR_S100' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_LTLY_ZPCD_S6' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_LTLY_ZADR_S200' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_LTLY_DTAD_S100' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_LTLY_ADDR_MVIN_DT_S8' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****_DFRS_ISS_DT_S8' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = 'DFRS_GTH_MTCD_S2' AND c1 = 'Eid4i*******11372012******haDFRS_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_ISS_NO_S64' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_FLNM_S60' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_RSDT_NO_S24' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_PNSN_KIND_S60' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_TOT_AMT_N17' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_MM_AMT_N17' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_01_PRVS_DT_S8' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_01_iD1ohph_YM_S6' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; +DELETE FROM t WHERE c2 = '*****Ejae7ov****_01_iD1ohph_YM_AMT_N17' AND c1 = 'Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00'; diff --git a/mysql-test/suite/innodb/r/bug91091.result b/mysql-test/suite/innodb/r/bug91091.result new file mode 100644 index 00000000000..7ff2fe8faa9 --- /dev/null +++ b/mysql-test/suite/innodb/r/bug91091.result @@ -0,0 +1,54 @@ +# +# Bug #91091 (https://bugs.mysql.com/bug.php?id=91091) +# Inconsistent SELECT...ORDER BY results with euckr charset / euckr_bin collation +# +SET NAMES euckr; +CREATE TABLE t ( +c1 VARCHAR(256) COLLATE euckr_bin NOT NULL, +c2 VARCHAR(256) COLLATE euckr_bin NOT NULL, +c3 INT(11) NOT NULL, +c4 VARCHAR(1000) COLLATE euckr_bin DEFAULT NULL, +c5 VARCHAR(1000) COLLATE euckr_bin NOT NULL, +c6 CHAR(1) COLLATE euckr_bin NOT NULL, +c7 INT(11) NOT NULL, +c8 INT(11) NOT NULL, +c9 VARCHAR(1000) COLLATE euckr_bin DEFAULT NULL, +c10 CHAR(1) COLLATE euckr_bin NOT NULL, +c11 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, +c12 CHAR(1) COLLATE euckr_bin NOT NULL, +c13 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, +c14 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, +PRIMARY KEY (c1, c2), +UNIQUE KEY igt_field_uni (c1, c3) +) ENGINE=InnoDB DEFAULT CHARSET=euckr COLLATE=euckr_bin ROW_FORMAT=DYNAMIC; +SET autocommit = 0; +SELECT c1 FROM t WHERE c1 = 'Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00' ORDER BY c1, c3; +c1 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +SELECT c1 FROM t WHERE c1 = 'Eid4i*******11372012******O*****Sua9EiJ**************00' ORDER BY c1, c3; +c1 +Eid4i*******11372012******O*****Sua9EiJ**************00 +Eid4i*******11372012******O*****Sua9EiJ**************00 +Eid4i*******11372012******O*****Sua9EiJ**************00 +ROLLBACK; +SET autocommit = 0; +SELECT c1 FROM t FORCE KEY(igt_field_uni) WHERE c1 = 'Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00' ORDER BY c1, c3; +c1 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00 +SELECT c1 FROM t FORCE KEY(igt_field_uni) WHERE c1 = 'Eid4i*******11372012******O*****Sua9EiJ**************00' ORDER BY c1, c3; +c1 +Eid4i*******11372012******O*****Sua9EiJ**************00 +Eid4i*******11372012******O*****Sua9EiJ**************00 +Eid4i*******11372012******O*****Sua9EiJ**************00 +ROLLBACK; +DROP TABLE t; diff --git a/mysql-test/suite/innodb/t/bug91091.test b/mysql-test/suite/innodb/t/bug91091.test new file mode 100644 index 00000000000..42dee664a9f --- /dev/null +++ b/mysql-test/suite/innodb/t/bug91091.test @@ -0,0 +1,298 @@ +--source include/have_innodb.inc +--source include/have_euckr.inc + +--echo # +--echo # Bug #91091 (https://bugs.mysql.com/bug.php?id=91091) +--echo # Inconsistent SELECT...ORDER BY results with euckr charset / euckr_bin collation +--echo # + +SET NAMES euckr; + +CREATE TABLE t ( + c1 VARCHAR(256) COLLATE euckr_bin NOT NULL, + c2 VARCHAR(256) COLLATE euckr_bin NOT NULL, + c3 INT(11) NOT NULL, + c4 VARCHAR(1000) COLLATE euckr_bin DEFAULT NULL, + c5 VARCHAR(1000) COLLATE euckr_bin NOT NULL, + c6 CHAR(1) COLLATE euckr_bin NOT NULL, + c7 INT(11) NOT NULL, + c8 INT(11) NOT NULL, + c9 VARCHAR(1000) COLLATE euckr_bin DEFAULT NULL, + c10 CHAR(1) COLLATE euckr_bin NOT NULL, + c11 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, + c12 CHAR(1) COLLATE euckr_bin NOT NULL, + c13 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, + c14 VARCHAR(256) COLLATE euckr_bin DEFAULT NULL, + PRIMARY KEY (c1, c2), + UNIQUE KEY igt_field_uni (c1, c3) +) ENGINE=InnoDB DEFAULT CHARSET=euckr COLLATE=euckr_bin ROW_FORMAT=DYNAMIC; + +--disable_query_log +INSERT INTO t VALUES + ('Eid4i*******11372012******O', 'BUSIgooN3aePRF_*****_******00', 136, '****', '*****************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*****************************************************'), + ('Eid4i*******11372012******O', 'CMCM_*****_******00', 108, '****', '*********************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*********************************************'), + ('Eid4i*******11372012******O', 'DFRS_*****_******00', 172, '****', '*********************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*********************************************'), + ('Eid4i*******11372012******O', 'FEIouxia1Aroo2aaT_*****_******00', 232, '****', '*******************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*******************************************************'), + ('Eid4i*******11372012******O', 'FMLY_RLT_PRF_*****_******00', 112, '****', '*****************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*****************************************************'), + ('Eid4i*******11372012******O', 'FNNS_*****_******00', 101, '****', '*********************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*********************************************'), + ('Eid4i*******11372012******O', '******01_128890aaT2N5', 239, '****', '*****************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******O', 'HLIN_PBCR_*****_******00', 19, '****', '**************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '**************************************************'), + ('Eid4i*******11372012******O', 'equ4aiH_*****_******00', 93, '****', '************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '************************************************'), + ('Eid4i*******11372012******O', 'IMG_Sua9EiJ**************00', 240, '****', '******************************************************', '*', 0, 0, NULL, '*', '******************', '*', NULL, '******************************************************'), + ('Eid4i*******11372012******O', 'INCM_AMT_PRF_*****_******00', 150, '****', '*****************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*****************************************************'), + ('Eid4i*******11372012******O', 'MRG_RLT_PRF_*****_******00', 128, '****', '****************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '****************************************************'), + ('Eid4i*******11372012******O', 'PNSN_PRVS_roo2aaT_*****_******00', 183, '****', '*******************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*******************************************************'), + ('Eid4i*******11372012******O', '**********_CRCP_*****_******00', 158, '****', '******************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '******************************************************'), + ('Eid4i*******11372012******O', '*****_BSIC_******00', 1, '****', '*********************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*********************************************'), + ('Eid4i*******11372012******O', 'SUPCR_BSIC_PRF_*****_******00', 121, '****', '*******************************************************', '*', 0, 0, NULL, '*', NULL, '*', NULL, '*******************************************************'), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', 'BUSIgooN3aePRF_GTH_MTCD_S2', 149, '****', '*****************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSIgooN3aePRF_BZPL_LCTN_S100', 142, '****', '***************************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_BISNO_S24', 139, '****', '****************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_FRNM_S100', 138, '****', '*********************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_ISS_NO_S64', 137, '****', '**********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_NM_ISS_DT_S8', 148, '****', '*********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_NM_OPBS_DT_S8', 146, '****', '*********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_NMgooN3aeDT_S8', 147, '****', '*********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_RPTV_S60', 140, '****', '********************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BUSI_RGCR_RSDT_NO_S24', 141, '****', '**************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BZPL_LCTN_DTAD_S100', 145, '****', '*******************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BZPL_LCTN_ZADR_S200', 144, '****', '*******************************', '*', 200, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haBUSIgooN3aePRF_*****_******00', '*****_BZPL_ZPCD_S6', 143, '****', '***********************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haCMCM_*****_******00', 'CMCM_GTH_MTCD_S2', 111, '****', '*********************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haCMCM_*****_******00', '*****_CMCM_NROM_PAYM_MCNT_N5', 109, '****', '*****************************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haCMCM_*****_******00', '*****_CMCM_USE_FARE_N17', 110, '****', '************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', 'DFRS_GTH_MTCD_S2', 182, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_FLNM_S60', 174, '****', '**************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_ISS_DT_S8', 181, '****', '*****************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_ISS_NO_S64', 173, '****', '******************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_LTLY_ADDR_MVIN_DT_S8', 180, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_LTLY_ADDR_S100', 176, '****', '*******************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_DFRS_RSDT_NO_S24', 175, '****', '**********************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_LTLY_DTAD_S100', 179, '****', '***********************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_LTLY_ZADR_S200', 178, '****', '***********************', '*', 200, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haDFRS_*****_******00', '*****_LTLY_ZPCD_S6', 177, '****', '*********************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', 'FEIouxia1Aroo2aaT_GTH_MTCD_S2', 238, '****', '******************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', '*****_FEIouxia1A****_3EAouxia1AYN_S1', 236, '****', '*****************************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', '*****_FEIouxia1A****_FLNM_S60', 234, '****', '*******************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', '*****_FEIouxia1A****_ISS_DT_S8', 237, '****', '**********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', '*****_FEIouxia1A****_ISS_NO_S64', 233, '****', '***********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00', '*****_FEIouxia1A****_RSDT_NO_S24', 235, '****', '***************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', 'FMLY_RLT_PRF_GTH_MTCD_S2', 120, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_FLNM_S60', 114, '****', '****************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_ISS_DT_S8', 119, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_ISS_NO_S64', 113, '****', '********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_MRGE_YN_S1', 116, '****', '*******************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_RSDT_NO_S24', 115, '****', '************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_SPOS_NTIV_YN_S1', 118, '****', '***************************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFMLY_RLT_PRF_*****_******00', '*****_FMLY_RLT_****_SPOS_RSDT_NO_S24', 117, '****', '******************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', 'FNNS_GTH_MTCD_S2', 107, '****', '***********************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', '*****_DEP_ACCO_TOT_AMT_N17', 106, '****', '************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', '*****_FRDM_INDP_MN6_PAYAM_N17', 105, '****', '*****************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', '*****_FRDM_INDP_TRSF_roo2aaT_MCNT_N5', 104, '****', '*******************************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', '*****_RIID_MN6_PAYAM_N17', 103, '****', '*****************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haFNNS_*****_******00', '*****_RIID_TRSF_roo2aaT_MCNT_N5', 102, '****', '*******************************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'CUR_WRST_FRFT_YN_S1', 44, '****', '*******************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'ENCM_BIZ_OPNG_DT_S8', 42, '****', '*******************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'HLIN_PBCR_GTH_MTCD_S2', 92, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'OCUP_CD', 39, '****', '********', '*', 7, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_ANIN_AMT_N17', 21, '****', '**********************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_ANUL_HLTH_INPM_PAYM_TOT_AMT_N17', 35, '****', '**********************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTHLIN_ACQS_DT_S8', 23, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTHLIN_FRFT_DT_S8', 24, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTNM_S60', 25, '****', '******************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTPRGP_PSSG_r2aaT_N5', 27, '****', '***********************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTTNOF_r2aaT_N5', 26, '****', '***********************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****12889aaTXN_S1', 22, '****', '*******************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i01Ahzei9u17', 63, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i02Ahzei9u17', 64, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i03Ahzei9u17', 65, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i04Ahzei9u17', 66, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i05Ahzei9u17', 67, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i06Ahzei9u17', 68, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i07Ahzei9u17', 69, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i08Ahzei9u17', 70, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i09Ahzei9u17', 71, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i10Ahzei9u17', 72, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i11Ahzei9u17', 73, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****ieBoo3i12Ahzei9u17', 74, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****r2889aaTBUSI_NO_S10', 30, '****', '****************************', '*', 10, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****r2889aaTHLIN_ACQS_DT_S8', 28, '****', '*********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****r2889aaTHLIN_FRFT_DT_S8', 29, '****', '*********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****r2889aaTNM_S60', 31, '****', '********************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****r2889aaTTNOF_r2aaT_N5', 32, '****', '*************************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1GieBoo3iBZPL_NM_S60', 60, '****', '********************************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1GieBoo3iISS_DT_S8', 58, '****', '*******************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1GieBoo3iISS_NO_S64', 59, '****', '********************************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1GieBoo3iPAYR_NO_S64', 61, '****', '**********************************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1GieBoo3iS4', 62, '****', '***********************************', '*', 4, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1G_RBYR_BZPL_NM_S60', 77, '****', '********************************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1G_RBYR_ISS_DT_S8', 75, '****', '*******************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1G_RBYR_ISS_NO_S64', 76, '****', '********************************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1G_RBYR_PAYR_NO_S64', 78, '****', '**********************************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****eWioc1G_RBYR_S4', 79, '****', '***********************************', '*', 4, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****128890aaTDIV_S1', 20, '****', '*********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_INCM_YR_HLIN_RAT_N9', 37, '****', '*****************************', '*', 9, 4, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_INPM_NPAM_YN_S1', 38, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_MN3_AVG_PAY_MM_AMT_N17', 36, '****', '*****************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_ACQS_DT_S8', 51, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_BZPL_NM_S60', 50, '****', '********************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_FLNM_S60', 47, '****', '****************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_FRFT_DT_S8', 52, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_ISS_DT_S8', 57, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_ISS_NO_S64', 46, '****', '********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_RBF_ACQS_DT_S8', 55, '****', '***********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_RBF_BZPL_NM_S60', 54, '****', '************************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_RBF_FRFT_DT_S8', 56, '****', '***********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_RBF_SBSR_DIV_S20', 53, '****', '**************************************', '*', 20, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_RSDT_NO_S24', 48, '****', '************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_QLFC_CFNT_SBSR_DIV_S20', 49, '****', '**********************************', '*', 20, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_01Ahzei9u17', 80, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_02Ahzei9u17', 81, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_03Ahzei9u17', 82, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_04Ahzei9u17', 83, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_05Ahzei9u17', 84, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_06Ahzei9u17', 85, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_07Ahzei9u17', 86, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_08Ahzei9u17', 87, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_09Ahzei9u17', 88, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_10Ahzei9u17', 89, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_11Ahzei9u17', 90, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_RBYR_12Ahzei9u17', 91, '****', '******************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_SGI_ANIN_AMT_N17', 34, '****', '**********************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_SGI_CUR_TNOF_TRM_N5', 33, '****', '*********************************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', '*****_SUSPBZ_CLBS_DIV_S1', 41, '****', '*********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'SINDS_CD', 40, '****', '****************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'TNOF_INFO_BASE_DENL_TRGT_YN_S1', 45, '****', '***************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haHLIN_PBCR_*****_******00', 'WRST_BZPL_TLNO_S14', 43, '****', '**********************', '*', 14, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', 'equ4aiH_GTH_MTCD_S2', 100, '****', '*********************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_30_TTW_EXCS_DONT_EXIS_YN_S1', 98, '****', '*********************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_CHCR_CSVC2889aaTAMT_N17', 97, '****', '************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_CHCR_CSVC2889aaTAMT_RATE_N9', 96, '****', '***************************************', '*', 9, 4, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_CHCR2889aaTAMT_N17', 95, '****', '**************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_CHCR2889aaTAMT_RATE_N9', 94, '****', '*****************************', '*', 9, 4, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haequ4aiH_*****_******00', '*****_IDVD_PNSN_HOLD_YN_S1', 99, '****', '*************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******O*****Sua9EiJ**************00', 'ESN_YN', 243, '****', '********', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******O*****Sua9EiJ**************00', 'IMG_DOC_NO', 242, '****', '**************', '*', 16, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******O*****Sua9EiJ**************00', 'IMG_Sua9EiJ', 241, '****', '**************', '*', 11, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', 'INCM_AMT_PRF_GTH_MTCD_S2', 157, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF_FLNM_S60', 152, '****', '****************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF128890aaTN17', 155, '****', '********************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF_ISS_DT_S8', 156, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF_ISS_NO_S64', 151, '****', '********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF_RSDT_NO_S24', 153, '****', '************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haINCM_AMT_PRF_*****_******00', '*****128890aaTPRF_RVRS_YR_S4', 154, '****', '*******************************', '*', 4, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', 'MRDT_PRF_GTH_MTCD_S2', 135, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_FLNM_S60', 130, '****', '****************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_ISS_DT_S8', 134, '****', '*******************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_ISS_NO_S64', 129, '****', '********************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_RSDTNO_S24', 131, '****', '************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_SPOS_RSDTNO_S24', 132, '****', '******************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haMRG_RLT_PRF_*****_******00', '*****_MDRLT_****_YR5_WN_YN_S1', 133, '****', '****************************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', 'NTNS_PRVS_roo2aaT_GTH_MTCD_S2', 231, '****', '*******************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_01_PRVS_DT_S8', 190, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_01_iD1ohph_YM_AMT_N17', 192, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_01_iD1ohph_YM_S6', 191, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_01_iD1ohph_YR_AMT_N17', 227, '****', '******************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_01_iD1ohph_YR_S4', 226, '****', '*********************************************', '*', 4, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_02_PRVS_DT_S8', 193, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_02_iD1ohph_YM_AMT_N17', 195, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_02_iD1ohph_YM_S6', 194, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_02_iD1ohph_YR_AMT_N17', 229, '****', '******************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_02_iD1ohph_YR_S4', 228, '****', '*********************************************', '*', 4, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_03_PRVS_DT_S8', 196, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_03_iD1ohph_YM_AMT_N17', 198, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_03_iD1ohph_YM_S6', 197, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_04_PRVS_DT_S8', 199, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_04_iD1ohph_YM_AMT_N17', 201, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_04_iD1ohph_YM_S6', 200, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_05_PRVS_DT_S8', 202, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_05_iD1ohph_YM_AMT_N17', 204, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_05_iD1ohph_YM_S6', 203, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_06_PRVS_DT_S8', 205, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_06_iD1ohph_YM_AMT_N17', 207, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_06_iD1ohph_YM_S6', 206, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_07_PRVS_DT_S8', 208, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_07_iD1ohph_YM_AMT_N17', 210, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_07_iD1ohph_YM_S6', 209, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_08_PRVS_DT_S8', 211, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_08_iD1ohph_YM_AMT_N17', 213, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_08_iD1ohph_YM_S6', 212, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_09_PRVS_DT_S8', 214, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_09_iD1ohph_YM_AMT_N17', 216, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_09_iD1ohph_YM_S6', 215, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_10_PRVS_DT_S8', 217, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_10_iD1ohph_YM_AMT_N17', 219, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_10_iD1ohph_YM_S6', 218, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_11_PRVS_DT_S8', 220, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_11_iD1ohph_YM_AMT_N17', 222, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_11_iD1ohph_YM_S6', 221, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_12_PRVS_DT_S8', 223, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_12_iD1ohph_YM_AMT_N17', 225, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_12_iD1ohph_YM_S6', 224, '****', '*************************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_FLNM_S60', 185, '****', '********************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_ISS_DT_S8', 230, '****', '***********************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_ISS_NO_S64', 184, '****', '************************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_MM_AMT_N17', 189, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_PNSN_KIND_S60', 187, '****', '************************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_RSDT_NO_S24', 186, '****', '****************************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haPNSN_PRVS_roo2aaT_*****_******00', '*****Ejae7ov****_TOT_AMT_N17', 188, '****', '**************************************', '*', 17, 2, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '**********_CRCP_GTH_MTCD_S2', 171, '****', '***************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_CRSD_DTAD_S100', 166, '****', '***************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_CRSD_ZADR_S200', 165, '****', '***************************', '*', 200, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_CRSD_ZPCD_S6', 164, '****', '*************************', '*', 6, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_CRSD_ADDR_S100', 163, '****', '***********************************', '*', 100, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_CRSD_MVIN_DT_S8', 167, '****', '*************************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_FLNM_S60', 160, '****', '**************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_HHLD_RLT_S30', 162, '****', '********************************', '*', 30, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_HSPR_CNT_N3', 169, '****', '*****************************', '*', 3, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_ISS_DT_S8', 170, '****', '*****************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_ISS_NO_S64', 159, '****', '******************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_MNRT_CHLD_CNT_N3', 168, '****', '***********************************', '*', 3, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha**********_CRCP_*****_******00', '*****_**********_CRCP_RSDT_NO_S24', 161, '****', '**********************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'BUSIgooN3aePRF_EVDN_YN_S1', 13, '****', '*************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'CHNL_LNBZ_MENU_DVCD', 4, '****', '********************', '*', 5, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'CMCM_EVDN_YN_S1', 9, '****', '*****************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'CSTNO', 5, '****', '********', '*', 16, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'DFRS_EVDN_YN_S1', 16, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'EXTNL_INFO_GTH_MTCD', 2, '****', '********************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'FEIouxia1Aroo2aaT_EVDN_YN_S1', 18, '****', '**************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'FMLY_RLT_PRF_EVDN_YN_S1', 10, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'FNNS_EVDN_YN_S1', 8, '****', '*******************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'HLIN_PBCR_EVDN_YN_S1', 6, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'equ4aiH_EVDN_YN_S1', 7, '****', '*****************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'INCM_AMT_PRF_EVDN_YN_S1', 14, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'LNBZ_MGMT_NO', 3, '****', '************', '*', 16, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'MRDT_PRF_EVDN_YN_S1', 12, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'NTNS_PRVS_roo2aaT_EVDN_YN_S1', 17, '****', '***************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', '**********_CRCP_EVDN_YN_S1', 15, '****', '***********************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******ha*****_BSIC_******00', 'SUPCR_BSIC_PRF_EVDN_YN_S1', 11, '****', '*************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', '*****_BSIC_****_FLNM_S60', 123, '****', '************************', '*', 60, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', '*****_BSIC_****_ISS_DT_S8', 126, '****', '***************************', '*', 8, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', '*****_BSIC_****_ISS_NO_S64', 122, '****', '****************************', '*', 64, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', '*****_BSIC_****_RSDT_NO_S24', 124, '****', '********************************', '*', 24, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', '*****_BSIC_****_SELF_NTRED_YN_S1', 125, '****', '*******************************', '*', 1, 0, NULL, '*', NULL, '*', NULL, NULL), + ('Eid4i*******11372012******haSUPCR_BSIC_PRF_*****_******00', 'SUPCR_BSIC_PRF_GTH_MTCD_S2', 127, '****', '*****************************', '*', 2, 0, NULL, '*', NULL, '*', NULL, NULL); +--enable_query_log + +SET autocommit = 0; + +--disable_query_log +--source suite/innodb/include/bug91091.inc +--enable_query_log + +SELECT c1 FROM t WHERE c1 = 'Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00' ORDER BY c1, c3; +SELECT c1 FROM t WHERE c1 = 'Eid4i*******11372012******O*****Sua9EiJ**************00' ORDER BY c1, c3; + +ROLLBACK; + +SET autocommit = 0; +--disable_query_log +--source suite/innodb/include/bug91091.inc +--enable_query_log + +SELECT c1 FROM t FORCE KEY(igt_field_uni) WHERE c1 = 'Eid4i*******11372012******haFEIouxia1Aroo2aaT_*****_******00' ORDER BY c1, c3; +SELECT c1 FROM t FORCE KEY(igt_field_uni) WHERE c1 = 'Eid4i*******11372012******O*****Sua9EiJ**************00' ORDER BY c1, c3; + +ROLLBACK; + +DROP TABLE t; diff --git a/storage/innobase/handler/ha_innodb.cc b/storage/innobase/handler/ha_innodb.cc index 256f55f2668..b6b01f52548 100644 --- a/storage/innobase/handler/ha_innodb.cc +++ b/storage/innobase/handler/ha_innodb.cc @@ -3567,6 +3567,7 @@ ha_innobase::reset_template(void) m_prebuilt->keep_other_fields_on_keyread = 0; m_prebuilt->read_just_key = 0; m_prebuilt->in_fts_query = 0; + m_prebuilt->m_end_range = false; /* Reset index condition pushdown state. */ if (m_prebuilt->idx_cond) {