the run

audit-caa3d3fc-17d4-4f05-9ebf-50f46afc1202 exit status 1

The whole of this run is a release asset

This site holds 16 of the 113 question directories this run wrote; the archive holds every one:

archive
minidev-pg-mistralai-mixtral-8x7b-instru-4.tar.gz
size
3,707,260 bytes
sha256
af5a6786203547aa70c6524e464e24d94c366a698a76da669b616c5107952ce1

What it counted

whathow many
questions audited498
NOT_EQUAL111
ERROR328
EQUAL59
probes fired8
the verdicts of run audit-caa3d3fc-17d4-4f05-9ebf-50f46afc1202, from summary.json11 multiplicity3 type97 NOT_EQUAL328 ERROR59 EQUAL
Of the questions this run audited: 11 multiplicity, 3 type, 97 NOT_EQUAL, 328 ERROR, 59 EQUAL

the probes

probefired on
ordering-over-numeric-text1
arbitrary-cut2
not-a-function-of-the-data3
float-aggregate-order2
direction-against-question0
how many golds each probe fired on, of 498, from summary.json1 ordering-over-numeric-text2 arbitrary-cut3 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 2; not-a-function-of-the-data on 3; float-aggregate-order on 2.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here14
multiplicity11
type3
order0
truncation0
other0
the test-suite check answered 13
the test-suite check answered 011

What the run was made of

