the run

audit-5057e95b-76d8-4d53-a20b-a2de3d1eb19a exit status 1

The whole of this run is a release asset

This site holds 23 of the 214 question directories this run wrote; the archive holds every one:

archive
minidev-pg-meta-llama-3-70b-instruct-2.tar.gz
size
1,589,058 bytes
sha256
f554f953678de01a49c8d5e58a83c10788850269a41e96686c676d83c2abbfc7

What it counted

whathow many
questions audited498
NOT_EQUAL209
EQUAL131
ERROR158
probes fired28
the verdicts of run audit-5057e95b-76d8-4d53-a20b-a2de3d1eb19a, from summary.json16 multiplicity3 type1 other189 NOT_EQUAL131 EQUAL158 ERROR
Of the questions this run audited: 16 multiplicity, 3 type, 1 other, 189 NOT_EQUAL, 131 EQUAL, 158 ERROR

the probes

probefired on
ordering-over-numeric-text1
arbitrary-cut11
not-a-function-of-the-data13
float-aggregate-order3
direction-against-question0
how many golds each probe fired on, of 498, from summary.json1 ordering-over-numeric-text11 arbitrary-cut13 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 1; arbitrary-cut on 11; not-a-function-of-the-data on 13; float-aggregate-order on 3.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here19
multiplicity16
type3
order0
truncation0
other0
the test-suite check answered 13
the test-suite check answered 016

What the run was made of

