<commit_before>BEGIN;
SELECT * FROM plan(2);

-- 1000 genomes phase1 CHB+JPT
SELECT set_eq(
  'SELECT snp_id,snp_current,snp_in_source,allele,freq::text FROM get_tbl_allele_freq_by_rs_history(1, ARRAY[671,26])',
  $$ VALUES
  (671,      671,      671, '{G,A}'::varchar[], '{0.8145,0.1855}'),
  (26,        26, 78384355, '{C,T}'::varchar[], '{0.6774,0.3226}')
  $$
);

-- 1000 genomes phase3 CHB+JPT
SELECT set_eq(
  'SELECT snp_id,snp_current,allele,freq::text FROM get_tbl_allele_freq_by_rs_history(2, ARRAY[671, 2230021, 4134524, 4986830, 60823674])',
  $$ VALUES
  (671,      671, '{G,A}'::varchar[], '{0.7995,0.2005}'),
  (2230021,  671, '{G,A}'::varchar[], '{0.7995,0.2005}'),
  (4134524,  671, '{G,A}'::varchar[], '{0.7995,0.2005}'),
  (4986830,  671, '{G,A}'::varchar[], '{0.7995,0.2005}'),
  (60823674, 671, '{G,A}'::varchar[], '{0.7995,0.2005}')
  $$
);

SELECT * FROM finish();
ROLLBACK;<commit_msg>update freq data in test<commit_after>BEGIN;
SELECT * FROM plan(1);

-- 1000 genomes phase1 CHB+JPT
-- SELECT set_eq(
--   'SELECT snp_id,snp_current,snp_in_source,allele,freq::text FROM get_tbl_allele_freq_by_rs_history(1, ARRAY[671,26])',
--   $$ VALUES
--   (671,      671,      671, '{G,A}'::varchar[], '{0.8145,0.1855}'),
--   (26,        26, 78384355, '{C,T}'::varchar[], '{0.6774,0.3226}')
--   $$
-- );

-- 1000 genomes phase3 CHB+JPT
SELECT set_eq(
  'SELECT snp_id,snp_current,allele,freq::text FROM get_tbl_allele_freq_by_rs_history(2, ARRAY[671, 2230021, 4134524, 4986830, 60823674])',
  $$ VALUES
  (671,      671, '{G,A}'::varchar[], '{0.799517,0.200483}'),
  (2230021,  671, '{G,A}'::varchar[], '{0.799517,0.200483}'),
  (4134524,  671, '{G,A}'::varchar[], '{0.799517,0.200483}'),
  (4986830,  671, '{G,A}'::varchar[], '{0.799517,0.200483}'),
  (60823674, 671, '{G,A}'::varchar[], '{0.799517,0.200483}')
  $$
);

SELECT * FROM finish();
ROLLBACK;
{'fraction_non_alphanumeric': 0.24171122994652405, 'fraction_numerical': 0.21176470588235294, 'mean_word_length': 4.846875, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3872746', 'n_tokens_mistral': 1084, 'n_tokens_neox': 867, 'n_words': 135}