run
audit-caa3d3fc-17d4-4f05-9ebf-50f46afc1202
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_mistralai-mixtral-8x7b-instru-4_postgresql.json sha256:862dffc4cdca4875650841a456b698e515e978125f5b28f798022e88176562cb | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_mistralai-mixtral-8x7b-instru-4_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:24:33.608370+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
q200 R-SET NOT_EQUAL multiplicity Find the triple-bonded molecules which are carcinogenic.
q206 R-SET NOT_EQUAL multiplicity What elements are in the TR004_8_9 bond atoms?
q230 R-SET NOT_EQUAL multiplicity What are the elements of the toxicology and label of molecule TR060?
q268 R-SET NOT_EQUAL multiplicity What are the elements for bond id TR001_10_11?
q371 R-SET NOT_EQUAL type What is the percentage of cards whose language is French among the Story Spotlight cards?
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.
q868 R-SET NOT_EQUAL multiplicity Where is Malaysian Grand Prix held? Give the location coordinates.
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.
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 3: WHERE date BETWEEN '201201' AND '201212' AND segment = 'LAM' ^
q1473 ERROR prediction: execute: execute: column "segment" does not exist LINE 3: WHERE date BETWEEN '201301' AND '201312' AND segment = 'SME'... ^
q1476 ERROR prediction: execute: execute: column reference "customerid" is ambiguous LINE 5: customerid, ^
q1479 ERROR prediction: execute: execute: column "currency" does not exist LINE 6: WHERE currency = 'CZK' ^
q1481 ERROR prediction: execute: execute: column "currency" does not exist LINE 6: ...tomerid FROM customers WHERE segment = 'SME') AND currency =... ^
q1486 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1490 ERROR prediction: execute: execute: column "segment" does not exist LINE 10: segment = 'LAM' ^
q1498 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1500 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1505 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1528 ERROR prediction: execute: execute: operator does not exist: date = text LINE 11: ...armonth y ON t.customerid = y.customerid AND t.date = y.date ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1529 ERROR prediction: statement: 2 statements in one text; an audit runs one
q1531 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1533 ERROR prediction: execute: execute: division by zero
q1317 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1322 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1323 ERROR prediction: execute: execute: window functions are not allowed in WHERE LINE 5: COUNT(a.link_to_member) OVER (PARTITION BY a.link_to_event) ... ^
q1334 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1338 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 ^
q1339 ERROR prediction: execute: execute: operator does not exist: text = integer LINE 4: ..._name = 'Allen' AND SUBSTRING(expense_date, 4, 2) IN (9, 10)... ^ HINT: No operator 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 2: SUM(CASE WHEN EXTRACT(YEAR FROM event_date) = 2019 THEN spen... ^ 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 ^
q1359 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1371 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q1375 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1376 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1381 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1387 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1389 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1390 ERROR prediction: execute: execute: column "event_name" does not exist LINE 2: ROUND(DIVIDE(SUM(cost) FILTER (WHERE event_name = 'Yearly Ki... ^
q1398 ERROR prediction: execute: execute: column "event_name" does not exist LINE 1: SELECT event_name ^
q1399 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1401 ERROR prediction: execute: execute: column "link_to_event" does not exist LINE 3: WHERE expense_description = 'Posters' AND link_to_event = ( ^
q1410 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1422 ERROR prediction: execute: execute: column "event_location" does not exist LINE 3: WHERE event_location = 'MU 215'; ^
q1426 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1427 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 4: JOIN zip_code z ON e.location = z.zip_code ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1432 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q1457 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1460 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1464 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1149 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 16: JOIN examination e ON s.id = e.patient_id; ^
q1150 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q1152 ERROR prediction: execute: execute: column "admission" does not exist LINE 3: COUNT(ID) FILTER (WHERE Diagnosis = 'SLE' AND Admission = '-... ^
q1153 ERROR prediction: execute: execute: column laboratory.examinationid does not exist LINE 3: JOIN Examination ON Laboratory.ExaminationID = Examination.E... ^
q1155 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1156 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1157 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1162 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1164 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1166 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1168 ERROR prediction: execute: execute: column p.patientid does not exist LINE 2: JOIN Examination e ON p.PatientID = e.PatientID ^
q1169 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1171 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1175 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1179 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1185 ERROR prediction: execute: execute: column "date" does not exist LINE 2: EXTRACT(YEAR FROM Date) AS Year, ^
q1187 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1189 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1192 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1195 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.PatientID ^
q1198 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1201 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1205 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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: statement: the text does not parse: syntax error at or near "\"
q1220 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1225 ERROR prediction: statement: the text does not parse: cannot use DISTINCT with WITHIN GROUP
q1227 ERROR prediction: execute: execute: column "t_cho" does not exist LINE 5: WHERE sex = 'M' AND T_CHO >= 250 ^
q1229 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1231 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1232 ERROR prediction: statement: the text does not parse: syntax error at or near ")"
q1235 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q1238 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1239 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1241 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1242 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1243 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1247 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1251 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1252 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1254 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1255 ERROR prediction: execute: execute: column laboratory.examinationid does not exist LINE 5: JOIN Examination ON Laboratory.ExaminationID = Examinati... ^
q1256 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'+'' AND l.Description IS NULL;"
q1257 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1265 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1267 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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: statement: the text does not parse: syntax error at or near "\"
q1302 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1025 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1028 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1029 ERROR prediction: execute: execute: column player_attributes.teamid does not exist LINE 3: JOIN Player_Attributes ON Team.id = Player_Attributes.teamId ^
q1030 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".
q1031 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1032 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1035 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1036 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 1: SELECT team_long_name ^
q1037 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1039 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1040 ERROR prediction: execute: execute: column p.name does not exist LINE 2: P.name, ^ HINT: Perhaps you meant to reference the column "pa.date".
q1048 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Gabriel Tamas' AND strftime('%Y', year)... ^
q1057 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1058 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1068 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1076 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1078 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q1079 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q1080 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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: statement: the text does not parse: syntax error at or near "\"
q1091 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1092 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1094 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: ...ELECT overall_rating FROM Player_Attributes WHERE player_nam... ^
q1096 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1098 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1102 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1103 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Aaron Mooy' AND date LIKE '2016-02-04%'... ^
q1105 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1107 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1110 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1113 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1114 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Marko Arnautovic' AND ^
q1115 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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: statement: the text does not parse: syntax error at or near "\"
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 Player_Attributes ON Team.team_id = Player_Attributes.t... ^
q1133 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1134 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1135 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1136 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1139 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1141 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1144 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1145 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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: statement: the text does not parse: syntax error at or near "```"
q861 ERROR prediction: execute: execute: column reference "number" is ambiguous LINE 1: SELECT number ^
q862 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q875 ERROR prediction: execute: execute: column reference "url" is ambiguous LINE 1: SELECT url ^
q880 ERROR prediction: statement: the text does not parse: syntax error at end of input
q881 ERROR prediction: execute: execute: column reference "driverid" is ambiguous LINE 2: driverid, ^
q892 ERROR prediction: execute: execute: column "drivers.forename" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: drivers.forename, ^
q895 ERROR prediction: execute: execute: column laptimes.resultid does not exist LINE 4: JOIN lapTimes ON results.resultid = lapTimes.resultid ^
q896 ERROR prediction: execute: execute: column r.position does not exist LINE 2: ....raceid) FILTER (WHERE d.surname = 'Hamilton' AND r.position... ^ HINT: Perhaps you meant to reference the column "res.position".
q897 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q898 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 1: SELECT d.driverid, d.forename, d.surname, YEAR(CURRENT_TIMES... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q901 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q902 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q904 ERROR prediction: execute: execute: column r.name does not exist LINE 1: SELECT r.name, r.year ^ HINT: Perhaps you meant to reference the column "r.time".
q906 ERROR prediction: execute: execute: column r.name does not exist LINE 1: SELECT r.name, r.points ^ HINT: Perhaps you meant to reference the column "r.time".
q909 ERROR prediction: execute: execute: column races.country does not exist LINE 2: 100.0 * COUNT(races.raceid) FILTER (WHERE races.country = 'G... ^
q912 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q928 ERROR prediction: execute: execute: column results.year does not exist LINE 5: WHERE races.name = 'Canadian Grand Prix' AND results.year = ... ^
q930 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q933 ERROR prediction: statement: the text does not parse: syntax error at end of input
q940 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q944 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q945 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q954 ERROR prediction: execute: execute: column r.driverid does not exist LINE 2: 100.0 * COUNT(DISTINCT r.driverid) FILTER (WHERE r.time ... ^
q955 ERROR prediction: statement: the text does not parse: syntax error at or near "TIME_TO_SEC"
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 4: SELECT driverid ^
q972 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q981 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q988 ERROR prediction: execute: execute: column pitstops.resultid does not exist LINE 8: pitStops ON results.resultid = pitStops.resultid ^
q989 ERROR prediction: execute: execute: column r.name does not exist LINE 1: SELECT r.name, r.date, d.forename, d.surname, rr.time ^ HINT: Perhaps you meant to reference the column "r.time" or the column "rce.name".
q990 ERROR prediction: execute: execute: column cr.resultid does not exist LINE 6: JOIN results res ON cr.resultid = res.resultid ^ HINT: Perhaps you meant to reference the column "res.resultid".
q717 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q994 ERROR prediction: execute: execute: column reference "constructorid" is ambiguous LINE 1: SELECT constructorid, SUM(points) as total_points, name, nat... ^
q1001 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1002 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q1003 ERROR prediction: execute: execute: missing FROM-clause entry for table "races" LINE 6: WHERE status.status = '3' AND races.name = 'Canadian Gra... ^
q1011 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q719 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q723 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q724 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q728 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q730 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q733 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q736 ERROR prediction: execute: execute: column "attribute_name" does not exist LINE 4: WHERE attribute_name = 'Intelligence' ^ HINT: Perhaps you meant to reference the column "hero_attribute.attribute_value".
q737 ERROR prediction: execute: execute: column "race" does not exist LINE 1: SELECT race ^
q738 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q739 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q740 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q743 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q744 ERROR prediction: execute: execute: column "publisher_name" does not exist LINE 2: SUM(CASE WHEN publisher_name = 'Marvel Comics' THEN 1 ELSE 0... ^
q745 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q751 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q758 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q760 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q761 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q764 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q766 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q769 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q772 ERROR prediction: execute: execute: table name "h" specified more than once
q773 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q782 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q786 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q788 ERROR prediction: execute: execute: column "gender" does not exist LINE 2: ROUND(100 * SUM(CASE WHEN gender = 'Female' AND publisher_na... ^ HINT: Perhaps you meant to reference the column "superhero.gender_id".
q790 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q794 ERROR prediction: execute: execute: column ha.attribute_name does not exist LINE 4: WHERE ha.attribute_name = 'Speed' ^ HINT: Perhaps you meant to reference the column "ha.attribute_value".
q796 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q797 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q800 ERROR prediction: statement: the statement projects no column, so there is no answer to record or compare
q806 ERROR prediction: execute: execute: column colour.color does not exist LINE 1: SELECT colour.color ^ HINT: Perhaps you meant to reference the column "colour.colour".
q822 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q825 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q829 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 2: SUM(publisher_id = (SELECT id FROM publisher WHERE publishe... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q531 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q537 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q547 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q555 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q584 ERROR prediction: statement: the text does not parse: syntax error at or near "Here"
q587 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q598 ERROR prediction: execute: execute: column p1.creationdate does not exist LINE 2: ...d WHERE b1.name = 'Student' AND DATE_PART('year', p1.creatio... ^ HINT: Perhaps you meant to reference the column "p1.creaiondate".
q604 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q629 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT DIVIDE(COUNT(votes.id) FILTER (WHERE EXTRACT(YEAR FRO... ^ 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(p.viewcount)) as popularity ^
q637 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q639 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 5: JOIN tags t ON t.id = ANY(string_to_array(p.tags, ' ')) ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q665 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q678 ERROR prediction: execute: execute: column "views" does not exist LINE 3: WHERE ownerdisplayname = 'Harvey Motulsky' AND views = (SELE... ^
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: statement: the statement projects no column, so there is no answer to record or compare
q687 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q710 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q716 ERROR prediction: execute: execute: column v.upvotes does not exist LINE 2: ...ND(100.0 * COUNT(DISTINCT c.userid) FILTER (WHERE v.upvotes ... ^ HINT: Perhaps you meant to reference the column "u.upvotes".
q341 ERROR prediction: statement: the text does not parse: syntax error at or near "This"
q344 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.
q345 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: the text does not parse: syntax error at or near "foreign"
q349 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q352 ERROR prediction: statement: the text does not parse: syntax error at or near "Explanation"
q356 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q358 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q368 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q377 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q383 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q391 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q402 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q405 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q408 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q409 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q412 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q415 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 4: JOIN legalities ON cards.id = legalities.uuid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q416 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q422 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q440 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q462 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q465 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q466 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q468 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q472 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q473 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q474 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q479 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q480 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q484 ERROR prediction: statement: the text does not parse: syntax error at or near "foreign"
q486 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q487 ERROR prediction: statement: the text does not parse: syntax error at or near "Explanation"
q518 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q522 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 3: JOIN legalities ON cards.id = legalities.uuid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q529 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q530 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q198 ERROR prediction: execute: execute: column c.atom_id1 does not exist LINE 7: JOIN connected c ON (a.atom_id = c.atom_id1 AND b.bond_i... ^ HINT: Perhaps you meant to reference the column "c.atom_id" or the column "c.atom_id2".
q201 ERROR prediction: statement: the text does not parse: syntax error at end of input
q207 ERROR prediction: execute: execute: missing FROM-clause entry for table "e" LINE 1: SELECT DISTINCT e.element ^
q215 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q218 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q219 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q226 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
q227 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: ...N label = '+' THEN 1 ELSE 0 END) / COUNT(DISTINCT molecule_i... ^
q228 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q231 ERROR prediction: statement: the text does not parse: syntax error at or near "I"
q232 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 1: SELECT molecule_id ^
q234 ERROR prediction: execute: execute: column reference "bond_id" is ambiguous LINE 1: SELECT COUNT(DISTINCT bond_id) ^
q236 ERROR prediction: execute: execute: column bond.atom_id does not exist LINE 3: JOIN atom a1 ON bond.atom_id = a1.atom_id OR bond.atom_id = ... ^
q242 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q244 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q245 ERROR prediction: execute: execute: column bond.atom_id does not exist LINE 6: WHERE atom.element = 'i' AND atom.atom_id = bond.atom_id ^
q255 ERROR prediction: statement: the statement projects no column, so there is no answer to record or compare
q263 ERROR prediction: statement: the text does not parse: syntax error at or near "```"
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), COUNT... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q327 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q5 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q11 ERROR prediction: statement: the text does not parse: unterminated quoted identifier at or near ""Enrollment (K-1"
q24 ERROR prediction: execute: execute: column s.enrollment does not exist LINE 1: SELECT s.school, s.enrollment, fr.percent_eligible_frpm ^
q26 ERROR prediction: execute: execute: column s.highgrade does not exist LINE 4: WHERE s.highgrade = '12' ^
q27 ERROR prediction: statement: the text does not parse: syntax error at or near "Explanation"
q28 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q31 ERROR prediction: execute: execute: column f.school_code does not exist LINE 10: JOIN frpm f ON s.cdscode = f.School_Code ^ HINT: Perhaps you meant to reference the column "f.School Code".
q32 ERROR prediction: statement: the text does not parse: syntax error at or near "-"
q37 ERROR prediction: statement: the text does not parse: syntax error at or near "This"
q36 ERROR prediction: execute: execute: column "cdscode" does not exist LINE 5: SELECT cdscode, MAX(numge1500) AS max_numge1500 ^ DETAIL: There is a column named "cdscode" in table "s", but it cannot be referenced from this part of the query. HINT: To reference that column, you must mark this subquery with LATERAL.
q40 ERROR prediction: execute: execute: column s.phone does not exist LINE 1: SELECT s.phone ^ HINT: Perhaps you meant to reference the column "sch.phone".
q46 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q47 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT AVG(COUNT(cdscode)) AS "Monthly Average Number of Sch... ^
q50 ERROR prediction: execute: execute: column s.school does not exist LINE 1: SELECT s.school, s.street ^
q62 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 "\"
q79 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q82 ERROR prediction: execute: execute: column "high_grade" does not exist LINE 5: WHEN high_grade >= 12 AND low_grade <= 12 THEN 'K-12' ^
q83 ERROR prediction: statement: the text does not parse: syntax error at or near "Code"
q89 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q93 ERROR prediction: execute: execute: column c.a11 does not exist LINE 4: ...ERE c.gender = 'M' AND d.a3 = 'North Bohemia' AND c.a11 > 80... ^ HINT: Perhaps you meant to reference the column "d.a11".
q94 ERROR prediction: statement: 2 statements in one text; an audit runs one
q95 ERROR prediction: execute: execute: column "account_id" does not exist LINE 1: SELECT account_id ^
q98 ERROR prediction: execute: execute: function year(date) does not exist LINE 3: WHERE date IN (SELECT date FROM loan WHERE YEAR(date) = 1997... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q100 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q112 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q115 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q116 ERROR prediction: execute: execute: column client.account_id does not exist LINE 9: account_id = (SELECT client.account_id ^
q125 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q128 ERROR prediction: execute: execute: column "a2" does not exist LINE 1: SELECT a2, COUNT(DISTINCT account_id) as num_female_accounts ^
q136 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q137 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q138 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
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.
q149 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q168 ERROR prediction: execute: execute: column c.account_id does not exist LINE 3: JOIN account a ON c.account_id = a.account_id ^ HINT: Perhaps you meant to reference the column "a.account_id".
q169 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q173 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q186 ERROR prediction: statement: the text does not parse: syntax error at or near "\"
q189 ERROR prediction: execute: execute: column reference "district_id" is ambiguous LINE 10: SELECT district_id, MIN(a11) as min_salary ^
q194 ERROR prediction: statement: the text does not parse: syntax error at or near "\"

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