<commit_before><?xml version="1.0" encoding="UTF-8"?>
<sql-cases db-types="PostgreSQL" namespace="postgre.dcl.grant">
    <sql-case id="grant_all_on_table" value="GRANT ALL PRIVILEGES ON TABLE t_order TO role1" />
    <sql-case id="grant_all_on_table_to_current_user" value="GRANT ALL PRIVILEGES ON TABLE t_order TO CURRENT_USER" />
    <sql-case id="grant_select_on_table" value="GRANT SELECT ON TABLE t_order TO role1" />
    <sql-case id="grant_select_on_tables" value="GRANT SELECT ON TABLE t_order, t_order_item TO role1" />
    <sql-case id="grant_select_on_all_tables" value="GRANT SELECT ON ALL TABLES IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_column_on_table" value="GRANT ALL PRIVILEGES (order_id) ON TABLE t_order TO role1" />
    <sql-case id="grant_all_column_on_table_to_current_user" value="GRANT ALL PRIVILEGES (order_id) ON TABLE t_order TO CURRENT_USER" />
    <sql-case id="grant_select_column_on_table" value="GRANT SELECT (order_id) ON TABLE t_order TO role1" />
    <sql-case id="grant_select_column_on_tables" value="GRANT SELECT (order_id) ON TABLE t_order, t_order_item TO role1" />
    <sql-case id="grant_all_on_sequence" value="GRANT ALL PRIVILEGES ON SEQUENCE seq_order_id TO role1" />
    <sql-case id="grant_all_on_sequence_to_current_user" value="GRANT ALL PRIVILEGES ON SEQUENCE seq_order_id TO CURRENT_USER" />
    <sql-case id="grant_select_on_sequence" value="GRANT SELECT ON SEQUENCE seq_order_id TO role1" />
    <sql-case id="grant_select_on_sequences" value="GRANT SELECT ON SEQUENCE seq_order_id, seq_order_item_id TO role1" />
    <sql-case id="grant_select_on_all_sequences" value="GRANT SELECT ON ALL SEQUENCES IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_database" value="GRANT ALL PRIVILEGES ON DATABASE database1 TO role1" />
    <sql-case id="grant_all_on_database_to_current_user" value="GRANT ALL PRIVILEGES ON DATABASE database1 TO CURRENT_USER" />
    <sql-case id="grant_create_on_database" value="GRANT CREATE ON DATABASE database1 TO role1" />
    <sql-case id="grant_create_on_databases" value="GRANT CREATE ON DATABASE database1, database2 TO role1" />
    <sql-case id="grant_all_on_domain" value="GRANT ALL PRIVILEGES ON DOMAIN domain1 TO role1" />
    <sql-case id="grant_all_on_domain_to_current_user" value="GRANT ALL PRIVILEGES ON DOMAIN domain1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_domain" value="GRANT USAGE ON DOMAIN domain1 TO role1" />
    <sql-case id="grant_usage_on_domains" value="GRANT USAGE ON DOMAIN domain1, domain2 TO role1" />
    <sql-case id="grant_all_on_foreign_data_wrapper" value="GRANT ALL PRIVILEGES ON FOREIGN DATA WRAPPER fdw1 TO role1" />
    <sql-case id="grant_all_on_foreign_data_wrapper_to_current_user" value="GRANT ALL PRIVILEGES ON FOREIGN DATA WRAPPER fdw1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_foreign_data_wrapper" value="GRANT USAGE ON FOREIGN DATA WRAPPER fdw1 TO role1" />
    <sql-case id="grant_usage_on_foreign_data_wrappers" value="GRANT USAGE ON FOREIGN DATA WRAPPER fdw1, fdw2 TO role1" />
    <sql-case id="grant_all_on_foreign_server" value="GRANT ALL PRIVILEGES ON FOREIGN SERVER server1 TO role1" />
    <sql-case id="grant_all_on_foreign_server_to_current_user" value="GRANT ALL PRIVILEGES ON FOREIGN SERVER server1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_foreign_server" value="GRANT USAGE ON FOREIGN SERVER server1 TO role1" />
    <sql-case id="grant_usage_on_foreign_servers" value="GRANT USAGE ON FOREIGN SERVER server1, server2 TO role1" />
    <sql-case id="grant_all_on_function" value="GRANT ALL PRIVILEGES ON FUNCTION routine1 TO role1" />
    <sql-case id="grant_all_on_function_to_current_user" value="GRANT ALL PRIVILEGES ON FUNCTION routine1 TO CURRENT_USER" />
    <sql-case id="grant_execute_on_function" value="GRANT EXECUTE ON FUNCTION routine1 TO role1" />
    <sql-case id="grant_execute_on_functions" value="GRANT EXECUTE ON FUNCTION routine1, routine2 TO role1" />
    <sql-case id="grant_execute_on_all_functions" value="GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_language" value="GRANT ALL PRIVILEGES ON LANGUAGE lang1 TO role1" />
    <sql-case id="grant_all_on_language_to_current_user" value="GRANT ALL PRIVILEGES ON LANGUAGE lang1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_language" value="GRANT USAGE ON LANGUAGE lang1 TO role1" />
    <sql-case id="grant_usage_on_languages" value="GRANT USAGE ON LANGUAGE lang1, lang2 TO role1" />
    <sql-case id="grant_all_on_large_object" value="GRANT ALL PRIVILEGES ON LARGE OBJECT loid1 TO role1" />
    <sql-case id="grant_all_on_large_object_to_current_user" value="GRANT ALL PRIVILEGES ON LARGE OBJECT loid1 TO CURRENT_USER" />
    <sql-case id="grant_select_large_object" value="GRANT SELECT ON LARGE OBJECT loid1 TO role1" />
    <sql-case id="grant_select_on_large_objects" value="GRANT SELECT ON LARGE OBJECT loid1, loid2 TO role1" />
    <sql-case id="grant_all_on_schema" value="GRANT ALL PRIVILEGES ON SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_schema_to_current_user" value="GRANT ALL PRIVILEGES ON SCHEMA schema1 TO role1" />
    <sql-case id="grant_create_on_schema" value="GRANT CREATE ON SCHEMA schema1 TO role1" />
    <sql-case id="grant_create_on_schemas" value="GRANT CREATE ON SCHEMA schema1, schema2 TO role1" />
    <sql-case id="grant_all_on_tablespace" value="GRANT ALL PRIVILEGES ON TABLESPACE tablespace1 TO role1" />
    <sql-case id="grant_all_on_tablespace_to_current_user" value="GRANT ALL PRIVILEGES ON TABLESPACE tablespace1 TO CURRENT_USER" />
    <sql-case id="grant_create_on_tablespace" value="GRANT CREATE ON TABLESPACE tablespace1 TO role1" />
    <sql-case id="grant_create_on_tablespaces" value="GRANT CREATE ON TABLESPACE tablespace1, tablespace2 TO role1" />
    <sql-case id="grant_all_on_type" value="GRANT ALL PRIVILEGES ON TYPE type1 TO role1" />
    <sql-case id="grant_all_on_type_to_current_user" value="GRANT ALL PRIVILEGES ON TYPE type1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_type" value="GRANT USAGE ON TYPE type1 TO role1" />
    <sql-case id="grant_usage_on_types" value="GRANT USAGE ON TYPE type1, type2 TO role1" />
    <sql-case id="grant_role" value="GRANT role1 TO role2" />
    <sql-case id="grant_roles" value="GRANT role1, role2 TO role3, role4" />
