the run

audit-2ed41f69-8e39-4e9d-9cd1-737fad320828 exit status 1

The whole of this run is a release asset

This site holds 15 of the 162 question directories this run wrote; the archive holds every one:

archive
minidev-pg-meta-llama-3-8b-instruct-2.tar.gz
size
11,791,203 bytes
sha256
0d6e5bbec913c07edab6f3b02f2fee9433b1d091d0ccd965ff5bf00c5706e751

What it counted

whathow many
questions audited498
ERROR258
NOT_EQUAL158
EQUAL82
probes fired15
the verdicts of run audit-2ed41f69-8e39-4e9d-9cd1-737fad320828, from summary.json258 ERROR10 multiplicity2 type1 other145 NOT_EQUAL82 EQUAL
Of the questions this run audited: 258 ERROR, 10 multiplicity, 2 type, 1 other, 145 NOT_EQUAL, 82 EQUAL

the probes

probefired on
ordering-over-numeric-text1
arbitrary-cut7
not-a-function-of-the-data5
float-aggregate-order2
direction-against-question0
how many golds each probe fired on, of 498, from summary.json1 ordering-over-numeric-text7 arbitrary-cut5 not-a-function-of-the-data2 float-aggregate-order0 direction-against-question
Of 498 golds this run read, the probes fired on: ordering-over-numeric-text on 1; arbitrary-cut on 7; not-a-function-of-the-data on 5; float-aggregate-order on 2.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here12
multiplicity10
type2
order0
truncation0
other0
the test-suite check answered 12
the test-suite check answered 010

What the run was made of

run
audit-2ed41f69-8e39-4e9d-9cd1-737fad320828
summary format
attestql/audit/summary/2
question file
data/questions/mini_dev_postgresql.json sha256:d2731292f20b8d8569cd956dd747ffe1df13cd625076263e38ae9ebcef50b1ab | https://bird-bench.oss-cn-beijing.aliyuncs.com/minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f, downloaded 2026-09-07), member minidev/MINIDEV/mini_dev_postgresql.json, 2024-06-19
questions in the file
500
prediction file
data/preds-pg/predict_mini_dev_meta-llama-3-8b-instruct-2_postgresql.json sha256:aa8d2ecc9d70a14d315648a939eb0e9104a2b1e4bd09047391ed9539865f8876 | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_meta-llama-3-8b-instruct-2_postgresql.json, 2024-06-19
statements read
500
keyed by
position
data file
data/minidev/BIRD_dev.sql sha256:31b1da211849d24a57c9af7636da46a5b82fc8a3ca1542bb3ebd8775e9a31cec | minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f), member minidev/MINIDEV_postgresql/BIRD_dev.sql, 2024-06-13
server
PostgreSQL 16.15 (Debian 16.15-1.pgdg13+2) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit | server=172.17.0.2/32:5432 | database=bird
database role
auditor
engine
postgresql
parser
validator audit:libpg_query-parse, postgast 0.1.0, grammar_version 170007
serialization
attestql/audit/2
statement timeout
120 s
fixture digest depth
counts
schema digest
sha256:25aabd5763d7a18135a8741194c4a704141761bd0c7fdbfbf3f7c2bc9e0bf08c
data as of
2026-09-08T05:31:08.958184+00:00 the instant the run started
shuffled copies
prepared
shuffle seed
1
experimental probe
off

The session the run was made in

what the engine reported, 10 settings
statement_timeout
0
search_path
"$user", public
server_version
16.15 (Debian 16.15-1.pgdg13+2)
server_version_num
160015
transaction_read_only
on
max_parallel_workers_per_gather
2
server_encoding
UTF8
datlocprovider
c
daticulocale
datcollversion
2.41

What the run states about itself

ids the question file states twice
137, 138
prediction positions not compared
487, 488
stopped by the statement timeout, prediction
694 the run's bound was 120 s

The questions

