the run

audit-715e02b9-6229-4aab-aa2e-7df62f68e7a4 exit status 1

The whole of this run is a release asset

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

archive
minidev-pg-phi-3-medium-128k-instruct-1.tar.gz
size
1,439,407 bytes
sha256
597b69fd187cd4405c908c8568b65da5ccea0f1affb0d0ec53d501c662baae95

What it counted

whathow many
questions audited498
ERROR219
NOT_EQUAL179
EQUAL100
probes fired27
the verdicts of run audit-715e02b9-6229-4aab-aa2e-7df62f68e7a4, from summary.json219 ERROR10 multiplicity1 other1 type167 NOT_EQUAL100 EQUAL
Of the questions this run audited: 219 ERROR, 10 multiplicity, 1 other, 1 type, 167 NOT_EQUAL, 100 EQUAL

the probes

probefired on
ordering-over-numeric-text0
arbitrary-cut10
not-a-function-of-the-data13
float-aggregate-order4
direction-against-question0
how many golds each probe fired on, of 498, from summary.json0 ordering-over-numeric-text10 arbitrary-cut13 not-a-function-of-the-data4 float-aggregate-order0 direction-against-question
Of 498 golds this run read, the probes fired on: arbitrary-cut on 10; not-a-function-of-the-data on 13; float-aggregate-order on 4.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here11
multiplicity10
type1
order0
truncation0
other0
the test-suite check answered 11
the test-suite check answered 010

What the run was made of

