Property datatypes on Wikidata

Due to T166227, users can create properties with invalid datatypes on Wikidata. This query checks if anyone has actually done that.

SQL

USE `wikidatawiki_p`;

# which pi_types exist in the database?
SELECT `pi_type` FROM `wb_property_info` GROUP BY `pi_type`;

# which types are inside pi_info in the database?
SELECT `pi_info` FROM `wb_property_info` GROUP BY `pi_info`;
# download this result set as TSV and pipe it into:
# tail -n+2 | sed 's|\r$||; s|^"\(.*\)"$|\1|; s|""|"|g' | jq -r .type | sort | uniq -c | sort -nr | tee >(wc -l)

# result: there don’t seem to be any property types in the database other than the expected twelve.

SQL

Checking query status...