question rule verdict class probes what was asked
q82 R-ORD NOT_EQUAL other arbitrary-cut not-a-function-of-the-data What is the grade span offered in the school with the highest longitude?
q249 R-SET NOT_EQUAL multiplicity What are the elements of the atoms of TR144_8_19?
q345 R-SET NOT_EQUAL multiplicity For artifact type of cards that do not have multiple faces on the same card, state its legalities status for vintage play format.
q358 R-SET NOT_EQUAL multiplicity What is the border color of card "Ancestor's Chosen"?
q440 R-SET NOT_EQUAL multiplicity Which foreign language used by "A Pedra Fellwar"?
q565 R-SET NOT_EQUAL type User No.23853 gave a comment to a post at 9:08:18 on 2013/7/12, was that post well-finished?
q850 R-SET NOT_EQUAL multiplicity Please give the name of the race held on the circuits in Germany.
q868 R-SET NOT_EQUAL multiplicity Where is Malaysian Grand Prix held? Give the location coordinates.
q1035 R-SET NOT_EQUAL multiplicity Give the team_fifa_api_id of teams with more than 50 but less than 60 build-up play speed.
q1331 R-SET NOT_EQUAL type What is the amount of the funds that the Vice President received?
q1361 R-SET EQUAL float-aggregate-order What is the total cost of the pizzas for all the events?
q1380 R-SET EQUAL float-aggregate-order What is the total amount of money spent for food?
q1422 R-SET NOT_EQUAL multiplicity State the category of events were held at MU 215.
q1457 R-SET NOT_EQUAL multiplicity Give the full name and contact number of members who had to spend more than average on each expense.
q1506 R-SET NOT_EQUAL multiplicity Please list the product descriptions of the transactions taken place in the gas stations in the Czech Republic.
q1471 ERROR prediction: execute: execute: column "currency" does not exist LINE 1: SELECT COUNT(CASE WHEN currency = 'EUR' THEN 1 ELSE NULL END... ^
q1481 ERROR prediction: execute: execute: column "segment" does not exist LINE 2: ...ption) FROM yearmonth WHERE date LIKE '2013%' AND segment = ... ^
q1482 ERROR prediction: execute: execute: column "segment" does not exist LINE 2: segment, ^
q1486 ERROR run: row_counts: row_counts: relation "public.currencies" does not exist LINE 1: SELECT count(*) FROM "public"."currencies" ^
q1493 ERROR prediction: execute: execute: column "consumption" does not exist LINE 2: (COUNT(*) FILTER (WHERE consumption > 528.3))::FLOAT / (... ^
q1501 ERROR prediction: execute: execute: date/time field value out of range: "201306" LINE 6: WHERE date = '201306' ^ HINT: Perhaps you need a different "datestyle" setting.
q1505 ERROR prediction: execute: execute: column "currency" does not exist LINE 6: WHERE currency = 'EUR' ^
q1507 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 2: EXTRACT(HOUR FROM time) AS hour, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1515 ERROR prediction: execute: execute: column ym.segment does not exist LINE 1: SELECT ym.segment ^
q1524 ERROR prediction: execute: execute: column c.country does not exist LINE 1: SELECT ym.customerid, c.country ^
q1529 ERROR prediction: statement: 2 statements in one text; an audit runs one
q1531 ERROR prediction: execute: execute: column t.currency does not exist LINE 1: ...customerid, c.segment, AVG(t.price) AS avg_price, t.currency ^ HINT: Perhaps you meant to reference the column "c.currency".
q1533 ERROR prediction: execute: execute: division by zero
q1312 ERROR run: row_counts: row_counts: relation "public.link_to_major" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_major" ^
q1317 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1322 ERROR prediction: execute: execute: aggregate functions are not allowed in WHERE LINE 5: WHERE e.type = 'Meeting' AND COUNT(e.event_id) > 10; ^
q1338 ERROR run: row_counts: row_counts: relation "public.link_to_event" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_event" ^
q1339 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 8: AND EXTRACT(MONTH FROM expense_date) IN (9, 10); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1340 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q1350 ERROR prediction: execute: execute: column b.link_to_budget does not exist LINE 4: JOIN expense e1 ON b.link_to_budget = e1.link_to_budget ^ HINT: Perhaps you meant to reference the column "e1.link_to_budget".
q1351 ERROR prediction: execute: execute: column major.link_to_major does not exist LINE 3: JOIN member ON major.link_to_major = member.member_id ^
q1356 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1359 ERROR prediction: execute: execute: column "event_name" does not exist LINE 4: AND event_name IN ('Yearly Kickoff', 'October Meeting') ^
q1368 ERROR run: row_counts: row_counts: relation "public.link_to_major" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_major" ^
q1375 ERROR run: row_counts: row_counts: relation "public.link_to_major" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_major" ^
q1389 ERROR prediction: execute: execute: column e1.link_to_event does not exist LINE 3: JOIN expense e1 ON e.event_id = e1.link_to_event ^
q1390 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q1394 ERROR run: row_counts: row_counts: relation "public.link_to_major" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_major" ^
q1401 ERROR prediction: execute: execute: column "link_to_event" does not exist LINE 4: AND link_to_event IN (SELECT event_id ^
q1404 ERROR prediction: execute: execute: column e.event_name does not exist LINE 2: e.event_name, ^ HINT: Perhaps you meant to reference the column "ev.event_name".
q1410 ERROR prediction: execute: execute: column e.link_to_event does not exist LINE 4: JOIN expense e ON a.link_to_event = e.link_to_event ^ HINT: Perhaps you meant to reference the column "a.link_to_event".
q1426 ERROR run: row_counts: row_counts: relation "public.link_to_major" does not exist LINE 1: SELECT count(*) FROM "public"."link_to_major" ^
q1432 ERROR prediction: execute: execute: column "t_shirt_size" does not exist LINE 1: SELECT (COUNT(CASE WHEN t_shirt_size = 'Medium' AND link_to_... ^
q1460 ERROR prediction: execute: execute: column e.link_to_event does not exist LINE 4: JOIN expense e ON a.link_to_event = e.link_to_event ^ HINT: Perhaps you meant to reference the column "a.link_to_event".
q1150 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1152 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: ...NT(*) FROM Patient p JOIN Examination e ON p.ID = e.Patient_... ^
q1153 ERROR prediction: execute: execute: column e.examination_id does not exist LINE 3: JOIN Laboratory l ON e.examination_id = l.examination_id ^
q1155 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1156 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1157 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1162 ERROR prediction: execute: execute: function year(date) does not exist LINE 4: AND year(Description) = '1997' ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1164 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1166 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1168 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1169 ERROR prediction: execute: execute: column p.patientid does not exist LINE 7: Examination e ON p.PatientID = e.PatientID ^
q1171 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1175 ERROR prediction: execute: execute: column p.patientid does not exist LINE 7: Examination e ON p.PatientID = e.PatientID ^
q1179 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.Patient_ID = e.Patient_ID ^
q1185 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 6: Examination t ON p.patient_id = t.patient_id ^
q1187 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1189 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1192 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.Patient_ID = e.Patient_ID ^
q1195 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1198 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1201 ERROR prediction: execute: execute: column "birthday" does not exist LINE 1: SELECT (COUNT(CASE WHEN YEAR(BIRTHDAY) = '1980' AND Diagnosi... ^
q1205 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1208 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.Patient_ID = e.Patient_ID ^
q1209 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1220 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1225 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 7: Examination e ON p.ID = e.Patient_ID ^
q1227 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1229 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1231 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1232 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1235 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1238 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1239 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.ID = e.Patient_ID ^
q1241 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1242 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1243 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 6: JOIN EXAMINATION ON PATIENT.PatientID = EXAMINATION.Pati... ^
q1247 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1251 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1252 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1254 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1255 ERROR run: row_counts: row_counts: relation "public.diagnosis" does not exist LINE 1: SELECT count(*) FROM "public"."diagnosis" ^
q1256 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: LEFT JOIN Examination e ON p.PatientID = e.PatientID ^
q1257 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1265 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1267 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1270 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1275 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1281 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1302 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1028 ERROR prediction: execute: execute: column pa.match_api_id does not exist LINE 4: JOIN Player_Attributes pa ON m.match_api_id = pa.match_api_i... ^ HINT: Perhaps you meant to reference the column "m.match_api_id".
q1029 ERROR prediction: execute: execute: column ta.teamid does not exist LINE 3: JOIN Team_Attributes ta ON t.id = ta.teamId ^
q1030 ERROR prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT league_name ^
q1031 ERROR prediction: execute: execute: column p.player_id does not exist LINE 11: Player_Attributes pa ON p.player_id = pa.player_id ^
q1032 ERROR prediction: execute: execute: column l.league_id does not exist LINE 3: JOIN Match m ON l.league_id = m.league_id ^ HINT: Perhaps you meant to reference the column "m.league_id".
q1036 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 6: WHERE strftime('%Y', date) = '2012' ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1037 ERROR prediction: execute: execute: function multiply(bigint, integer) does not exist LINE 2: DIVIDE(MULTIPLY((SUM(CASE WHEN preferred_foot = 'left' T... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1044 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1048 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1057 ERROR prediction: execute: execute: column "name" does not exist LINE 3: WHERE name = 'Poland' ^ HINT: Perhaps you meant to reference the column "match.date".
q1058 ERROR prediction: execute: execute: column p1.player_id does not exist LINE 3: JOIN Player_Attributes pa1 ON p1.player_id = pa1.player_id ^
q1068 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 3: WHERE strftime('%Y', t2.date) >= '2010' AND strftime('%Y', t... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1076 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name IN ('Abdou Diallo', 'Aaron Appindangoye'); ^
q1079 ERROR prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_id = pa.player_id ^
q1084 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1088 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1091 ERROR prediction: execute: execute: missing FROM-clause entry for table "league" LINE 3: WHERE League.name = 'Belgium Jupiler League' ^
q1092 ERROR prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT league_name ^
q1094 ERROR prediction: execute: execute: column "overall_rating" does not exist LINE 1: SELECT (DIVIDE(SUBTRACT((SELECT overall_rating FROM Player W... ^
q1096 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Pietro Marino'; ^
q1098 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.id ^
q1102 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1103 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.player_id ^
q1105 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.id ^
q1107 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Kevin Constant' ^
q1110 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.id ^
q1113 ERROR prediction: execute: execute: column ta.defence_aggression does not exist LINE 1: SELECT ta.defence_aggression ^ HINT: Perhaps you meant to reference the column "ta.defenceaggression".
q1114 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Marko Arnautovic' ^
q1115 ERROR prediction: statement: the text does not parse: syntax error at or near "overall_rating"
q1116 ERROR prediction: execute: execute: column pa.player_name does not exist LINE 1: SELECT pa.player_name ^
q1122 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1124 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1130 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.id ^
q1134 ERROR prediction: execute: execute: column pa1.player_id does not exist LINE 3: JOIN Player_Attributes pa2 ON pa1.player_id = 6 AND pa2.play... ^
q1135 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.player_id ^
q1139 ERROR prediction: execute: execute: missing FROM-clause entry for table "league" LINE 3: WHERE date = '2008-09-24' AND League.name = 'Belgium Jupiler... ^
q1141 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 3: WHERE team_long_name = 'KSV Cercle Brugge' AND buildUpPlaySp... ^
q1144 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.player_id ^
q1146 ERROR prediction: execute: execute: column "team.team_api_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 4: WHERE Match.away_team_api_id = (SELECT team_api_id ^
q1147 ERROR prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_id = pa.player_id ^
q1148 ERROR prediction: execute: execute: column pa.height does not exist LINE 1: SELECT (COUNT(pa.height < 180 AND pa.overall_rating > 70)::f... ^
q859 ERROR prediction: execute: execute: more than one row returned by a subquery used as an expression
q869 ERROR prediction: execute: execute: missing FROM-clause entry for table "c" LINE 1: SELECT c.url ^
q880 ERROR prediction: execute: execute: column "raceid" does not exist LINE 1: SELECT (fastestLapSpeed(raceId = 853) - (fastestLapSpeed(rac... ^
q895 ERROR prediction: execute: execute: missing FROM-clause entry for table "races" LINE 5: AND races.name = 'Malaysian Grand Prix' ^
q896 ERROR prediction: execute: execute: column "surname" does not exist LINE 2: ...aceid) / (SELECT COUNT(raceid) FROM results WHERE surname = ... ^
q897 ERROR prediction: execute: execute: column r.wins does not exist LINE 5: ORDER BY COUNT(r.wins) DESC LIMIT 1; ^
q898 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 3: YEAR(CURRENT_TIMESTAMP) - YEAR(d.dob) AS age ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q901 ERROR prediction: execute: execute: function month(date) does not exist LINE 4: WHERE MONTH(r.date) = 9 AND YEAR(r.date) = 2005; ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q904 ERROR prediction: execute: execute: missing FROM-clause entry for table "s" LINE 1: SELECT r.name, s.year ^
q906 ERROR prediction: execute: execute: missing FROM-clause entry for table "r" LINE 1: SELECT r.date, r.time, r.url, r.name, r.year, r.round, r.cir... ^
q909 ERROR prediction: execute: execute: column r.country does not exist LINE 3: WHERE r.name = 'European Grand Prix' AND r.country = 'German... ^
q915 ERROR prediction: execute: execute: column c.country does not exist LINE 1: SELECT c.country, d.surname, d.dob ^
q931 ERROR prediction: execute: execute: column results.year does not exist LINE 4: WHERE races.name = 'Spanish Grand Prix' AND results.year = 2... ^
q933 ERROR prediction: execute: execute: missing FROM-clause entry for table "races" LINE 4: ...me = 'Lewis' AND drivers.surname = 'Hamilton' AND races.name... ^
q944 ERROR prediction: execute: execute: operator does not exist: text - text LINE 1: ...stralian Grand Prix') ORDER BY time DESC LIMIT 1) - (SELECT ... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q954 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q955 ERROR prediction: execute: execute: column r.year does not exist LINE 7: seasons s ON r.year = s.year ^ HINT: Perhaps you meant to reference the column "s.year".
q959 ERROR prediction: execute: execute: column r.year does not exist LINE 4: JOIN seasons s ON r.year = s.year ^ HINT: Perhaps you meant to reference the column "s.year".
q960 ERROR prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT AVG(fastestLapSpeed) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q962 ERROR prediction: execute: execute: function year(date) does not exist LINE 1: ...r.driverid) / (SELECT COUNT(*) FROM drivers WHERE year(dob) ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q967 ERROR prediction: statement: 2 statements in one text; an audit runs one
q981 ERROR prediction: execute: execute: more than one row returned by a subquery used as an expression
q988 ERROR prediction: execute: execute: column ps.resultid does not exist LINE 4: JOIN pitStops ps ON r.resultid = ps.resultid ^ HINT: Perhaps you meant to reference the column "r.resultid".
q1001 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 5: WHERE q.qualifyid IN ( ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1014 ERROR prediction: execute: execute: column lt.circuitid does not exist LINE 3: JOIN lapTimes lt ON c.circuitid = lt.circuitid ^ HINT: Perhaps you meant to reference the column "c.circuitid".
q736 ERROR prediction: execute: execute: column ha.attribute_name does not exist LINE 4: WHERE ha.attribute_name = 'Intelligence' ^ HINT: Perhaps you meant to reference the column "ha.attribute_value".
q740 ERROR prediction: execute: execute: column attribute.attribute_value does not exist LINE 7: AND attribute.attribute_value = 100; ^ HINT: Perhaps you meant to reference the column "attribute.attribute_name".
q758 ERROR prediction: execute: execute: column s.race does not exist LINE 4: WHERE s.height_cm = 185 AND s.race = 'human'; ^
q760 ERROR prediction: execute: execute: column "publisher_name" does not exist LINE 2: (COUNT(CASE WHEN publisher_name = 'Marvel Comics' THEN 1... ^
q764 ERROR prediction: execute: execute: column s.power_name does not exist LINE 1: SELECT s.power_name ^
q773 ERROR prediction: statement: the text does not parse: syntax error at or near "JOIN"
q775 ERROR prediction: execute: execute: column "skin_colour_id" does not exist LINE 1: SELECT MULTIPLY(DIVIDE(SUM(skin_colour_id = (SELECT id FROM ... ^
q786 ERROR prediction: execute: execute: column "attribute_name" does not exist LINE 3: WHERE attribute_name = 'Strength' ^ HINT: Perhaps you meant to reference the column "hero_attribute.attribute_value".
q788 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q790 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q792 ERROR prediction: execute: execute: column "power_name" does not exist LINE 1: SELECT power_name ^
q796 ERROR prediction: execute: execute: column ha.attribute_name does not exist LINE 1: SELECT ha.attribute_name, ha.attribute_value ^ HINT: Perhaps you meant to reference the column "ha.attribute_value".
q800 ERROR prediction: execute: execute: column "eye_colour_id" does not exist LINE 1: SELECT MULTIPLY(DIVIDE(SUM(CASE WHEN eye_colour_id = 7 THEN ... ^
q801 ERROR prediction: execute: execute: column "gender_id" does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN gender_id = 1 THEN 1 ELSE 0 END)... ^
q825 ERROR prediction: execute: execute: column s.gender does not exist LINE 1: SELECT s.gender ^ HINT: Perhaps you meant to reference the column "s.gender_id".
q829 ERROR prediction: execute: execute: column "publisher_name" does not exist LINE 2: SUM(CASE WHEN publisher_name = 'DC Comics' THEN 1 ELSE 0... ^
q572 ERROR prediction: execute: execute: column "views" does not exist LINE 1: SELECT views ^
q584 ERROR prediction: execute: execute: column ph.editeddate does not exist LINE 9: AND ph.editeddate = p.lasteditdate ^
q629 ERROR prediction: execute: execute: function year(date) does not exist LINE 1: SELECT COUNT(id) FILTER(WHERE YEAR(creationdate) = 2010) / C... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q639 ERROR prediction: execute: execute: missing FROM-clause entry for table "p" LINE 2: (COUNT(p.id) FILTER (WHERE p.posttypeid = 2 AND EXISTS (... ^
q665 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT AVG(COUNT(*)) ^
q682 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 3: WHERE year(p.creaiondate) = 2010 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q694 ERROR prediction: execute: execute: canceling statement due to statement timeout
q701 ERROR prediction: execute: execute: subquery uses ungrouped column "u.id" from outer query LINE 2: .../ (SELECT COUNT(*) FROM posts WHERE owneruserid = u.id)) * 1... ^
q716 ERROR prediction: execute: execute: column "upvotes" does not exist LINE 2: DIVIDE(COUNT(CASE WHEN upvotes = 0 THEN 1 ELSE NULL END)... ^
q344 ERROR prediction: execute: execute: column l.multiverseid does not exist LINE 3: JOIN legalities l ON c.multiverseid = l.multiverseid ^ HINT: Perhaps you meant to reference the column "c.multiverseid".
q346 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 3: JOIN legalities l ON c.id = l.uuid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q347 ERROR prediction: statement: 2 statements in one text; an audit runs one
q349 ERROR prediction: execute: execute: column "scryfallid" does not exist LINE 4: SELECT scryfallid, COUNT(*) as count ^ DETAIL: There is a column named "scryfallid" in table "c", but it cannot be referenced from this part of the query. HINT: To reference that column, you must mark this subquery with LATERAL.
q352 ERROR prediction: execute: execute: column c.language does not exist LINE 3: WHERE c.language = 'Chinese Simplified'; ^
q366 ERROR prediction: execute: execute: column s.uuid does not exist LINE 6: sets s ON l.uuid = s.uuid ^ HINT: Perhaps you meant to reference the column "l.uuid".
q368 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q371 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q377 ERROR prediction: execute: execute: column "subtype" does not exist LINE 4: AND subtype != 'Angel'; ^ HINT: Perhaps you meant to reference the column "cards.subtypes".
q383 ERROR prediction: execute: execute: column "status" does not exist LINE 3: WHERE status = 'Banned' AND bordercolor = 'white'; ^
q391 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: JOIN foreign_data f ON c.multiverseid = f.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q407 ERROR prediction: execute: execute: column s.subtypes does not exist LINE 1: SELECT DISTINCT s.subtypes, s.supertypes ^ HINT: Perhaps you meant to reference the column "c.subtypes".
q409 ERROR prediction: execute: execute: column "format" does not exist LINE 3: WHERE format = 'premodern' ^
q412 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: JOIN foreign_data fd ON c.multiverseid = fd.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q415 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(COUNT(CASE WHEN hasContentWarning = 0 THEN 1 E... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q416 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: JOIN foreign_data f ON c.multiverseid = f.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q424 ERROR prediction: execute: execute: column "istextless" does not exist LINE 1: SELECT (COUNT(CASE WHEN isTextless = 1 AND layout = 'normal'... ^
q427 ERROR prediction: execute: execute: column "mcmname" does not exist LINE 3: ...iverseid IN (SELECT multiverseid FROM cards WHERE mcmname = ... ^
q465 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 7: WHERE cards.multiverseid = foreign_data.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q480 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 3: JOIN cards c ON fd.multiverseid = c.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q483 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 6: cards c ON f.multiverseid = c.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q484 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: JOIN foreign_data f ON c.multiverseid = f.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q486 ERROR prediction: execute: execute: missing FROM-clause entry for table "cards" LINE 1: SELECT (SUM(CASE WHEN cards.setcode = 'Coldsnap' AND cards.c... ^
q487 ERROR prediction: execute: execute: column "cardkingdomfoilid" does not exist LINE 1: SELECT (SUM(CASE WHEN cardKingdomFoilId IS NOT NULL AND card... ^
q518 ERROR run: row_counts: row_counts: relation "public.format" does not exist LINE 1: SELECT count(*) FROM "public"."format" ^
q522 ERROR prediction: execute: execute: column l.multiverseid does not exist LINE 3: JOIN legalities l ON c.multiverseid = l.multiverseid ^ HINT: Perhaps you meant to reference the column "c.multiverseid".
q528 ERROR prediction: execute: execute: column l.multiverseid does not exist LINE 3: JOIN legalities l ON c.multiverseid = l.multiverseid ^ HINT: Perhaps you meant to reference the column "c.multiverseid".
q529 ERROR prediction: execute: execute: column s.language does not exist LINE 3: WHERE s.language NOT LIKE '%Japanese%' AND EXISTS ( ^
q530 ERROR prediction: statement: 3 statements in one text; an audit runs one
q197 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT AVG(COUNT(element = 'o')) ^
q198 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT AVG(COUNT(*)) ^
q201 ERROR prediction: execute: execute: column reference "atom_id" is ambiguous LINE 2: ...CASE WHEN element = 'c' THEN 1 ELSE 0 END), COUNT(atom_id)) ... ^
q208 ERROR prediction: execute: execute: column c.label does not exist LINE 1: SELECT c.label, COUNT(*) ^ HINT: Perhaps you meant to reference the column "m.label".
q212 ERROR prediction: execute: execute: column "atom.element" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT element ^
q213 ERROR prediction: execute: execute: column "atom_id" does not exist LINE 8: AND (atom_id, atom_id2) IN ( ^
q219 ERROR prediction: execute: execute: column "label" does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN label = '+' AND bond_type = '#' ... ^
q226 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 2: ROUND(DIVIDE(SUM(bond_type = '='), COUNT(bond_id)), 5) *... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q227 ERROR prediction: execute: execute: column "label" does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN label = '+' THEN 1 ELSE 0 ... ^
q228 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN element = 'h' THEN 1 ELSE ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q231 ERROR prediction: statement: 2 statements in one text; an audit runs one
q245 ERROR prediction: execute: execute: column reference "bond_id" is ambiguous LINE 1: SELECT AVG(COUNT(bond_id)) AS average_bonds ^
q255 ERROR prediction: execute: execute: column "bond_type" does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN bond_type = '-' THEN 1 ELS... ^
q263 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: DIVIDE(SUM(CASE WHEN element = 'cl' AND bond_type = '-' ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q273 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: ...ASE WHEN element = 'cl' THEN 1 ELSE 0 END), COUNT(molecule_i... ^
q282 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: DIVIDE(SUM(CASE WHEN element = 'h' THEN 1 ELSE 0 END), C... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q11 ERROR prediction: execute: execute: column s.Enrollment (K-12) does not exist LINE 3: WHERE s."Enrollment (K-12)" + s."Enrollment (Ages 5-17)" > 5... ^
q17 ERROR prediction: execute: execute: column "s.cds" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT s.cds, s.cname, AVG(s.avgscrwrite) AS avg_score ^
q23 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q24 ERROR prediction: statement: the text does not parse: syntax error at or near "Meal"
q25 ERROR prediction: execute: execute: column s.rtype does not exist LINE 4: WHERE s.rtype = 'Riverside' AND ss.avgscrmath > 400; ^ HINT: Perhaps you meant to reference the column "ss.rtype".
q26 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q27 ERROR prediction: execute: execute: column s.phone does not exist LINE 1: SELECT s.sname, s.avgscrwrite, s.phone ^ HINT: Perhaps you meant to reference the column "sc.phone".
q28 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q31 ERROR prediction: statement: the text does not parse: syntax error at or near "Meal"
q32 ERROR prediction: statement: the text does not parse: syntax error at or near "("
q37 ERROR prediction: execute: execute: division by zero
q40 ERROR prediction: execute: execute: column "phone" does not exist LINE 1: SELECT phone ^
q45 ERROR prediction: execute: execute: column "s.sname" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT s.sname, AVG(s.avgscrwrite) AS avg_write_score ^
q48 ERROR prediction: execute: execute: division by zero
q50 ERROR prediction: statement: the text does not parse: LIMIT #,# syntax is not supported
q62 ERROR prediction: execute: execute: invalid input syntax for type numeric: "Free Meal Count (K-12)" LINE 5: AND 'Free Meal Count (K-12)' * 100.0 / 'Enrollment (K-12)' <... ^
q72 ERROR prediction: statement: the text does not parse: syntax error at or near "Year"
q77 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q79 ERROR run: row_counts: row_counts: relation "public.counties" does not exist LINE 1: SELECT count(*) FROM "public"."counties" ^
q83 ERROR prediction: statement: 2 statements in one text; an audit runs one
q85 ERROR prediction: statement: the text does not parse: syntax error at or near "Meal"
q92 ERROR prediction: execute: execute: column a.a11 does not exist LINE 5: WHERE c.gender = 'F' AND a.a11 > 6000 AND a.a11 < 10000; ^ HINT: Perhaps you meant to reference the column "d.a11".
q93 ERROR prediction: execute: execute: column "a11" does not exist LINE 9: AND a11 > 8000; ^
q94 ERROR prediction: statement: 2 statements in one text; an audit runs one
q95 ERROR prediction: execute: execute: column "a11" does not exist LINE 6: SELECT a11 ^
q99 ERROR prediction: execute: execute: operator does not exist: date ~~ unknown LINE 5: AND a.date LIKE '1993-%' ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q115 ERROR prediction: execute: execute: column "d.a4" must appear in the GROUP BY clause or be used in an aggregate function LINE 10: d.a4 DESC ^
q117 ERROR prediction: execute: execute: column "status" does not exist LINE 1: SELECT (SUM(CASE WHEN status = 'A' THEN amount ELSE 0 END) /... ^
q125 ERROR prediction: execute: execute: column l.client_id does not exist LINE 4: JOIN loan l ON c.client_id = l.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q128 ERROR prediction: execute: execute: missing FROM-clause entry for table "d" LINE 1: SELECT d.a2, COUNT(*) ^
q138 ERROR prediction: execute: execute: column "a15" does not exist LINE 8: WHERE a15 > 0 ^
q129 ERROR prediction: execute: execute: column a.client_id does not exist LINE 4: JOIN client c ON a.client_id = c.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q149 ERROR prediction: execute: execute: column "a2" does not exist LINE 1: SELECT DISTINCT a2 ^
q168 ERROR prediction: execute: execute: division by zero
q169 ERROR prediction: execute: execute: column account.client_id does not exist LINE 4: JOIN client ON account.client_id = client.client_id ^
q173 ERROR prediction: statement: 2 statements in one text; an audit runs one
q186 ERROR prediction: execute: execute: missing FROM-clause entry for table "client" LINE 1: SELECT (COUNT(CASE WHEN client.gender = 'M' AND account.freq... ^
q189 ERROR prediction: execute: execute: column "a11" does not exist LINE 5: ORDER BY c.birth_date, a11 ^
q194 ERROR prediction: execute: execute: function datediff(date, date) does not exist LINE 1: SELECT c.client_id, c.birth_date, DATEDIFF(CURRENT_DATE, c.b... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

A question whose statement could not be run wrote no directory, so it is a row here and has no page: the summary holds the side that stopped, the step it stopped at and the engine's own message.

The same index, restricted

Each of these is a page of its own, so a filtered view has an address a reader can send. Nothing here is done by a script or by a query string.

The JSON this page was rendered from