run
audit-715e02b9-6229-4aab-aa2e-7df62f68e7a4
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_phi-3-medium-128k-instruct-1_postgresql.json sha256:8defb4399ab3393200cfba510024df7d9cf2cff8c9c7df647e3309cf751ac82d | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_phi-3-medium-128k-instruct-1_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:25:39.400422+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

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?
q206 R-SET NOT_EQUAL multiplicity What elements are in the TR004_8_9 bond atoms?
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"?
q736 R-ORD EQUAL arbitrary-cut not-a-function-of-the-data Who is the dumbest superhero?
q790 R-SET NOT_EQUAL type Calculate the difference between Emil Blonsky's weight and Charles Chandler's weight.
q850 R-SET NOT_EQUAL multiplicity Please give the name of the race held on the circuits in Germany.
q854 R-SET NOT_EQUAL multiplicity What is the coordinates location of the circuits for Australian grand prix?
q868 R-SET NOT_EQUAL multiplicity Where is Malaysian Grand Prix held? Give the location coordinates.
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?
q1435 R-SET NOT_EQUAL multiplicity List the names of closed event as "game" that was closed from 3/15/2019 to 3/20/2020.
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.
q1514 R-SET NOT_EQUAL multiplicity What kind of currency did the customer paid at 16:25:00 in 2012/8/24?
q1471 ERROR prediction: execute: execute: column "currency" does not exist LINE 2: ...T(DISTINCT customerid) FROM transactions_1k WHERE currency =... ^
q1480 ERROR prediction: execute: execute: function to_char(text, unknown) does not exist LINE 2: TO_CHAR(date, 'YYYY-MM') AS year_month, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1481 ERROR prediction: execute: execute: column "currency" does not exist LINE 2: ...onth WHERE date BETWEEN '201301' AND '201312' AND currency =... ^
q1482 ERROR prediction: statement: the text does not parse: syntax error at or near "UNION"
q1486 ERROR prediction: execute: execute: column "currency" does not exist LINE 2: ...T(DISTINCT customerid) FROM transactions_1k WHERE currency =... ^
q1490 ERROR prediction: execute: execute: column "segment" does not exist LINE 4: WHERE segment = 'LAM'; ^
q1528 ERROR prediction: execute: execute: column "country" does not exist LINE 2: ... (COUNT(*) FILTER (WHERE segment = 'premium' AND country = ... ^
q1533 ERROR prediction: execute: execute: division by zero
q1338 ERROR prediction: execute: execute: operator does not exist: text = boolean LINE 5: ...event.event_date = '2019-10-08' AND expense.approved = TRUE; ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1339 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 5: AND (EXTRACT(MONTH FROM expense.expense_date) = 9 OR EXTRACT... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1340 ERROR prediction: execute: execute: function year(text) does not exist LINE 2: (SELECT SUM(spent) FROM budget WHERE YEAR(link_to_event)... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1350 ERROR prediction: execute: execute: column expense.link_to_event does not exist LINE 3: JOIN expense ON event.event_id = expense.link_to_event ^
q1356 ERROR prediction: execute: execute: column m.department does not exist LINE 1: SELECT m.department ^
q1357 ERROR prediction: execute: execute: column "first_name" does not exist LINE 3: WHERE first_name = 'Connor' AND last_name = 'Hilton' AND sou... ^
q1359 ERROR prediction: execute: execute: column "event_name" does not exist LINE 4: (SUM(CASE WHEN event_name = 'Yearly Kickoff' THEN am... ^
q1387 ERROR prediction: execute: execute: column b.link_to_member does not exist LINE 3: JOIN budget b ON m.member_id = b.link_to_member ^
q1389 ERROR prediction: execute: execute: column expense.link_to_event does not exist LINE 3: JOIN event ON expense.link_to_event = event.event_id ^
q1390 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1401 ERROR prediction: execute: execute: column expense.link_to_event does not exist LINE 3: JOIN event ON expense.link_to_event = event.event_id ^
q1426 ERROR prediction: execute: execute: column m.department does not exist LINE 1: SELECT m.last_name, m.department, m.college ^ HINT: Perhaps you meant to reference the column "ma.department".
q1432 ERROR prediction: execute: execute: column expense.amount does not exist LINE 1: SELECT ROUND((COUNT(CASE WHEN expense.amount = 50 THEN 1 END... ^
q1149 ERROR prediction: statement: the text does not parse: syntax error at or near ";"
q1150 ERROR prediction: execute: execute: invalid input syntax for type date: "1930" LINE 1: SELECT ROUND((COUNT(CASE WHEN Birthday > '1930' AND Sex = 'F... ^
q1152 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 7: Patient ON Examination.PatientID = Patient.ID ^
q1153 ERROR prediction: execute: execute: column l.examination_id does not exist LINE 3: JOIN Examination e ON l.examination_id = e.id ^
q1155 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Laboratory l ON p.patient_id = l.patient_id ^
q1156 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
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: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1164 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1166 ERROR run: row_counts: row_counts: relation "public.diagnosis" does not exist LINE 1: SELECT count(*) FROM "public"."diagnosis" ^
q1168 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 4: JOIN Examination ON Patient.Patient_ID = Examination.Patient... ^
q1169 ERROR prediction: execute: execute: column "sex" does not exist LINE 2: (SELECT COUNT(*) FROM Examination WHERE SEX = 'M' AND UA... ^
q1171 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1175 ERROR run: row_counts: row_counts: relation "public.diagnosis" does not exist LINE 1: SELECT count(*) FROM "public"."diagnosis" ^
q1179 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1185 ERROR prediction: statement: the text does not parse: syntax error at or near "END"
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: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
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 examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1198 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1201 ERROR prediction: execute: execute: column "birthday" does not exist LINE 1: SELECT ROUND((COUNT(CASE WHEN YEAR(BIRTHDAY) = '1980' AND DI... ^
q1205 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 5: JOIN Examination e ON p.patient_id = e.patient_id ^
q1208 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.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 3: JOIN Examination e ON p.id = e.patient_id ^
q1227 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 5: JOIN Examination ON Patient.ID = Examination.patient_id ^
q1229 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1231 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1232 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1235 ERROR run: row_counts: row_counts: relation "public.diagnosis" does not exist LINE 1: SELECT count(*) FROM "public"."diagnosis" ^
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 examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.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 examination.patient_id does not exist LINE 3: JOIN Patient ON Examination.patient_id = Patient.id ^
q1247 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1251 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1252 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1254 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1255 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.Patient_ID = Examination.Patient... ^
q1256 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1257 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1265 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1267 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1270 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1275 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1281 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1302 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^
q1025 ERROR prediction: execute: execute: column league.league_id does not exist LINE 3: JOIN Match ON League.league_id = Match.league_id ^
q1028 ERROR prediction: execute: execute: column team.team_id does not exist LINE 3: JOIN Match ON Team.team_id = Match.away_team_api_id ^
q1029 ERROR prediction: execute: execute: column ta.team_id does not exist LINE 3: JOIN Team_Attributes ta ON t.id = ta.team_id ^
q1031 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1035 ERROR prediction: execute: execute: column "buildupplayspeed" does not exist LINE 3: WHERE buildUpPlaySpeed > 50 AND buildUpPlaySpeed < 60; ^
q1036 ERROR prediction: execute: execute: column team_attributes.team_id does not exist LINE 3: JOIN Team_Attributes ON Team.id = Team_Attributes.team_id ^
q1037 ERROR prediction: execute: execute: column "preferred_foot" does not exist LINE 2: ROUND((COUNT(CASE WHEN preferred_foot = 'left' AND YEAR(... ^
q1039 ERROR prediction: execute: execute: column "name" does not exist LINE 3: ...id = (SELECT player_fifa_api_id FROM Player WHERE name = 'Ah... ^ HINT: Perhaps you meant to reference the column "player_attributes.date".
q1040 ERROR prediction: execute: execute: column p.name does not exist LINE 1: SELECT p.name ^ HINT: Perhaps you meant to reference the column "pa.date".
q1042 ERROR prediction: execute: execute: column match.home_team_id does not exist LINE 5: SELECT Match.league_id, AVG(CASE WHEN Match.home_team_id... ^
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 player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.id ^
q1057 ERROR prediction: execute: execute: column "name" does not exist LINE 3: WHERE name = 'Poland' AND season = '2010/2011'; ^ HINT: Perhaps you meant to reference the column "match.date".
q1058 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1068 ERROR prediction: execute: execute: column t2.player_id does not exist LINE 3: JOIN Player t1 ON t1.id = t2.player_id ^
q1076 ERROR prediction: execute: execute: column "player_name" does not exist LINE 2: ...CT AVG(ball_control) FROM Player_Attributes WHERE player_nam... ^
q1078 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1079 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1080 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1084 ERROR prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_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 ^
q1092 ERROR prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT league_name ^
q1094 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q1096 ERROR prediction: execute: execute: column t1.player_id does not exist LINE 3: JOIN Player P ON T1.player_id = P.player_id ^
q1098 ERROR prediction: execute: execute: column "chancecreationpassing" does not exist LINE 1: SELECT MAX(chanceCreationPassing) AS highest_chance_creation... ^
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 "rating" does not exist LINE 1: SELECT AVG(rating) AS overall_rating ^ HINT: Perhaps you meant to reference the column "player_attributes.marking".
q1105 ERROR prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_id = pa.player_id ^
q1107 ERROR prediction: execute: execute: column m.player_id does not exist LINE 3: JOIN Player_Attributes pa ON m.player_id = pa.player_id ^
q1110 ERROR prediction: execute: execute: column m.team_id does not exist LINE 3: JOIN Team t ON m.team_id = t.team_id ^
q1113 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.player_id ^
q1114 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.player_i... ^
q1115 ERROR prediction: execute: execute: column "overall_rating" does not exist LINE 3: (SELECT overall_rating FROM Player WHERE player_name... ^
q1116 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
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 team_attributes.team_id does not exist LINE 3: JOIN Team_Attributes ON Team.id = Team_Attributes.team_id ^
q1134 ERROR prediction: execute: execute: argument of AND must be type boolean, not type bigint LINE 1: SELECT SUBTRACT(jumping AND id = 6, jumping AND id = 23) AS ... ^
q1135 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1136 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1139 ERROR prediction: execute: execute: column "match_date" does not exist LINE 3: WHERE match_date = '2008-09-24' ^
q1141 ERROR prediction: execute: execute: column team_attributes.team_id does not exist LINE 3: JOIN Team ON Team_Attributes.team_id = Team.team_id ^
q1144 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1147 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1148 ERROR prediction: execute: execute: column "overall_rating" does not exist LINE 1: ...CT ROUND((COUNT(*) FILTER (WHERE height < 180 AND overall_ra... ^
q866 ERROR prediction: execute: execute: column r.laptime does not exist LINE 5: WHERE ra.raceid = 161 AND r.lapTime LIKE '0:01:27%'; ^ HINT: Perhaps you meant to reference the column "r.time".
q879 ERROR prediction: execute: execute: column lt.resultid does not exist LINE 4: JOIN lapTimes lt ON r.resultid = lt.resultid ^ HINT: Perhaps you meant to reference the column "r.resultid".
q880 ERROR prediction: execute: execute: operator does not exist: text - text LINE 3: ... (SELECT fastestLapSpeed FROM results WHERE raceid = 853) - ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q881 ERROR prediction: execute: execute: column races.driverid does not exist LINE 2: (COUNT(DISTINCT races.driverid) FILTER (WHERE races.date... ^
q894 ERROR prediction: execute: execute: column laptimes.resultid does not exist LINE 3: JOIN results ON lapTimes.resultid = results.resultid ^
q896 ERROR prediction: execute: execute: column results.year does not exist LINE 8: drivers.surname = 'Hamilton' AND results.year >= 2010; ^
q898 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 1: SELECT drivers.forename, drivers.surname, (YEAR(CURRENT_TIME... ^ 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(races.date) = 9 AND YEAR(races.date) = 2005; ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q902 ERROR prediction: execute: execute: column races.driverid does not exist LINE 3: JOIN drivers ON races.driverid = drivers.driverid ^
q909 ERROR prediction: execute: execute: column "country" does not exist LINE 1: SELECT (COUNT(*) FILTER (WHERE country = 'Germany' AND name ... ^
q915 ERROR prediction: execute: execute: column "country" does not exist LINE 1: SELECT country ^
q933 ERROR prediction: execute: execute: column driverstandings.resultid does not exist LINE 4: JOIN results ON driverStandings.resultid = results.resultid ^
q944 ERROR prediction: execute: execute: operator does not exist: text - text LINE 2: ...aces WHERE name = '2008 Australian Grand Prix'))) - (SELECT ... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q951 ERROR prediction: execute: execute: column races.constructorid does not exist LINE 3: JOIN races ON constructors.constructorid = races.constructor... ^
q954 ERROR prediction: execute: execute: column reference "driverid" is ambiguous LINE 2: (COUNT(DISTINCT driverid) FILTER (WHERE nationality = 'J... ^
q955 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 3: AVG(EXTRACT(EPOCH FROM results.time)) AS avg_time_second... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
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: column reference "driverid" is ambiguous LINE 2: (COUNT(DISTINCT driverid) FILTER (WHERE dob < 1985 AND l... ^
q967 ERROR prediction: statement: 2 statements in one text; an audit runs one
q971 ERROR prediction: execute: execute: column drivers.name does not exist LINE 1: SELECT drivers.name ^
q972 ERROR prediction: execute: execute: column lt.resultid does not exist LINE 4: JOIN lapTimes lt ON r.resultid = lt.resultid ^ HINT: Perhaps you meant to reference the column "r.resultid".
q978 ERROR prediction: execute: execute: column "circuits.location" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT COUNT(*), circuits.location, circuits.lat, circuits.l... ^
q981 ERROR prediction: execute: execute: column races.driverid does not exist LINE 3: JOIN races ON drivers.driverid = races.driverid ^
q988 ERROR prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT drivers.forename, drivers.surname, AVG(pitStops.durat... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1002 ERROR prediction: execute: execute: column r.driverid does not exist LINE 3: JOIN races r ON d.driverid = r.driverid ^ HINT: Perhaps you meant to reference the column "d.driverid".
q1003 ERROR prediction: execute: execute: operator does not exist: text = integer LINE 5: WHERE s.status = 3 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q719 ERROR run: row_counts: row_counts: relation "public.power" does not exist LINE 1: SELECT count(*) FROM "public"."power" ^
q732 ERROR prediction: execute: execute: column "publisher_name" does not exist LINE 1: SELECT publisher_name ^
q738 ERROR prediction: execute: execute: column a.attribute_value does not exist LINE 5: WHERE a.attribute_name = 'Durability' AND a.attribute_value ... ^ HINT: Perhaps you meant to reference the column "ha.attribute_value".
q740 ERROR prediction: execute: execute: column attribute.attribute_value does not exist LINE 6: AND attribute.attribute_value = 100 ^ HINT: Perhaps you meant to reference the column "attribute.attribute_name".
q743 ERROR prediction: statement: the text does not parse: syntax error at or near "FILTER"
q758 ERROR prediction: execute: execute: column superhero.race does not exist LINE 7: AND superhero.race = 'human' ^
q760 ERROR prediction: statement: the text does not parse: syntax error at or near ")"
q761 ERROR prediction: execute: execute: function multiply(numeric, numeric) does not exist LINE 4: AND weight_kg > (SELECT MULTIPLY(AVG(weight_kg), 0.79) FROM ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q775 ERROR prediction: execute: execute: column "skin_colour_id" does not exist LINE 1: SELECT ROUND((COUNT(CASE WHEN skin_colour_id IN (SELECT id F... ^
q782 ERROR prediction: execute: execute: column hero_attribute.attribute_name does not exist LINE 5: WHERE colour.colour = 'Black' AND hero_attribute.attribute_n... ^ HINT: Perhaps you meant to reference the column "hero_attribute.attribute_value".
q788 ERROR prediction: execute: execute: column "gender" does not exist LINE 1: SELECT ROUND((COUNT(CASE WHEN gender = 'Female' AND publishe... ^
q796 ERROR prediction: execute: execute: missing FROM-clause entry for table "ah" LINE 1: SELECT ah.attribute_name, ha.attribute_value ^
q797 ERROR prediction: execute: execute: column superhero.hero_id does not exist LINE 10: AND superhero.hero_id IN ( ^
q800 ERROR prediction: execute: execute: function round(double precision, integer) does not exist LINE 1: SELECT ROUND((COUNT(*) FILTER (WHERE eye_colour_id = 7)::FLO... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q825 ERROR run: row_counts: row_counts: relation "public.power" does not exist LINE 1: SELECT count(*) FROM "public"."power" ^
q557 ERROR prediction: execute: execute: function round(double precision, integer) does not exist LINE 1: SELECT ROUND((COUNT(DISTINCT p.id) FILTER (WHERE p.score > 5... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q598 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 2: ((COUNT(CASE WHEN YEAR(badges.date) = 2010 THEN 1 END) *... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q629 ERROR prediction: execute: execute: function year(date) does not exist LINE 2: (SELECT COUNT(*) FROM votes WHERE YEAR(creationdate) = 2... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q637 ERROR prediction: execute: execute: column c.commentcount does not exist LINE 6: WHERE u.displayname = 'Mark Meckes' AND c.commentcount = 0; ^ HINT: Perhaps you meant to reference the column "p.commentcount".
q639 ERROR prediction: execute: execute: missing FROM-clause entry for table "tags" LINE 1: SELECT (COUNT(*) FILTER (WHERE tags.tagname = 'r')::FLOAT / ... ^
q665 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 6: WHERE YEAR(creationdate) = 2010 AND answercount <= 2 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q669 ERROR prediction: execute: execute: column reference "creationdate" is ambiguous LINE 1: SELECT MIN(creationdate) AS first_vote_date ^
q682 ERROR prediction: execute: execute: column p.creationdate does not exist LINE 4: WHERE EXTRACT(YEAR FROM p.creationdate) = 2010 ^ HINT: Perhaps you meant to reference the column "p.creaiondate" or the column "u.creationdate".
q683 ERROR prediction: execute: execute: column "creationdate" does not exist LINE 2: (COUNT(*) FILTER (WHERE YEAR(creationdate) = 2011 AND ow... ^
q716 ERROR prediction: statement: the text does not parse: syntax error at or near ")"
q371 ERROR prediction: execute: execute: column "language" does not exist LINE 1: SELECT (COUNT(*) FILTER (WHERE language = 'French' AND isSto... ^
q391 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 3: JOIN foreign_data ON cards.id = foreign_data.uuid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q402 ERROR prediction: execute: execute: column "isstorylight" does not exist LINE 2: (COUNT(*) FILTER (WHERE isStorylight = 1 AND isTextless ... ^
q409 ERROR prediction: execute: execute: column cards.format does not exist LINE 4: WHERE cards.format = 'premodern' ^
q415 ERROR prediction: execute: execute: column "format" does not exist LINE 1: SELECT ROUND((COUNT(CASE WHEN format = 'commander' AND statu... ^
q416 ERROR prediction: execute: execute: column "language" does not exist LINE 1: SELECT (COUNT(*) FILTER (WHERE language = 'French' AND (powe... ^
q427 ERROR prediction: execute: execute: column sets.setcode does not exist LINE 3: JOIN sets ON set_translations.setcode = sets.setcode ^ HINT: Perhaps you meant to reference the column "sets.code".
q440 ERROR prediction: execute: execute: column "name" does not exist LINE 1: SELECT language FROM set_translations WHERE name = 'A Pedra ... ^
q462 ERROR prediction: execute: execute: column "setcode" does not exist LINE 1: SELECT setcode FROM sets WHERE name = 'Ancestor''s Chosen'; ^ HINT: Perhaps you meant to reference the column "sets.code".
q474 ERROR prediction: execute: execute: column cards.basesetsize does not exist LINE 5: AND cards.baseSetSize < 100; ^
q486 ERROR prediction: execute: execute: missing FROM-clause entry for table "cards" LINE 1: SELECT (SUM(CASE WHEN cards.convertedmanacost = 7 AND cards.... ^
q487 ERROR prediction: execute: execute: division by zero
q518 ERROR prediction: execute: execute: column "cards.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT format, cards.name ^
q197 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 9: GROUP BY molecule_id; ^
q208 ERROR prediction: execute: execute: column a.label does not exist LINE 1: SELECT a.label ^ HINT: Perhaps you meant to reference the column "m.label".
q218 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 2: (COUNT(DISTINCT molecule_id) FILTER (WHERE label = '+') ... ^
q219 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 2: (COUNT(DISTINCT molecule_id) FILTER (WHERE label = '+') ... ^
q227 ERROR prediction: statement: the text does not parse: syntax error at or near ")"
q228 ERROR prediction: execute: execute: function round(double precision, integer) does not exist LINE 1: SELECT ROUND(SUM(CASE WHEN element = 'h' THEN 1 ELSE 0 END) ... ^ 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
q232 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: SELECT molecule_id ^
q236 ERROR prediction: execute: execute: missing FROM-clause entry for table "connected" LINE 3: ...ON b.molecule_id = a1.molecule_id AND b.bond_id = connected.... ^
q244 ERROR prediction: statement: the text does not parse: syntax error at or near "HAVING"
q282 ERROR prediction: execute: execute: function round(double precision, integer) does not exist LINE 2: ROUND(CAST(SUM(CASE WHEN element = 'h' THEN 1 ELSE 0 END... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q327 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: SELECT molecule_id ^
q11 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q12 ERROR prediction: execute: execute: column frpm.percent_eligible_free_ages_5_17 does not exist LINE 1: SELECT MAX(frpm.Percent_Eligible_Free_Ages_5_17) AS Highest_... ^
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 "%"
q26 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q27 ERROR prediction: execute: execute: column s.openedate does not exist LINE 4: WHERE s.openedate > '1991-01-01' AND (s.closeddate < '2000-0... ^ HINT: Perhaps you meant to reference the column "s.opendate".
q28 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q31 ERROR prediction: execute: execute: column frpm.free_meal_count_k12 does not exist LINE 1: SELECT s.school, (frpm.Free_Meal_Count_K12 / frpm.Enrollment... ^
q32 ERROR prediction: execute: execute: column frpm.frpm_count_k12 does not exist LINE 1: SELECT s.school, (frpm.FRPM_Count_K12 / frpm.Enrollment_K12)... ^
q46 ERROR prediction: execute: execute: column "k" does not exist LINE 1: ..., s.county, s.district, s.city, s.state, f.Enrollment (K-12) ^
q48 ERROR prediction: execute: execute: division by zero
q62 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q72 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q77 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q83 ERROR prediction: execute: execute: column f.nslp_provision_status does not exist LINE 4: COUNT(DISTINCT CASE WHEN f.NSLP_Provision_Status = 'Mult... ^
q85 ERROR prediction: statement: the text does not parse: syntax error at or near "Meal"
q92 ERROR prediction: execute: execute: column reference "district_id" is ambiguous LINE 1: SELECT COUNT(DISTINCT district_id) ^
q93 ERROR prediction: execute: execute: column client.a11 does not exist LINE 6: AND client.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 4: SELECT client_id, AVG(a11) AS avg_salary ^
q115 ERROR prediction: execute: execute: function round(double precision, integer) does not exist LINE 2: ROUND((COUNT(CASE WHEN gender = 'M' THEN 1 END)::FLOAT /... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q116 ERROR prediction: statement: the text does not parse: syntax error at or near ")"
q137 ERROR prediction: execute: execute: column "status" does not exist LINE 3: WHERE district_id = 1 AND status = 'C'; ^
q129 ERROR prediction: execute: execute: operator does not exist: date ~~ unknown LINE 6: AND t.date LIKE '1996-01%' ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q149 ERROR prediction: execute: execute: column account.type does not exist LINE 1: SELECT account.account_id, account.type ^
q173 ERROR prediction: statement: 2 statements in one text; an audit runs one
q186 ERROR prediction: execute: execute: column "frequency" does not exist LINE 2: (COUNT(CASE WHEN gender = 'M' AND frequency = 'POPLATEK ... ^
q189 ERROR prediction: execute: execute: column "a11" does not exist LINE 5: ORDER BY client.birth_date ASC, a11 ASC ^

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