tidb_vs_mysql.out

QUERY: SELECT VERSION()
  Not equal:
    MySQL:
      [('8.4.7',)]
    TiDB:
      [('8.0.11-TiDB-v9.0.0-beta.2.pre-734-gcbb252de2d',)]
QUERY: SELECT FORMAT(12345.67, 3, 'en_US')
QUERY: SELECT FORMAT(12345.67, 3, 'aa_DJ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345.670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'aa_DJ.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'aa_DJ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'aa_ER')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345.670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'aa_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'aa_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'aa_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'af_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'af_ZA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'af_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'agr_PE')
QUERY: SELECT FORMAT(12345.67, 3, 'agr_PE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ak_GH')
QUERY: SELECT FORMAT(12345.67, 3, 'ak_GH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'am_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'am_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'an_ES')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'an_ES.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'an_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'anp_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'anp_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_AE')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_AE.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_AE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_BH')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_BH.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_BH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_DZ')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_DZ.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_DZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_EG')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_EG.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_EG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_IQ')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_IQ.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_IQ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_JO')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_JO.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_JO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_KW')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_KW.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_KW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LB')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LB.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LY')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LY.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_LY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_MA')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_MA.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_MA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_OM')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_OM.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_OM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_QA')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_QA.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_QA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SA')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SA.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SD')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SD.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SD.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SS')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SS.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SY')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SY.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_SY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_TN')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_TN.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_TN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_YE')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_YE.iso88596')
QUERY: SELECT FORMAT(12345.67, 3, 'ar_YE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'as_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'as_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ast_ES')
QUERY: SELECT FORMAT(12345.67, 3, 'ast_ES.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'ast_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ayc_PE')
QUERY: SELECT FORMAT(12345.67, 3, 'ayc_PE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'az_AZ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'az_AZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'az_IR')
QUERY: SELECT FORMAT(12345.67, 3, 'az_IR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'be_BY')
QUERY: SELECT FORMAT(12345.67, 3, 'be_BY.cp1251')
QUERY: SELECT FORMAT(12345.67, 3, 'be_BY@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'be_BY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'be_BY.utf8@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'bem_ZM')
QUERY: SELECT FORMAT(12345.67, 3, 'bem_ZM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ber_DZ')
QUERY: SELECT FORMAT(12345.67, 3, 'ber_DZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ber_MA')
QUERY: SELECT FORMAT(12345.67, 3, 'ber_MA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bg_BG')
  Not equal:
    MySQL:
      [('12\x00345,670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'bg_BG.cp1251')
QUERY: SELECT FORMAT(12345.67, 3, 'bg_BG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bhb_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bho_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'bho_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bho_NP')
QUERY: SELECT FORMAT(12345.67, 3, 'bho_NP.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bi_VU')
QUERY: SELECT FORMAT(12345.67, 3, 'bi_VU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bn_BD')
QUERY: SELECT FORMAT(12345.67, 3, 'bn_BD.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bn_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'bn_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bo_CN')
QUERY: SELECT FORMAT(12345.67, 3, 'bo_CN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bo_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'bo_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bokmal')
QUERY: SELECT FORMAT(12345.67, 3, 'br_FR')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'br_FR@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'br_FR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'br_FR.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'br_FR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'brx_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'brx_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'bs_BA')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'bs_BA.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'bs_BA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'byn_ER')
QUERY: SELECT FORMAT(12345.67, 3, 'byn_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'C')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_AD')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ca_AD.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_AD.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES.utf8@valencia')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_ES@valencia')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_FR')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ca_FR.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_FR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_IT')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ca_IT.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'ca_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'catalan')
QUERY: SELECT FORMAT(12345.67, 3, 'ce_RU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ce_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'chr_US')
QUERY: SELECT FORMAT(12345.67, 3, 'chr_US.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ckb_IQ')
QUERY: SELECT FORMAT(12345.67, 3, 'ckb_IQ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'cmn_TW')
QUERY: SELECT FORMAT(12345.67, 3, 'cmn_TW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'crh_RU')
QUERY: SELECT FORMAT(12345.67, 3, 'crh_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'crh_UA')
QUERY: SELECT FORMAT(12345.67, 3, 'crh_UA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'croatian')
QUERY: SELECT FORMAT(12345.67, 3, 'csb_PL')
QUERY: SELECT FORMAT(12345.67, 3, 'csb_PL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'cs_CZ')
QUERY: SELECT FORMAT(12345.67, 3, 'cs_CZ.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'cs_CZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'C.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'cv_RU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'cv_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'cy_GB')
QUERY: SELECT FORMAT(12345.67, 3, 'cy_GB.iso885914')
QUERY: SELECT FORMAT(12345.67, 3, 'cy_GB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'czech')
QUERY: SELECT FORMAT(12345.67, 3, 'da_DK')
QUERY: SELECT FORMAT(12345.67, 3, 'da_DK.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'da_DK.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'da_DK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'danish')
QUERY: SELECT FORMAT(12345.67, 3, 'dansk')
QUERY: SELECT FORMAT(12345.67, 3, 'de_AT')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'de_AT@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_AT.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_AT.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_AT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_BE')
QUERY: SELECT FORMAT(12345.67, 3, 'de_BE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_BE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_BE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_BE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_CH')
QUERY: SELECT FORMAT(12345.67, 3, 'de_CH.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_CH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_DE')
QUERY: SELECT FORMAT(12345.67, 3, 'de_DE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_DE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_DE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_DE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_IT')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'de_IT.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LU')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LU@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LU.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LU.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'de_LU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'deutsch')
QUERY: SELECT FORMAT(12345.67, 3, 'doi_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'doi_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'dsb_DE')
QUERY: SELECT FORMAT(12345.67, 3, 'dsb_DE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'dutch')
QUERY: SELECT FORMAT(12345.67, 3, 'dv_MV')
QUERY: SELECT FORMAT(12345.67, 3, 'dv_MV.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'dz_BT')
QUERY: SELECT FORMAT(12345.67, 3, 'dz_BT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'eesti')
QUERY: SELECT FORMAT(12345.67, 3, 'el_CY')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'el_CY.iso88597')
QUERY: SELECT FORMAT(12345.67, 3, 'el_CY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'el_GR')
QUERY: SELECT FORMAT(12345.67, 3, 'el_GR@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'el_GR.iso88597')
QUERY: SELECT FORMAT(12345.67, 3, 'el_GR.iso88597@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'el_GR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_AG')
QUERY: SELECT FORMAT(12345.67, 3, 'en_AG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_AU')
QUERY: SELECT FORMAT(12345.67, 3, 'en_AU.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_AU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_BW')
QUERY: SELECT FORMAT(12345.67, 3, 'en_BW.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_BW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_CA')
QUERY: SELECT FORMAT(12345.67, 3, 'en_CA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_CA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_DK')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'en_DK.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_DK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_GB')
QUERY: SELECT FORMAT(12345.67, 3, 'en_GB.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_GB.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'en_GB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_HK')
QUERY: SELECT FORMAT(12345.67, 3, 'en_HK.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_HK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IE')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IL')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'en_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_NG')
QUERY: SELECT FORMAT(12345.67, 3, 'en_NG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_NZ')
QUERY: SELECT FORMAT(12345.67, 3, 'en_NZ.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_NZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_PH')
QUERY: SELECT FORMAT(12345.67, 3, 'en_PH.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_PH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_SC.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_SG')
QUERY: SELECT FORMAT(12345.67, 3, 'en_SG.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_SG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_US')
QUERY: SELECT FORMAT(12345.67, 3, 'en_US.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_US.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'en_US.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZM')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZW')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZW.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'en_ZW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'eo')
QUERY: SELECT FORMAT(12345.67, 3, 'eo.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_AR')
QUERY: SELECT FORMAT(12345.67, 3, 'es_AR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_AR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_BO')
QUERY: SELECT FORMAT(12345.67, 3, 'es_BO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_BO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CL')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CL.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CO')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CR')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_CU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'es_CU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_DO')
QUERY: SELECT FORMAT(12345.67, 3, 'es_DO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_DO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_EC')
QUERY: SELECT FORMAT(12345.67, 3, 'es_EC.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_EC.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_ES')
QUERY: SELECT FORMAT(12345.67, 3, 'es_ES@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'es_ES.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_ES.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'es_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_GT')
QUERY: SELECT FORMAT(12345.67, 3, 'es_GT.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_GT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_HN')
QUERY: SELECT FORMAT(12345.67, 3, 'es_HN.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_HN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_MX')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345.670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'es_MX.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_MX.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_NI')
QUERY: SELECT FORMAT(12345.67, 3, 'es_NI.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_NI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PA')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PE')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'es_PE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PR')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PY')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PY.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_PY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_SV')
QUERY: SELECT FORMAT(12345.67, 3, 'es_SV.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_SV.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'estonian')
QUERY: SELECT FORMAT(12345.67, 3, 'es_US')
QUERY: SELECT FORMAT(12345.67, 3, 'es_US.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_US.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_UY')
QUERY: SELECT FORMAT(12345.67, 3, 'es_UY.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_UY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'es_VE')
QUERY: SELECT FORMAT(12345.67, 3, 'es_VE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'es_VE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'et_EE')
QUERY: SELECT FORMAT(12345.67, 3, 'et_EE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'et_EE.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'et_EE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'eu_ES')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'eu_ES@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'eu_ES.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'eu_ES.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'eu_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fa_IR')
QUERY: SELECT FORMAT(12345.67, 3, 'fa_IR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ff_SN')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ff_SN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fi_FI')
QUERY: SELECT FORMAT(12345.67, 3, 'fi_FI@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fi_FI.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fi_FI.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fi_FI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fil_PH')
QUERY: SELECT FORMAT(12345.67, 3, 'fil_PH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'finnish')
QUERY: SELECT FORMAT(12345.67, 3, 'fo_FO')
QUERY: SELECT FORMAT(12345.67, 3, 'fo_FO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fo_FO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_BE')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fr_BE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_BE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_BE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_BE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CA')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CH')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [("12'345.670",)]
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CH.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_CH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'french')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_FR')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fr_FR@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_FR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_FR.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_FR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_LU')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fr_LU@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_LU.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_LU.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'fr_LU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fur_IT')
QUERY: SELECT FORMAT(12345.67, 3, 'fur_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fy_DE')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fy_DE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'fy_NL')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'fy_NL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ga_IE')
QUERY: SELECT FORMAT(12345.67, 3, 'ga_IE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'ga_IE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'ga_IE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'ga_IE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'galego')
QUERY: SELECT FORMAT(12345.67, 3, 'galician')
QUERY: SELECT FORMAT(12345.67, 3, 'gbm_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'gbm_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'gd_GB')
QUERY: SELECT FORMAT(12345.67, 3, 'gd_GB.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'gd_GB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'german')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ER')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ER@abegede')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ER.utf8@abegede')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ET@abegede')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'gez_ET.utf8@abegede')
QUERY: SELECT FORMAT(12345.67, 3, 'gl_ES')
QUERY: SELECT FORMAT(12345.67, 3, 'gl_ES@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'gl_ES.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'gl_ES.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'gl_ES.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'greek')
QUERY: SELECT FORMAT(12345.67, 3, 'gu_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'gu_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'gv_GB')
QUERY: SELECT FORMAT(12345.67, 3, 'gv_GB.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'gv_GB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hak_TW')
QUERY: SELECT FORMAT(12345.67, 3, 'hak_TW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ha_NG')
QUERY: SELECT FORMAT(12345.67, 3, 'ha_NG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hebrew')
QUERY: SELECT FORMAT(12345.67, 3, 'he_IL')
QUERY: SELECT FORMAT(12345.67, 3, 'he_IL.iso88598')
QUERY: SELECT FORMAT(12345.67, 3, 'he_IL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hif_FJ')
QUERY: SELECT FORMAT(12345.67, 3, 'hif_FJ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hi_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'hi_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hne_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'hne_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hr_HR')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'hr_HR.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'hr_HR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hrvatski')
QUERY: SELECT FORMAT(12345.67, 3, 'hsb_DE')
QUERY: SELECT FORMAT(12345.67, 3, 'hsb_DE.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'hsb_DE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ht_HT')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ht_HT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hu_HU')
QUERY: SELECT FORMAT(12345.67, 3, 'hu_HU.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'hu_HU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'hungarian')
QUERY: SELECT FORMAT(12345.67, 3, 'hy_AM')
QUERY: SELECT FORMAT(12345.67, 3, 'hy_AM.armscii8')
QUERY: SELECT FORMAT(12345.67, 3, 'hy_AM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ia_FR')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ia_FR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'icelandic')
QUERY: SELECT FORMAT(12345.67, 3, 'id_ID')
QUERY: SELECT FORMAT(12345.67, 3, 'id_ID.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'id_ID.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ig_NG')
QUERY: SELECT FORMAT(12345.67, 3, 'ig_NG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ik_CA')
QUERY: SELECT FORMAT(12345.67, 3, 'ik_CA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'is_IS')
QUERY: SELECT FORMAT(12345.67, 3, 'is_IS.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'is_IS.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'italian')
QUERY: SELECT FORMAT(12345.67, 3, 'it_CH')
  Not equal:
    MySQL:
      [("12'345,670",)]
    TiDB:
      [("12'345.670",)]
QUERY: SELECT FORMAT(12345.67, 3, 'it_CH.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'it_CH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'it_IT')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'it_IT@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'it_IT.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'it_IT.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'it_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'iu_CA')
QUERY: SELECT FORMAT(12345.67, 3, 'iu_CA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ja_JP')
QUERY: SELECT FORMAT(12345.67, 3, 'ja_JP.eucjp')
QUERY: SELECT FORMAT(12345.67, 3, 'ja_JP.ujis')
QUERY: SELECT FORMAT(12345.67, 3, 'ja_JP.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'japanese')
QUERY: SELECT FORMAT(12345.67, 3, 'japanese.euc')
QUERY: SELECT FORMAT(12345.67, 3, 'kab_DZ')
QUERY: SELECT FORMAT(12345.67, 3, 'kab_DZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ka_GE')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ka_GE.georgianps')
QUERY: SELECT FORMAT(12345.67, 3, 'ka_GE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kk_KZ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'kk_KZ.pt154')
QUERY: SELECT FORMAT(12345.67, 3, 'kk_KZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kl_GL')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'kl_GL.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'kl_GL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'km_KH')
QUERY: SELECT FORMAT(12345.67, 3, 'km_KH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kn_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'kn_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kok_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'kok_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ko_KR')
QUERY: SELECT FORMAT(12345.67, 3, 'ko_KR.euckr')
QUERY: SELECT FORMAT(12345.67, 3, 'ko_KR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'korean')
QUERY: SELECT FORMAT(12345.67, 3, 'korean.euc')
QUERY: SELECT FORMAT(12345.67, 3, 'ks_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'ks_IN@devanagari')
QUERY: SELECT FORMAT(12345.67, 3, 'ks_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ks_IN.utf8@devanagari')
QUERY: SELECT FORMAT(12345.67, 3, 'ku_TR')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ku_TR.iso88599')
QUERY: SELECT FORMAT(12345.67, 3, 'ku_TR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kv_RU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'kv_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'kw_GB')
QUERY: SELECT FORMAT(12345.67, 3, 'kw_GB.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'kw_GB.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ky_KG')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ky_KG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lb_LU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'lb_LU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lg_UG')
QUERY: SELECT FORMAT(12345.67, 3, 'lg_UG.iso885910')
QUERY: SELECT FORMAT(12345.67, 3, 'lg_UG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'li_BE')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'li_BE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lij_IT')
QUERY: SELECT FORMAT(12345.67, 3, 'lij_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'li_NL')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'li_NL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lithuanian')
QUERY: SELECT FORMAT(12345.67, 3, 'ln_CD')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ln_CD.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lo_LA')
QUERY: SELECT FORMAT(12345.67, 3, 'lo_LA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ltg_LV.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lt_LT')
QUERY: SELECT FORMAT(12345.67, 3, 'lt_LT.iso885913')
QUERY: SELECT FORMAT(12345.67, 3, 'lt_LT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lv_LV')
QUERY: SELECT FORMAT(12345.67, 3, 'lv_LV.iso885913')
QUERY: SELECT FORMAT(12345.67, 3, 'lv_LV.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'lzh_TW')
QUERY: SELECT FORMAT(12345.67, 3, 'lzh_TW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mag_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'mag_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mai_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'mai_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mai_NP')
QUERY: SELECT FORMAT(12345.67, 3, 'mai_NP.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mdf_RU')
QUERY: SELECT FORMAT(12345.67, 3, 'mdf_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mfe_MU')
QUERY: SELECT FORMAT(12345.67, 3, 'mfe_MU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mg_MG')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'mg_MG.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'mg_MG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mhr_RU')
QUERY: SELECT FORMAT(12345.67, 3, 'mhr_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mi_NZ')
QUERY: SELECT FORMAT(12345.67, 3, 'mi_NZ.iso885913')
QUERY: SELECT FORMAT(12345.67, 3, 'mi_NZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'miq_NI')
QUERY: SELECT FORMAT(12345.67, 3, 'miq_NI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mjw_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'mjw_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mk_MK')
QUERY: SELECT FORMAT(12345.67, 3, 'mk_MK.iso88595')
QUERY: SELECT FORMAT(12345.67, 3, 'mk_MK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ml_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'ml_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mni_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'mni_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mn_MN')
QUERY: SELECT FORMAT(12345.67, 3, 'mn_MN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mnw_MM')
QUERY: SELECT FORMAT(12345.67, 3, 'mnw_MM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mr_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'mr_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ms_MY')
QUERY: SELECT FORMAT(12345.67, 3, 'ms_MY.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'ms_MY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'mt_MT')
QUERY: SELECT FORMAT(12345.67, 3, 'mt_MT.iso88593')
QUERY: SELECT FORMAT(12345.67, 3, 'mt_MT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'my_MM')
QUERY: SELECT FORMAT(12345.67, 3, 'my_MM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nan_TW')
QUERY: SELECT FORMAT(12345.67, 3, 'nan_TW@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'nan_TW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nan_TW.utf8@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'nb_NO')
  Not equal:
    MySQL:
      [('12.345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'nb_NO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'nb_NO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nds_DE')
QUERY: SELECT FORMAT(12345.67, 3, 'nds_DE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nds_NL')
QUERY: SELECT FORMAT(12345.67, 3, 'nds_NL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ne_NP')
QUERY: SELECT FORMAT(12345.67, 3, 'ne_NP.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nhn_MX')
QUERY: SELECT FORMAT(12345.67, 3, 'nhn_MX.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'niu_NU')
QUERY: SELECT FORMAT(12345.67, 3, 'niu_NU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'niu_NZ')
QUERY: SELECT FORMAT(12345.67, 3, 'niu_NZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_AW')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'nl_AW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_BE')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'nl_BE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_BE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_BE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_BE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_NL')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'nl_NL@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_NL.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_NL.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'nl_NL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nn_NO')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'nn_NO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'nn_NO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'no_NO')
  Not equal:
    MySQL:
      [('12.345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'no_NO.ISO-8859-1')
QUERY: SELECT FORMAT(12345.67, 3, 'norwegian')
QUERY: SELECT FORMAT(12345.67, 3, 'nr_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'nr_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nso_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'nso_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'nynorsk')
QUERY: SELECT FORMAT(12345.67, 3, 'oc_FR')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'oc_FR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'oc_FR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'om_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'om_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'om_KE')
QUERY: SELECT FORMAT(12345.67, 3, 'om_KE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'om_KE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'or_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'or_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'os_RU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'os_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pa_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'pa_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pap_AW')
QUERY: SELECT FORMAT(12345.67, 3, 'pap_AW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pap_CW')
QUERY: SELECT FORMAT(12345.67, 3, 'pap_CW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pa_PK')
QUERY: SELECT FORMAT(12345.67, 3, 'pa_PK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pl_PL')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'pl_PL.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'pl_PL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'polish')
QUERY: SELECT FORMAT(12345.67, 3, 'portuguese')
QUERY: SELECT FORMAT(12345.67, 3, 'POSIX')
QUERY: SELECT FORMAT(12345.67, 3, 'ps_AF')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12٬345٫670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ps_AF.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_BR')
  Not equal:
    MySQL:
      [('12345,670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'pt_BR.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_BR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_PT')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_PT@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_PT.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_PT.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'pt_PT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'quz_PE')
QUERY: SELECT FORMAT(12345.67, 3, 'quz_PE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'raj_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'raj_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'rif_MA')
QUERY: SELECT FORMAT(12345.67, 3, 'rif_MA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'romanian')
QUERY: SELECT FORMAT(12345.67, 3, 'ro_RO')
QUERY: SELECT FORMAT(12345.67, 3, 'ro_RO.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'ro_RO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_RU')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_RU.iso88595')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_RU.koi8r')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'russian')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_UA')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_UA.koi8u')
QUERY: SELECT FORMAT(12345.67, 3, 'ru_UA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'rw_RW')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'rw_RW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sah_RU')
QUERY: SELECT FORMAT(12345.67, 3, 'sah_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sa_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'sa_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sat_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'sat_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sc_IT')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'sc_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'scn_IT')
QUERY: SELECT FORMAT(12345.67, 3, 'scn_IT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sd_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'sd_IN@devanagari')
QUERY: SELECT FORMAT(12345.67, 3, 'sd_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sd_IN.utf8@devanagari')
QUERY: SELECT FORMAT(12345.67, 3, 'se_NO')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'se_NO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sgs_LT')
QUERY: SELECT FORMAT(12345.67, 3, 'sgs_LT.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'shn_MM')
QUERY: SELECT FORMAT(12345.67, 3, 'shn_MM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'shs_CA')
QUERY: SELECT FORMAT(12345.67, 3, 'shs_CA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sid_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'sid_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'si_LK')
QUERY: SELECT FORMAT(12345.67, 3, 'si_LK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sk_SK')
QUERY: SELECT FORMAT(12345.67, 3, 'sk_SK.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'sk_SK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'slovak')
QUERY: SELECT FORMAT(12345.67, 3, 'slovene')
QUERY: SELECT FORMAT(12345.67, 3, 'slovenian')
QUERY: SELECT FORMAT(12345.67, 3, 'sl_SI')
QUERY: SELECT FORMAT(12345.67, 3, 'sl_SI.iso88592')
QUERY: SELECT FORMAT(12345.67, 3, 'sl_SI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sm_WS')
QUERY: SELECT FORMAT(12345.67, 3, 'sm_WS.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'so_DJ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345.670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'so_DJ.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'so_DJ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'so_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'so_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'so_KE')
QUERY: SELECT FORMAT(12345.67, 3, 'so_KE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'so_KE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'so_SO')
QUERY: SELECT FORMAT(12345.67, 3, 'so_SO.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'so_SO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'spanish')
QUERY: SELECT FORMAT(12345.67, 3, 'sq_AL')
QUERY: SELECT FORMAT(12345.67, 3, 'sq_AL.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'sq_AL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sq_MK')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'sq_MK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sr_ME')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'sr_ME.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sr_RS')
  Not equal:
    MySQL:
      [('12345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'sr_RS@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'sr_RS.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sr_RS.utf8@latin')
QUERY: SELECT FORMAT(12345.67, 3, 'ssy_ER')
QUERY: SELECT FORMAT(12345.67, 3, 'ssy_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ss_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'ss_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'st_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'st_ZA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'st_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'su_ID')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'su_ID.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_FI')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_FI@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_FI.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_FI.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_FI.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_SE')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_SE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_SE.iso885915')
QUERY: SELECT FORMAT(12345.67, 3, 'sv_SE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'swedish')
QUERY: SELECT FORMAT(12345.67, 3, 'sw_KE')
QUERY: SELECT FORMAT(12345.67, 3, 'sw_KE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'sw_TZ')
QUERY: SELECT FORMAT(12345.67, 3, 'sw_TZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'syr')
QUERY: SELECT FORMAT(12345.67, 3, 'syr.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'szl_PL')
QUERY: SELECT FORMAT(12345.67, 3, 'szl_PL.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ta_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'ta_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ta_LK')
QUERY: SELECT FORMAT(12345.67, 3, 'ta_LK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tcy_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'te_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'te_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tg_TJ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'tg_TJ.koi8t')
QUERY: SELECT FORMAT(12345.67, 3, 'tg_TJ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'thai')
QUERY: SELECT FORMAT(12345.67, 3, 'the_NP')
QUERY: SELECT FORMAT(12345.67, 3, 'the_NP.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'th_TH')
QUERY: SELECT FORMAT(12345.67, 3, 'th_TH.tis620')
QUERY: SELECT FORMAT(12345.67, 3, 'th_TH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ti_ER')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345.670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'ti_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ti_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'ti_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tig_ER')
QUERY: SELECT FORMAT(12345.67, 3, 'tig_ER.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tk_TM')
QUERY: SELECT FORMAT(12345.67, 3, 'tk_TM.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tl_PH')
QUERY: SELECT FORMAT(12345.67, 3, 'tl_PH.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'tl_PH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tn_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'tn_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tok')
QUERY: SELECT FORMAT(12345.67, 3, 'tok.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'to_TO')
QUERY: SELECT FORMAT(12345.67, 3, 'to_TO.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tpi_PG')
QUERY: SELECT FORMAT(12345.67, 3, 'tpi_PG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tr_CY')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'tr_CY.iso88599')
QUERY: SELECT FORMAT(12345.67, 3, 'tr_CY.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tr_TR')
QUERY: SELECT FORMAT(12345.67, 3, 'tr_TR.iso88599')
QUERY: SELECT FORMAT(12345.67, 3, 'tr_TR.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ts_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'ts_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tt_RU')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12\u202f345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'tt_RU@iqtelif')
QUERY: SELECT FORMAT(12345.67, 3, 'tt_RU.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'tt_RU.utf8@iqtelif')
QUERY: SELECT FORMAT(12345.67, 3, 'turkish')
QUERY: SELECT FORMAT(12345.67, 3, 'ug_CN')
QUERY: SELECT FORMAT(12345.67, 3, 'ug_CN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'uk_UA')
  Not equal:
    MySQL:
      [('12.345,670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'uk_UA.koi8u')
QUERY: SELECT FORMAT(12345.67, 3, 'uk_UA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'unm_US')
QUERY: SELECT FORMAT(12345.67, 3, 'unm_US.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ur_IN')
QUERY: SELECT FORMAT(12345.67, 3, 'ur_IN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'ur_PK')
QUERY: SELECT FORMAT(12345.67, 3, 'ur_PK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'uz_UZ')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12 345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'uz_UZ@cyrillic')
QUERY: SELECT FORMAT(12345.67, 3, 'uz_UZ.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'uz_UZ.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'uz_UZ.utf8@cyrillic')
QUERY: SELECT FORMAT(12345.67, 3, 've_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 've_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'vi_VN')
QUERY: SELECT FORMAT(12345.67, 3, 'vi_VN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'wa_BE')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12.345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'wa_BE@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'wa_BE.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'wa_BE.iso885915@euro')
QUERY: SELECT FORMAT(12345.67, 3, 'wa_BE.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'wae_CH')
QUERY: SELECT FORMAT(12345.67, 3, 'wae_CH.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'wal_ET')
QUERY: SELECT FORMAT(12345.67, 3, 'wal_ET.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'wo_SN')
  Not equal:
    MySQL:
      [('12,345.670',)]
    TiDB:
      [('12345,670',)]
QUERY: SELECT FORMAT(12345.67, 3, 'wo_SN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'xh_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'xh_ZA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'xh_ZA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'yi_US')
QUERY: SELECT FORMAT(12345.67, 3, 'yi_US.cp1255')
QUERY: SELECT FORMAT(12345.67, 3, 'yi_US.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'yo_NG')
QUERY: SELECT FORMAT(12345.67, 3, 'yo_NG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'yue_HK')
QUERY: SELECT FORMAT(12345.67, 3, 'yue_HK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'yuw_PG')
QUERY: SELECT FORMAT(12345.67, 3, 'yuw_PG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zgh_MA')
QUERY: SELECT FORMAT(12345.67, 3, 'zgh_MA.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_CN')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_CN.gb18030')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_CN.gb2312')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_CN.gbk')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_CN.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_HK')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_HK.big5hkscs')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_HK.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_SG')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_SG.gb2312')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_SG.gbk')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_SG.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_TW')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_TW.big5')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_TW.euctw')
QUERY: SELECT FORMAT(12345.67, 3, 'zh_TW.utf8')
QUERY: SELECT FORMAT(12345.67, 3, 'zu_ZA')
QUERY: SELECT FORMAT(12345.67, 3, 'zu_ZA.iso88591')
QUERY: SELECT FORMAT(12345.67, 3, 'zu_ZA.utf8')

tidb_vs_mysql.py

#!/bin/python3 -tt
import subprocess
import mysql.connector

tidb_config = {
        "host":'127.0.0.1',
        "port":4000,
        "user":'root',
}

mysql_config = {
        "host":'127.0.0.1',
        "port":3306,
        "user":'root',
}

tidb_con = mysql.connector.connect(**tidb_config)
mysql_con = mysql.connector.connect(**mysql_config)

tidb_cur = tidb_con.cursor()
mysql_cur = mysql_con.cursor()

queries = [
        "SELECT VERSION()",
        "SELECT FORMAT(12345.67, 3, 'en_US')",
]

locales = subprocess.Popen(["locale", "-a"], stdout=subprocess.PIPE).stdout.read()
for l in locales.decode('utf-8').rstrip().split('\n'):
    queries.append(f"SELECT FORMAT(12345.67, 3, '{l}')")


for q in queries:
    print(f"QUERY: {q}")

    tidb_cur.execute(q)
    tidb_res = tidb_cur.fetchall()

    mysql_cur.execute(q)
    mysql_res = mysql_cur.fetchall()

    if tidb_res == mysql_res:
        # print(f"  Equal:\n    MySQL:\n      {mysql_res}\n    TiDB:\n      {tidb_res}")
        pass
    else:
        print(f"  Not equal:\n    MySQL:\n      {mysql_res}\n    TiDB:\n      {tidb_res}")