postgresql-topn icon indicating copy to clipboard operation
postgresql-topn copied to clipboard

Test fail

Open Joezczhang opened this issue 3 years ago • 0 comments

Hello:

when I test this extension with command make installcheck,ERROR named desired number of counters is higher than the topn.number_of_counters variable happened, just like blow:

test add_agg ... ok 427 ms test union_agg ... ok 235 ms test char_tests ... FAILED 44 ms test null_tests ... ok 23 ms test add_union_tests ... FAILED 77 ms test copy_data ... ok 2254 ms test customer_reviews_query ... ok 1840 ms test join_tests ... FAILED 819 ms

information in char_tests.out: SELECT (topn(topn_union_agg(jsonb_column), 9)).* FROM jsonb_table;

  •            item                 | frequency 
    

--------------------------------------+-----------

  • TR | 6
  • CH | 4
  • US | 4
  • FRA | 2
  • ' | 1
  • '"" +++--- <>?//#$%^&*()_+!@/t | 1
  • \\ | 1
  • '"" | 1
  • """"" | 1 -(9 rows)

+ERROR: desired number of counters is higher than the topn.number_of_counters variable do $$ declare @@ -91,19 +79,7 @@ FROM values_table; SELECT (topn(topn_union_agg(jsonb_column), 9)).* FROM jsonb_table;

  • item     | frequency 
    

---------------+-----------

  • кйльжзхцвбнм | 35
  • эасдфгч | 30
  • тыуио | 20
  • пющ | 12
  • ёъяшер | 10
  • TR | 9
  • CH | 6
  • US | 6
  • FRA | 3 -(9 rows)

+ERROR: desired number of counters is higher than the topn.number_of_counters variable do $$ declare

I find this error in function topn in topn.c,what confuses me is why SRF_IS_FIRSTCALL() is always true.

Hope for your help.

Joezczhang avatar Oct 20 '21 08:10 Joezczhang