<commit_before>
CREATE TABLE "sys"."ways" (
        "id" int NOT NULL,
        "username" varchar(255),
        "timestamp" timestamptz(7),
        CONSTRAINT "ways_id_pkey" PRIMARY KEY ("id")
);
CREATE TABLE way_tags (way integer, k varchar(255), v varchar(1024),
primary key (way, k), foreign key(way) references ways);
alter table ways drop constraint ways_id_pkey;
SELECT count(*) FROM ways
LEFT JOIN way_tags ON
        ways.id = way_tags.way
WHERE
        k = 'highway' AND
        v = 'secondary';

drop table way_tags;
drop table ways;<commit_msg>use unique table names to avoid conflict in case preceeding test fails<commit_after>
CREATE TABLE "sys"."ways" (
        "id" int NOT NULL,
        "username" varchar(255),
        "timestamp" timestamptz(7),
        CONSTRAINT "ways_id_pkey" PRIMARY KEY ("id")
);
CREATE TABLE way_tags2 (way integer, k varchar(255), v varchar(1024),
primary key (way, k), foreign key(way) references ways);
alter table ways drop constraint ways_id_pkey;
SELECT count(*) FROM ways
LEFT JOIN way_tags2 ON
        ways.id = way_tags2.way
WHERE
        k = 'highway' AND
        v = 'secondary';

drop table way_tags2;
drop table ways;
{'fraction_non_alphanumeric': 0.10589239965841162, 'fraction_numerical': 0.02220324508966695, 'mean_word_length': 3.4393939393939394, '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': '4615419', 'n_tokens_mistral': 396, 'n_tokens_neox': 363, 'n_words': 134}