run
audit-5057e95b-76d8-4d53-a20b-a2de3d1eb19a
summary format
attestql/audit/summary/2
question file
data/questions/mini_dev_postgresql.json sha256:d2731292f20b8d8569cd956dd747ffe1df13cd625076263e38ae9ebcef50b1ab | https://bird-bench.oss-cn-beijing.aliyuncs.com/minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f, downloaded 2026-09-07), member minidev/MINIDEV/mini_dev_postgresql.json, 2024-06-19
questions in the file
500
prediction file
data/preds-pg/predict_mini_dev_meta-llama-3-70b-instruct-2_postgresql.json sha256:32d005d4529798c3be39a5af000454728404e840ce2205506bb9514232ad6330 | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_meta-llama-3-70b-instruct-2_postgresql.json, 2024-06-19
statements read
500
keyed by
position
data file
data/minidev/BIRD_dev.sql sha256:31b1da211849d24a57c9af7636da46a5b82fc8a3ca1542bb3ebd8775e9a31cec | minidev.zip (sha256 cc48ba16838204e4e214512030cb572eeb5f7bcdd999bae4b9b6ff12ec13b92f), member minidev/MINIDEV_postgresql/BIRD_dev.sql, 2024-06-13
server
PostgreSQL 16.15 (Debian 16.15-1.pgdg13+2) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit | server=172.17.0.2/32:5432 | database=bird
database role
auditor
engine
postgresql
parser
validator audit:libpg_query-parse, postgast 0.1.0, grammar_version 170007
serialization
attestql/audit/2
statement timeout
120 s
fixture digest depth
counts
schema digest
sha256:25aabd5763d7a18135a8741194c4a704141761bd0c7fdbfbf3f7c2bc9e0bf08c
data as of
2026-09-08T05:20:16.519959+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
q240 R-SET NOT_EQUAL multiplicity List all the elements of the toxicology of the molecule "TR004".
q253 R-SET NOT_EQUAL multiplicity List the elements of all the triple bonds.
q345 R-SET NOT_EQUAL multiplicity For artifact type of cards that do not have multiple faces on the same card, state its legalities status for vintage play format.
q358 R-SET NOT_EQUAL multiplicity What is the border color of card "Ancestor's Chosen"?
q440 R-SET NOT_EQUAL multiplicity Which foreign language used by "A Pedra Fellwar"?
q459 R-ORD NOT_EQUAL multiplicity Which card costs more converted mana, "Serra Angel" or "Shrine Keeper"?
q462 R-SET NOT_EQUAL multiplicity What's the Italian name of the set of cards with "Ancestor's Chosen" is in?
q487 R-SET NOT_EQUAL type What is the percentage of incredibly powerful cards in the set Coldsnap?
q522 R-SET NOT_EQUAL multiplicity Which cards are ranked 1st on EDHRec? List all of the cards name and its banned play format.
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.
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.
q879 R-ORD EQUAL ordering-over-numeric-text For the driver who set the fastest lap speed, what is his nationality?
q1134 R-SET NOT_EQUAL type What is the difference between players 6 and 23's jumping scores?
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?
q1389 R-ORD NOT_EQUAL other arbitrary-cut Which event has the lowest cost?
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?
q1482 ERROR prediction: execute: execute: OVER is not supported for ordered-set aggregate percentile_cont LINE 3: PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY percentage_i... ^
q1531 ERROR prediction: execute: execute: division by zero
q1533 ERROR prediction: execute: execute: division by zero
q1312 ERROR prediction: execute: execute: missing FROM-clause entry for table "m" LINE 1: SELECT m.major_name ^
q1340 ERROR prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 2: (SUM(b.spent) FILTER (WHERE EXTRACT(YEAR FROM e.event_da... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1351 ERROR prediction: execute: execute: missing FROM-clause entry for table "m" LINE 1: SELECT m.major_name ^
q1356 ERROR prediction: execute: execute: column m.department does not exist LINE 1: SELECT m.department ^
q1359 ERROR prediction: execute: execute: column "event_name" does not exist LINE 3: SELECT event_name, ^
q1368 ERROR prediction: execute: execute: missing FROM-clause entry for table "m" LINE 1: SELECT m.major_name ^
q1390 ERROR prediction: execute: execute: column ex.link_to_event does not exist LINE 3: JOIN event e ON ex.link_to_event = e.event_id; ^
q1432 ERROR prediction: statement: the text does not parse: syntax error at or near "FROM"
q1150 ERROR prediction: execute: execute: function year(date) does not exist LINE 4: (COUNT(CASE WHEN year(Birthday) > '1930' AND Sex... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1153 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1155 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1156 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.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: 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 patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^
q1166 ERROR prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Patient p ON e.patient_id = p.id ^
q1168 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1169 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 9: Patient.patient_id = Examination.patient_id ^
q1171 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1175 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 13: Examination e ON p.patient_id = e.patient_id ^
q1179 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.Patient_ID = e.Patient_ID ^
q1185 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
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: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1195 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination E ON P.PatientID = E.PatientID ^
q1198 ERROR prediction: execute: execute: column "patientid" does not exist LINE 4: SELECT PatientID ^
q1201 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(SEX = 'F'), COUNT(SEX)) * 100, 2) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1205 ERROR prediction: execute: execute: column p.patientid does not exist LINE 7: JOIN Examination e ON p.PatientID = e.PatientID ^
q1208 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
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.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1227 ERROR prediction: execute: execute: column "patient_id" does not exist LINE 4: AND ID IN (SELECT patient_id ^
q1229 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination E ON P.PatientID = E.PatientID ^
q1231 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1232 ERROR prediction: statement: the text does not parse: syntax error at or near "'T-CHO'"
q1235 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1238 ERROR prediction: execute: execute: column e.patientid does not exist LINE 3: JOIN Examination e ON p.ID = e.PatientID ^
q1239 ERROR prediction: execute: execute: column l.examinationid does not exist LINE 6: JOIN Laboratory l ON e.ID = l.ExaminationID ^
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 p.patientid does not exist LINE 11: Examination E ON P.PatientID = E.PatientID ^
q1247 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1251 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1252 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1254 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q1255 ERROR prediction: execute: execute: column p.patientid does not exist LINE 7: JOIN Examination e ON p.PatientID = e.PatientID ^
q1256 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1257 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1265 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1267 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1270 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1275 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1281 ERROR prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^
q1302 ERROR prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^
q1029 ERROR prediction: execute: execute: column ta.team_id does not exist LINE 3: JOIN Team_Attributes ta ON t.id = ta.team_id ^
q1030 ERROR prediction: execute: execute: column "home_team_league" does not exist LINE 6: (SELECT home_team_league, SUM(CASE WHEN home_team_g... ^
q1031 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1032 ERROR prediction: execute: execute: column l.league_id does not exist LINE 3: JOIN League l ON m.league_id = l.league_id ^ HINT: Perhaps you meant to reference the column "m.league_id".
q1035 ERROR prediction: execute: execute: column reference "team_fifa_api_id" is ambiguous LINE 1: SELECT team_fifa_api_id ^
q1036 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 1: SELECT team_long_name ^
q1037 ERROR prediction: execute: execute: column "preferred_foot" does not exist LINE 1: SELECT ROUND((SUM(CASE WHEN preferred_foot = 'left' THEN 1 E... ^
q1042 ERROR prediction: execute: execute: column m.league does not exist LINE 4: SELECT M.league ^ HINT: Perhaps you meant to reference the column "m.league_id" or the column "m.stage".
q1048 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 4: WHERE p.player_name = 'Gabriel Tamas' AND strftime('%Y', pa.... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1057 ERROR prediction: execute: execute: column "country" does not exist LINE 3: WHERE country = 'Poland' AND season = '2010/2011'; ^ HINT: Perhaps you meant to reference the column "match.country_id" or the column "match.corner".
q1058 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 10: JOIN Player_Attributes ON Player.id = Player_Attributes... ^
q1068 ERROR prediction: execute: execute: column p.date does not exist LINE 4: WHERE p.height > 170 AND strftime('%Y', p.date) >= '2010' AN... ^ HINT: Perhaps you meant to reference the column "pa.date".
q1076 ERROR prediction: execute: execute: column pa.player_name does not exist LINE 2: AVG(CASE WHEN pa.player_name = 'Abdou Diallo' THEN pa.ba... ^
q1078 ERROR prediction: execute: execute: column p1.name does not exist LINE 1: SELECT p1.name ^
q1079 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
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 m.match_id does not exist LINE 4: SELECT league_id, COUNT(m.match_id) as num_matches ^
q1094 ERROR prediction: execute: execute: column "player_name" does not exist LINE 1: ...ELECT overall_rating FROM Player_Attributes WHERE player_nam... ^
q1098 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player p ON pa.player_id = p.player_id ^
q1102 ERROR prediction: execute: execute: column "name" does not exist LINE 1: SELECT name ^
q1103 ERROR prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_id = pa.player_id ^
q1105 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Francesco Migliore' ^
q1107 ERROR prediction: execute: execute: column "player_name" does not exist LINE 4: SELECT player_name, MAX(crossing) as max_crossing ^
q1110 ERROR prediction: execute: execute: column m.player_api_id does not exist LINE 4: JOIN Match m ON p.player_api_id = m.player_api_id ^ HINT: Perhaps you meant to reference the column "p.player_api_id".
q1113 ERROR prediction: execute: execute: column ta.team_id does not exist LINE 3: JOIN Team t ON ta.team_id = t.id ^
q1115 ERROR prediction: execute: execute: column "player_name" does not exist LINE 6: WHERE player_name = 'Landon Donovan' AND date =... ^
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 ta.team_id does not exist LINE 3: JOIN Team t ON ta.team_id = t.id ^
q1135 ERROR prediction: execute: execute: column "player_id" does not exist LINE 1: SELECT player_id ^
q1136 ERROR prediction: execute: execute: column pa.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.id = pa.player_id ^
q1141 ERROR prediction: execute: execute: column "team_id" does not exist LINE 3: WHERE team_id IN (SELECT id ^
q1144 ERROR prediction: execute: execute: column pa.finishing_rate does not exist LINE 1: SELECT pa.finishing_rate, pa.curve_score ^
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: statement: the text does not parse: syntax error at or near "AS"
q866 ERROR prediction: execute: execute: column lt.resultid does not exist LINE 3: JOIN results r ON lt.resultid = r.resultid ^ HINT: Perhaps you meant to reference the column "r.resultid".
q869 ERROR prediction: execute: execute: column cr.resultid does not exist LINE 4: JOIN results r ON cr.resultid = r.resultid ^ HINT: Perhaps you meant to reference the column "r.resultid".
q880 ERROR prediction: execute: execute: operator does not exist: text - text LINE 1: ...rivers WHERE forename = 'Paul' AND surname = 'di Resta')) - ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q881 ERROR prediction: execute: execute: column r.date does not exist LINE 14: r.date = '1983-07-16'; ^
q894 ERROR prediction: execute: execute: column l.resultid does not exist LINE 3: JOIN results r2 ON l.resultid = r2.resultid ^ HINT: Perhaps you meant to reference the column "r2.resultid".
q895 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 "surname" does not exist LINE 5: ... (SELECT COUNT(raceid) FROM results WHERE surname = ... ^
q898 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 1: SELECT forename, surname, YEAR(CURRENT_TIMESTAMP) - YEAR(dob... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q901 ERROR prediction: execute: execute: function month(date) does not exist LINE 4: WHERE MONTH(r.date) = 9 AND YEAR(r.date) = 2005; ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q902 ERROR prediction: execute: execute: missing FROM-clause entry for table "r" LINE 1: SELECT r.name ^
q909 ERROR prediction: execute: execute: column "country" does not exist LINE 1: SELECT ROUND(COUNT(CASE WHEN country = 'Germany' THEN 1 END)... ^
q915 ERROR prediction: execute: execute: column "country" does not exist LINE 1: SELECT country ^
q944 ERROR prediction: execute: execute: operator does not exist: text - text LINE 2: (EXTRACT(EPOCH FROM (r1.time - r2.time)) / EXTRACT(EPOCH... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q954 ERROR prediction: execute: execute: column reference "driverid" is ambiguous LINE 6: SELECT COUNT(DISTINCT driverid) ^
q955 ERROR prediction: execute: execute: column reference "time" is ambiguous LINE 3: AVG(EXTRACT(EPOCH FROM time)) ^
q959 ERROR prediction: execute: execute: column "year" does not exist LINE 3: WHERE year = 2009 AND position = 1; ^
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 r.date does not exist LINE 6: COUNT(CASE WHEN EXTRACT(YEAR FROM r.date) BETWEE... ^
q963 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".
q988 ERROR prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT d.forename, d.surname, AVG(ps.duration) AS avg_pitsto... ^ 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.name does not exist LINE 1: ... || ' ' || d.surname AS full_name, d.nationality, r.name AS ... ^ HINT: Perhaps you meant to reference the column "r.time".
q819 ERROR prediction: execute: execute: function subtract(bigint, bigint) does not exist LINE 2: SUBTRACT(SUM(CASE WHEN T2.id = 7 THEN 1 ELSE 0 END), SUM... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q629 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.
q640 ERROR prediction: statement: the text does not parse: syntax error at or near "SELECT"
q672 ERROR prediction: execute: execute: column "postid" does not exist LINE 6: SELECT postid ^
q340 ERROR prediction: execute: execute: column "cardKingdomFoilId" does not exist LINE 3: WHERE "cardKingdomFoilId" IS NOT NULL AND "cardKingdomId" IS... ^ HINT: Perhaps you meant to reference the column "cards.cardkingdomfoilid".
q368 ERROR prediction: statement: the text does not parse: syntax error at or near "AS"
q371 ERROR prediction: execute: execute: column "language" does not exist LINE 2: (SELECT COUNT(id) FROM cards WHERE language = 'French' A... ^
q415 ERROR prediction: execute: execute: operator does not exist: bigint = text LINE 1: ...OUNT(c.id) / (SELECT COUNT(*) FROM cards WHERE id IN (SELECT... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q416 ERROR prediction: execute: execute: column "cardid" does not exist LINE 7: id IN (SELECT cardid FROM foreign_data WHERE language ... ^
q422 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: JOIN foreign_data fd ON c.multiverseid = fd.multiverseid ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q424 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT ROUND(DIVIDE(COUNT(CASE WHEN "istextless" = 1 AND "la... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q466 ERROR prediction: execute: execute: column "translation" does not exist LINE 5: WHERE translation = 'Hauptset Zehnte Edit... ^
q518 ERROR prediction: execute: execute: column "c.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT l.format, c.name ^
q198 ERROR prediction: execute: execute: column reference "molecule_id" is ambiguous LINE 3: SELECT molecule_id, COUNT(DISTINCT bond_id) AS single_bo... ^
q228 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN element = 'h' THEN 1 ELSE ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q245 ERROR prediction: execute: execute: column reference "atom_id" is ambiguous LINE 3: SELECT atom_id, COUNT(bond_id) AS num_bonds ^
q255 ERROR prediction: execute: execute: function divide(numeric, bigint) does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN m.label = '+' THEN 1 ELSE ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q263 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT ROUND(DIVIDE(SUM(CASE WHEN a.element = 'cl' THEN 1 EL... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q282 ERROR prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 2: DIVIDE(SUM(CASE WHEN a.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.
q11 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q12 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q23 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q24 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q25 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: missing FROM-clause entry for table "s" LINE 1: SELECT s.sname, sat.avgscrwrite, sch.phone ^
q28 ERROR prediction: statement: the text does not parse: syntax error at or near "Code"
q31 ERROR prediction: execute: execute: column "enrollment_k12" does not exist LINE 11: Enrollment_K12, ^
q32 ERROR prediction: execute: execute: column "frpm_count_k_12" does not exist LINE 1: SELECT school, (FRPM_Count_K_12 / Enrollment_K_12) * 100 AS ... ^
q40 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q41 ERROR prediction: execute: execute: column s.school does not exist LINE 1: SELECT s.school, avgscrread ^ HINT: Perhaps you meant to reference the column "sc.school".
q45 ERROR prediction: execute: execute: missing FROM-clause entry for table "s" LINE 1: SELECT s.school, avgscrwrite ^
q48 ERROR prediction: execute: execute: operator does not exist: text = integer LINE 2: (SUM(CASE WHEN s.doc = 54 THEN 1 ELSE 0 END) * 1.0 / SUM... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q62 ERROR prediction: statement: the text does not parse: syntax error at or near "Meal"
q77 ERROR prediction: execute: execute: column f.frpm_count_ages_5_17 does not exist LINE 1: SELECT s.school, (f.FRPM_Count_Ages_5_17 / f.Enrollment_Ages... ^
q82 ERROR prediction: execute: execute: column s.low_grade does not exist LINE 1: SELECT s.Low_Grade, s.High_Grade ^
q83 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q85 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q94 ERROR prediction: execute: execute: each UNION query must have the same number of columns LINE 8: SELECT (SELECT MAX(a11) FROM district WHERE district_id IN (... ^
q115 ERROR prediction: execute: execute: division by zero
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.
q192 ERROR prediction: execute: execute: column "k_symbol" does not exist LINE 3: WHERE status = 'C' AND k_symbol = 'POPLATEK PO OBRATU'; ^

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