</sql-cases><commit_msg>add postgre grant test case<commit_after><?xml version="1.0" encoding="UTF-8"?>
<sql-cases db-types="PostgreSQL" namespace="postgre.dcl.grant">
    <sql-case id="grant_all_on_table" value="GRANT ALL PRIVILEGES ON TABLE t_order TO role1" />
    <sql-case id="grant_all_on_table_to_roles" value="GRANT ALL PRIVILEGES ON TABLE t_order TO role1, role2" />
    <sql-case id="grant_all_on_table_to_current_user" value="GRANT ALL PRIVILEGES ON TABLE t_order TO CURRENT_USER" />
    <sql-case id="grant_select_on_table" value="GRANT SELECT ON TABLE t_order TO role1" />
    <sql-case id="grant_select_on_tables" value="GRANT SELECT ON TABLE t_order, t_order_item TO role1" />
    <sql-case id="grant_select_on_all_tables" value="GRANT SELECT ON ALL TABLES IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_column_on_table" value="GRANT ALL PRIVILEGES (order_id) ON TABLE t_order TO role1" />
    <sql-case id="grant_all_column_on_table_to_roles" value="GRANT ALL PRIVILEGES (order_id) ON TABLE t_order TO role1, role2" />
    <sql-case id="grant_all_column_on_table_to_current_user" value="GRANT ALL PRIVILEGES (order_id) ON TABLE t_order TO CURRENT_USER" />
    <sql-case id="grant_select_column_on_table" value="GRANT SELECT (order_id) ON TABLE t_order TO role1" />
    <sql-case id="grant_select_column_on_tables" value="GRANT SELECT (order_id) ON TABLE t_order, t_order_item TO role1" />
    <sql-case id="grant_all_on_sequence" value="GRANT ALL PRIVILEGES ON SEQUENCE seq_order_id TO role1" />
    <sql-case id="grant_all_on_sequence_to_roles" value="GRANT ALL PRIVILEGES ON SEQUENCE seq_order_id TO role1, role2" />
    <sql-case id="grant_all_on_sequence_to_current_user" value="GRANT ALL PRIVILEGES ON SEQUENCE seq_order_id TO CURRENT_USER" />
    <sql-case id="grant_select_on_sequence" value="GRANT SELECT ON SEQUENCE seq_order_id TO role1" />
    <sql-case id="grant_select_on_sequences" value="GRANT SELECT ON SEQUENCE seq_order_id, seq_order_item_id TO role1" />
    <sql-case id="grant_select_on_all_sequences" value="GRANT SELECT ON ALL SEQUENCES IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_database" value="GRANT ALL PRIVILEGES ON DATABASE database1 TO role1" />
    <sql-case id="grant_all_on_database_to_roles" value="GRANT ALL PRIVILEGES ON DATABASE database1 TO role1, role2" />
    <sql-case id="grant_all_on_database_to_current_user" value="GRANT ALL PRIVILEGES ON DATABASE database1 TO CURRENT_USER" />
    <sql-case id="grant_create_on_database" value="GRANT CREATE ON DATABASE database1 TO role1" />
    <sql-case id="grant_create_on_databases" value="GRANT CREATE ON DATABASE database1, database2 TO role1" />
    <sql-case id="grant_all_on_domain" value="GRANT ALL PRIVILEGES ON DOMAIN domain1 TO role1" />
    <sql-case id="grant_all_on_domain_to_roles" value="GRANT ALL PRIVILEGES ON DOMAIN domain1 TO role1, role2" />
    <sql-case id="grant_all_on_domain_to_current_user" value="GRANT ALL PRIVILEGES ON DOMAIN domain1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_domain" value="GRANT USAGE ON DOMAIN domain1 TO role1" />
    <sql-case id="grant_usage_on_domains" value="GRANT USAGE ON DOMAIN domain1, domain2 TO role1" />
    <sql-case id="grant_all_on_foreign_data_wrapper" value="GRANT ALL PRIVILEGES ON FOREIGN DATA WRAPPER fdw1 TO role1" />
    <sql-case id="grant_all_on_foreign_data_wrapper_to_roles" value="GRANT ALL PRIVILEGES ON FOREIGN DATA WRAPPER fdw1 TO role1, role2" />
    <sql-case id="grant_all_on_foreign_data_wrapper_to_current_user" value="GRANT ALL PRIVILEGES ON FOREIGN DATA WRAPPER fdw1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_foreign_data_wrapper" value="GRANT USAGE ON FOREIGN DATA WRAPPER fdw1 TO role1" />
    <sql-case id="grant_usage_on_foreign_data_wrappers" value="GRANT USAGE ON FOREIGN DATA WRAPPER fdw1, fdw2 TO role1" />
    <sql-case id="grant_all_on_foreign_server" value="GRANT ALL PRIVILEGES ON FOREIGN SERVER server1 TO role1" />
    <sql-case id="grant_all_on_foreign_server_to_roles" value="GRANT ALL PRIVILEGES ON FOREIGN SERVER server1 TO role1, role2" />
    <sql-case id="grant_all_on_foreign_server_to_current_user" value="GRANT ALL PRIVILEGES ON FOREIGN SERVER server1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_foreign_server" value="GRANT USAGE ON FOREIGN SERVER server1 TO role1" />
    <sql-case id="grant_usage_on_foreign_servers" value="GRANT USAGE ON FOREIGN SERVER server1, server2 TO role1" />
    <sql-case id="grant_all_on_function" value="GRANT ALL PRIVILEGES ON FUNCTION routine1 TO role1" />
    <sql-case id="grant_all_on_function_to_roles" value="GRANT ALL PRIVILEGES ON FUNCTION routine1 TO role1, role2" />
    <sql-case id="grant_all_on_function_to_current_user" value="GRANT ALL PRIVILEGES ON FUNCTION routine1 TO CURRENT_USER" />
    <sql-case id="grant_execute_on_function" value="GRANT EXECUTE ON FUNCTION routine1 TO role1" />
    <sql-case id="grant_execute_on_functions" value="GRANT EXECUTE ON FUNCTION routine1, routine2 TO role1" />
    <sql-case id="grant_execute_on_all_functions" value="GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_language" value="GRANT ALL PRIVILEGES ON LANGUAGE lang1 TO role1" />
    <sql-case id="grant_all_on_language_to_roles" value="GRANT ALL PRIVILEGES ON LANGUAGE lang1 TO role1, role2" />
    <sql-case id="grant_all_on_language_to_current_user" value="GRANT ALL PRIVILEGES ON LANGUAGE lang1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_language" value="GRANT USAGE ON LANGUAGE lang1 TO role1" />
    <sql-case id="grant_usage_on_languages" value="GRANT USAGE ON LANGUAGE lang1, lang2 TO role1" />
    <sql-case id="grant_all_on_large_object" value="GRANT ALL PRIVILEGES ON LARGE OBJECT loid1 TO role1" />
    <sql-case id="grant_all_on_large_object_to_roles" value="GRANT ALL PRIVILEGES ON LARGE OBJECT loid1 TO role1, role2" />
    <sql-case id="grant_all_on_large_object_to_current_user" value="GRANT ALL PRIVILEGES ON LARGE OBJECT loid1 TO CURRENT_USER" />
    <sql-case id="grant_select_large_object" value="GRANT SELECT ON LARGE OBJECT loid1 TO role1" />
    <sql-case id="grant_select_on_large_objects" value="GRANT SELECT ON LARGE OBJECT loid1, loid2 TO role1" />
    <sql-case id="grant_all_on_schema" value="GRANT ALL PRIVILEGES ON SCHEMA schema1 TO role1" />
    <sql-case id="grant_all_on_schema_to_roles" value="GRANT ALL PRIVILEGES ON SCHEMA schema1 TO role1, role2" />
    <sql-case id="grant_all_on_schema_to_current_user" value="GRANT ALL PRIVILEGES ON SCHEMA schema1 TO CURRENT_USER" />
    <sql-case id="grant_create_on_schema" value="GRANT CREATE ON SCHEMA schema1 TO role1" />
    <sql-case id="grant_create_on_schemas" value="GRANT CREATE ON SCHEMA schema1, schema2 TO role1" />
    <sql-case id="grant_all_on_tablespace" value="GRANT ALL PRIVILEGES ON TABLESPACE tablespace1 TO role1" />
    <sql-case id="grant_all_on_tablespace_to_roles" value="GRANT ALL PRIVILEGES ON TABLESPACE tablespace1 TO role1, role2" />
    <sql-case id="grant_all_on_tablespace_to_current_user" value="GRANT ALL PRIVILEGES ON TABLESPACE tablespace1 TO CURRENT_USER" />
    <sql-case id="grant_create_on_tablespace" value="GRANT CREATE ON TABLESPACE tablespace1 TO role1" />
    <sql-case id="grant_create_on_tablespaces" value="GRANT CREATE ON TABLESPACE tablespace1, tablespace2 TO role1" />
    <sql-case id="grant_all_on_type" value="GRANT ALL PRIVILEGES ON TYPE type1 TO role1" />
    <sql-case id="grant_all_on_type_to_roles" value="GRANT ALL PRIVILEGES ON TYPE type1 TO role1, role2" />
    <sql-case id="grant_all_on_type_to_current_user" value="GRANT ALL PRIVILEGES ON TYPE type1 TO CURRENT_USER" />
    <sql-case id="grant_usage_on_type" value="GRANT USAGE ON TYPE type1 TO role1" />
    <sql-case id="grant_usage_on_types" value="GRANT USAGE ON TYPE type1, type2 TO role1" />
    <sql-case id="grant_role" value="GRANT role1 TO role2" />
    <sql-case id="grant_roles" value="GRANT role1, role2 TO role3, role4" />
</sql-cases>
{'fraction_non_alphanumeric': 0.09693806541405707, 'fraction_numerical': 0.017049408489909535, 'mean_word_length': 5.461780575539568, 'pattern_counts': {'":': 0, '<': 136, '<?xml version=': 2, '>': 136, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, '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': '3112716', 'n_tokens_mistral': 5553, 'n_tokens_neox': 5213, 'n_words': 1319}