the run

audit-a7e6b760-f8ad-479a-b956-9cd88ea91e18 exit status 1

The whole of this run is a release asset

This site holds 26 of the 204 question directories this run wrote; the archive holds every one:

archive
minidev-pg-gpt-35-turbo.tar.gz
size
1,680,811 bytes
sha256
415c9f9dbf7b77ee76b4669bf38edeecf6097ed16c0a4bac2b73b3cff192fdff

What it counted

whathow many
questions audited498
NOT_EQUAL197
ERROR185
EQUAL116
probes fired27
the verdicts of run audit-a7e6b760-f8ad-479a-b956-9cd88ea91e18, from summary.json19 multiplicity3 type1 other174 NOT_EQUAL185 ERROR116 EQUAL
Of the questions this run audited: 19 multiplicity, 3 type, 1 other, 174 NOT_EQUAL, 185 ERROR, 116 EQUAL

the probes

probefired on
ordering-over-numeric-text2
arbitrary-cut11
not-a-function-of-the-data11
float-aggregate-order3
direction-against-question0
how many golds each probe fired on, of 498, from summary.json2 ordering-over-numeric-text11 arbitrary-cut11 not-a-function-of-the-data3 float-aggregate-order0 direction-against-question
Of 498 golds this run read, the probes fired on: ordering-over-numeric-text on 2; arbitrary-cut on 11; not-a-function-of-the-data on 11; float-aggregate-order on 3.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here23
multiplicity20
type3
order0
truncation0
other0
the test-suite check answered 13
the test-suite check answered 020

What the run was made of

run
audit-a7e6b760-f8ad-479a-b956-9cd88ea91e18
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_gpt-35-turbo_postgresql.json sha256:fa363fe3c3fc45d97cb47e6ec15133b291acccd750e5136b6e7b4d1c8d13a4be | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_gpt-35-turbo_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:21:06.155844+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?
q149 R-SET NOT_EQUAL multiplicity Please list the account types that are not eligible for loans, and the average income of residents in the district where the account is located exceeds $8000 but is no more than $9000.
q206 R-SET NOT_EQUAL multiplicity What elements are in the TR004_8_9 bond atoms?
q240 R-SET NOT_EQUAL multiplicity List all the elements of the toxicology of the molecule "TR004".
q281 R-SET NOT_EQUAL multiplicity Tally the toxicology element of the 4th atom of each molecule that was carcinogenic.
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"?
q391 R-SET NOT_EQUAL multiplicity Among the Artifact cards, which are black color and comes with foreign languague translation?
q462 R-SET NOT_EQUAL multiplicity What's the Italian name of the set of cards with "Ancestor's Chosen" is in?
q477 R-SET NOT_EQUAL multiplicity Which of these artists have designed a card in the set Coldsnap, Jeremy Jarvis, Aaron Miller or Chippy?
q483 R-SET NOT_EQUAL multiplicity Please list the Italian text ruling of all the cards in the set Coldsnap.
q528 R-SET NOT_EQUAL multiplicity List the names of all the cards in the set Hour of Devastation and find the formats in which these cards are legal.
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.
q854 R-SET NOT_EQUAL multiplicity What is the coordinates location of the circuits for Australian grand prix?
q857 R-SET NOT_EQUAL multiplicity Give the coordinate position for Abu Dhabi Grand Prix.
q879 R-ORD EQUAL ordering-over-numeric-text For the driver who set the fastest lap speed, what is his nationality?
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.
q1134 R-SET NOT_EQUAL type What is the difference between players 6 and 23's jumping scores?
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?
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.
q1501 R-SET NOT_EQUAL multiplicity Please list the countries of the gas stations with transactions taken place in June, 2013.
q1506 R-SET NOT_EQUAL multiplicity Please list the product descriptions of the transactions taken place in the gas stations in the Czech Republic.
q1507 R-SET NOT_EQUAL multiplicity Please list the disparate time of the transactions taken place in the gas stations from chain no. 11.
q1472 ERROR prediction: execute: execute: column "segment" does not exist LINE 4: AND segment = 'LAM' ^
q1476 ERROR prediction: execute: execute: column "currency" does not exist LINE 2: SUM(CASE WHEN currency = 'CZK' THEN consumption ELSE 0 E... ^
q1479 ERROR prediction: execute: execute: function substring(date, integer, integer) does not exist LINE 2: SUBSTRING(date, 1, 4) AS year, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1480 ERROR prediction: execute: execute: column "segment" does not exist LINE 6: WHERE segment = 'SME' AND SUBSTRING(date, 1, 4) = '2013' ^
q1481 ERROR prediction: execute: execute: column "currency" does not exist LINE 5: AND currency = 'CZK' ^
q1482 ERROR prediction: execute: execute: column "segment" does not exist LINE 1: SELECT segment, ^
q1483 ERROR prediction: execute: execute: column "yearmonth.customerid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT customerid, SUM(consumption) AS total_consumption ^
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 1: SELECT ((COUNT(*) FILTER (WHERE segment = 'LAM' AND consumpt... ^
q1524 ERROR prediction: execute: execute: column customers.country does not exist LINE 1: SELECT customers.country ^
q1525 ERROR prediction: execute: execute: column reference "customerid" is ambiguous LINE 2: COUNT(DISTINCT customerid) / (SELECT COUNT(DISTINCT cust... ^
q1526 ERROR prediction: execute: execute: column "consumption_2012" does not exist LINE 2: (consumption_2012 - consumption_2013) / consumption_2... ^
q1529 ERROR prediction: execute: execute: operator does not exist: date ~~ unknown LINE 3: SUM(CASE WHEN date LIKE '201201%' THEN t.amount * t.pric... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1531 ERROR prediction: execute: execute: division by zero
q1317 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q1339 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 6: 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 pg_catalog.extract(unknown, text) does not exist LINE 1: SELECT SUM(CASE WHEN EXTRACT(YEAR FROM event_date) = 2019 TH... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1359 ERROR prediction: execute: execute: column "event_name" does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN event_name = 'Yearly Kickoff' AN... ^
q1371 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q1389 ERROR prediction: execute: execute: column "link_to_event" does not exist LINE 4: SELECT link_to_event ^
q1390 ERROR prediction: execute: execute: function divide(real, real) does not exist LINE 1: SELECT DIVIDE(SUM(cost), (SELECT SUM(cost) FROM event)) * 10... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1399 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q1401 ERROR prediction: execute: execute: column e.link_to_event does not exist LINE 3: JOIN event ev ON e.link_to_event = ev.event_id ^
q1404 ERROR prediction: execute: execute: column expense.link_to_event does not exist LINE 3: JOIN event ON expense.link_to_event = event.event_id ^
q1432 ERROR prediction: execute: execute: column "amount" does not exist LINE 1: SELECT DIVIDE(COUNT(amount = 50), COUNT(member_id)) * 100 ^
q1149 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q1150 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q1152 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: DIVIDE( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1153 ERROR prediction: execute: execute: column patient.disease does not exist LINE 1: SELECT Patient.disease ^
q1155 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
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 examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.patient_ID ^
q1162 ERROR prediction: execute: execute: function year(date) does not exist LINE 3: WHERE sex = 'F' AND year(Description) = '1997' AND Admission... ^ 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.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1166 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1168 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1169 ERROR prediction: execute: execute: column "ua" does not exist LINE 2: ...(SELECT COUNT(*) FROM Patient WHERE SEX = 'M' AND UA <= 8.0)... ^
q1171 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1175 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
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 "ELSE"
q1187 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1189 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1192 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1195 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1198 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1201 ERROR prediction: execute: execute: function year(date) does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN YEAR(BIRTHDAY) = '1980' AND Diag... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1205 ERROR prediction: execute: execute: column patient.patient_number does not exist LINE 3: JOIN Examination ON Patient.patient_number = Examination.pat... ^
q1208 ERROR prediction: statement: the text does not parse: syntax error at or near "="
q1209 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1220 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.patientID ^
q1225 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.patient_ID ^
q1227 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 6: JOIN Examination ON Patient.ID = Examination.patient_ID ^
q1229 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1231 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1232 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1235 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 6: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1238 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.patient_ID ^
q1239 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1241 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 5: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1242 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1243 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 7: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
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 examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^
q1252 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1254 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1255 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1256 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1257 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1265 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1267 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1270 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1275 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^
q1281 ERROR prediction: execute: execute: column "patient_id" does not exist LINE 4: (SELECT patient_id ^
q1302 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1025 ERROR prediction: execute: execute: column "league" does not exist LINE 1: SELECT League ^ HINT: Perhaps you meant to reference the column "match.league_id" or the column "match.stage".
q1029 ERROR prediction: execute: execute: column team.team_id does not exist LINE 3: JOIN Team_Attributes ON Team.team_id = Team_Attributes.team_... ^
q1030 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 6: ORDER BY MAX(SUM(CASE WHEN home_team_goal = away_team_goal T... ^
q1031 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1036 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 5: AND strftime('%Y', Team_Attributes.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: column "preferred_foot" does not exist LINE 1: SELECT DIVIDE(MULTIPLY((SUM(CASE WHEN preferred_foot = 'left... ^
q1039 ERROR prediction: execute: execute: function divide(numeric, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(long_shots), COUNT(player_fifa_api_id)) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1040 ERROR prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^
q1044 ERROR prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^
q1048 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.player_i... ^
q1058 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1068 ERROR prediction: execute: execute: column t1.player_id does not exist LINE 3: JOIN Player t2 ON t1.player_id = t2.id ^
q1076 ERROR prediction: execute: execute: column "player_name" does not exist LINE 2: (SUM(CASE WHEN player_name = 'Abdou Diallo' THEN ball_contro... ^
q1078 ERROR prediction: execute: execute: column "birthday_of_aaron_lennon" does not exist LINE 3: WHEN birthday_of_Aaron_Lennon > birthday_of_Abdelazi... ^
q1079 ERROR prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^
q1080 ERROR prediction: execute: execute: column "preferred_foot" does not exist LINE 3: WHERE preferred_foot = 'left' AND attacking_work_rate = 'low... ^
q1084 ERROR prediction: execute: execute: column player.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.player_id = Player_Attribut... ^
q1088 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1091 ERROR prediction: execute: execute: function date_part(unknown, text) does not exist LINE 3: WHERE date_part('month', date) = 4 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1092 ERROR prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT league_name ^
q1094 ERROR prediction: execute: execute: column player1.player_name does not exist LINE 3: JOIN Player_Attributes player2 ON player1.player_name = 'Ari... ^
q1096 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Pietro Marino' ^
q1098 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 4: WHERE team_long_name = 'Ajax' ^
q1102 ERROR prediction: execute: execute: column player.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.player_id = Player_Attribut... ^
q1103 ERROR prediction: execute: execute: column player.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.player_id = Player_Attribut... ^
q1105 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.player_i... ^
q1107 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Kevin Constant' ^
q1110 ERROR prediction: execute: execute: column team_attributes.team_id does not exist LINE 3: JOIN Team ON Team_Attributes.team_id = Team.team_id ^
q1113 ERROR prediction: execute: execute: column team_attributes.team_id does not exist LINE 3: JOIN Team ON Team_Attributes.team_id = Team.team_id ^
q1114 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Marko Arnautovic' ^
q1115 ERROR prediction: execute: execute: column "player_name" does not exist LINE 1: ...ELECT overall_rating FROM Player_Attributes WHERE player_nam... ^
q1116 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1122 ERROR prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^
q1124 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1130 ERROR prediction: execute: execute: column team.team_id does not exist LINE 3: JOIN Team_Attributes ON Team.team_id = Team_Attributes.team_... ^
q1135 ERROR prediction: execute: execute: column player.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.player_id = Player_Attribut... ^
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 player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.player_i... ^
q1147 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.id = Player_Attributes.play... ^
q1148 ERROR prediction: execute: execute: column "overall_rating" does not exist LINE 1: SELECT (DIVIDE(COUNT(height < 180 AND overall_rating > 70),C... ^
q847 ERROR prediction: execute: execute: missing FROM-clause entry for table "drivers" LINE 1: SELECT drivers.surname ^
q880 ERROR prediction: execute: execute: function fastestlapspeed(integer) does not exist LINE 1: SELECT ROUND((fastestlapspeed(853) - fastestlapspeed(854)) *... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q884 ERROR prediction: execute: execute: function year(date) does not exist LINE 3: WHERE year = (SELECT year(min(date)) FROM races) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q896 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q897 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: ...rename, drivers.surname, drivers.nationality, MAX(COUNT(resu... ^
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.
q909 ERROR prediction: execute: execute: column "country" does not exist LINE 1: SELECT ROUND((COUNT(races) FILTER (WHERE country = 'Germany'... ^
q954 ERROR prediction: execute: execute: division by zero
q955 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 1: SELECT races.year, AVG(EXTRACT(EPOCH FROM results.time)) AS ... ^ 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: statement: the text does not parse: syntax error at or near "WHERE"
q963 ERROR prediction: execute: execute: column laptimes.laptime does not exist LINE 4: WHERE drivers.nationality = 'French' AND lapTimes.laptime < ... ^ HINT: Perhaps you meant to reference the column "laptimes.time".
q972 ERROR prediction: execute: execute: column reference "driverid" is ambiguous LINE 2: driverid, code ^
q988 ERROR prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT drivers.forename, drivers.surname, MIN(avg(pitStops.d... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q772 ERROR prediction: execute: execute: table name "colour" specified more than once
q800 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
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".
q629 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q634 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT MAX(SUM(viewcount)) AS popularity ^
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 "creationdate" does not exist LINE 5: ...favoritecount) FROM posts WHERE EXTRACT(YEAR FROM creationda... ^ HINT: Perhaps you meant to reference the column "posts.creaiondate" or the column "posts.creaiondate".
q683 ERROR prediction: execute: execute: column "creationdate" does not exist LINE 1: ... DIVIDE(COUNT(id) FILTER (WHERE EXTRACT(YEAR FROM creationda... ^ HINT: Perhaps you meant to reference the column "posts.creaiondate".
q701 ERROR prediction: execute: execute: argument of AND must be type boolean, not type bigint LINE 3: COUNT(posts.id) FILTER (WHERE posts.score > 50) AND ... ^
q716 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q352 ERROR prediction: statement: the text does not parse: syntax error at or near "AS"
q371 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q415 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: (DIVIDE(COUNT(cards.id), COUNT(cards.id)) * 100) AS percenta... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q416 ERROR prediction: execute: execute: column "language" does not exist LINE 1: SELECT ROUND((COUNT(*) FILTER (WHERE language = 'French' AND... ^
q424 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(COUNT(CASE WHEN istextless = 1 AND layout = 'n... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q427 ERROR prediction: execute: execute: column "mcmname" does not exist LINE 3: WHERE setcode = 'ARC' AND mcmname = 'Archenemy' ^
q459 ERROR prediction: execute: execute: more than one row returned by a subquery used as an expression
q486 ERROR prediction: execute: execute: function divide(bigint, real) does not exist LINE 2: DIVIDE(SUM(CASE WHEN cards.convertedmanacost = 7 THEN 1 ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q487 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 2: (DIVIDE(SUM(cards.cardkingdomfoilid IS NOT NULL AND cards.ca... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q200 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q201 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN a.element = 'c' THEN 1 ELSE 0 EN... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q208 ERROR prediction: execute: execute: column "label" does not exist LINE 1: SELECT label, COUNT(label) ^
q218 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: SELECT DIVIDE(COUNT(DISTINCT molecule_id) - COUNT(DISTINCT m... ^
q219 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q226 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN bond_type = '=' THEN 1 ELSE 0 EN... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q227 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN label = '+' THEN 1 ELSE 0 END), ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q228 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(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.
q245 ERROR prediction: execute: execute: column "bond_id" does not exist LINE 1: SELECT AVG(COUNT(bond_id) / COUNT(atom_id)) ^
q248 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q253 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q255 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN bond.bond_type = '-' AND molecul... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q260 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q263 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: DIVIDE(SUM(CASE WHEN a.element = 'cl' THEN 1 ELSE 0 END)... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q273 ERROR prediction: execute: execute: column "element" does not exist LINE 1: SELECT DIVIDE(SUM(CASE WHEN element = 'cl' THEN 1 ELSE 0 END... ^
q282 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: SELECT molecule_id, ^
q12 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q23 ERROR prediction: execute: execute: column schools.Enrollment (K-12) does not exist LINE 3: WHERE (schools."Enrollment (K-12)" - schools."Enrollment (Ag... ^
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.phone does not exist LINE 1: SELECT s.sname, s.avgscrwrite, s.phone ^ HINT: Perhaps you meant to reference the column "sc.phone".
q31 ERROR prediction: execute: execute: column s.enrollment does not exist LINE 2: s.enrollment, ^
q32 ERROR prediction: execute: execute: column s.FRPM Count (K-12) does not exist LINE 2: (s."FRPM Count (K-12)" / s."Enrollment (K-12)") AS "E... ^ HINT: Perhaps you meant to reference the column "f.FRPM Count (K-12)".
q46 ERROR prediction: execute: execute: column schools.enrollment does not exist LINE 1: SELECT schools.school, schools.enrollment ^
q77 ERROR prediction: execute: execute: column frpm.Percent (%) Eligible FRPM (Ages 5-17 does not exist LINE 1: SELECT schools.school, frpm."Percent (%) Eligible FRPM (Ages... ^ HINT: Perhaps you meant to reference the column "frpm.Percent (%) Eligible FRPM (Ages 5-17)".
q83 ERROR prediction: execute: execute: column "schools.school" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT schools.school, schools.city, COUNT(schools.school) A... ^
q87 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q92 ERROR prediction: execute: execute: column reference "district_id" is ambiguous LINE 1: SELECT COUNT(district_id) ^
q94 ERROR prediction: execute: execute: column account.client_id does not exist LINE 3: JOIN account ON client.client_id = account.client_id ^
q95 ERROR prediction: execute: execute: column account.client_id does not exist LINE 3: JOIN account ON client.client_id = account.client_id ^
q98 ERROR prediction: execute: execute: column "frequency" does not exist LINE 9: AND frequency = 'POPLATEK TYDNE' ^
q99 ERROR prediction: execute: execute: column reference "account_id" is ambiguous LINE 1: SELECT account_id, MAX(amount) AS highest_approved_amount ^
q100 ERROR prediction: execute: execute: column account.client_id does not exist LINE 4: JOIN account ON client.client_id = account.client_id ^
q112 ERROR prediction: execute: execute: column a.client_id does not exist LINE 3: JOIN account a ON c.client_id = a.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q129 ERROR prediction: execute: execute: operator does not exist: date ~~ unknown LINE 5: WHERE t.type = 'VYDAJ' AND t.date LIKE '1996-01%' ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q169 ERROR prediction: execute: execute: column a.client_id does not exist LINE 5: JOIN client c ON a.client_id = c.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q189 ERROR prediction: execute: execute: column account.client_id does not exist LINE 3: JOIN account ON client.client_id = account.client_id ^

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