the run

audit-b6efa569-00a2-4421-b91b-09d107e2dac3 exit status 1

The whole of this run is a release asset

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

archive
minidev-pg-gpt-35-turbo-instruct.tar.gz
size
12,218,848 bytes
sha256
c5e459dd3bfda9c6e56ea755afb3c894c63a7d26c215b374d93a9e44b9ec3adf

What it counted

whathow many
questions audited498
NOT_EQUAL193
ERROR189
EQUAL116
probes fired31
the verdicts of run audit-b6efa569-00a2-4421-b91b-09d107e2dac3, from summary.json16 multiplicity3 type1 other173 NOT_EQUAL189 ERROR116 EQUAL
Of the questions this run audited: 16 multiplicity, 3 type, 1 other, 173 NOT_EQUAL, 189 ERROR, 116 EQUAL

the probes

probefired on
ordering-over-numeric-text2
arbitrary-cut12
not-a-function-of-the-data14
float-aggregate-order3
direction-against-question0
how many golds each probe fired on, of 498, from summary.json2 ordering-over-numeric-text12 arbitrary-cut14 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 12; not-a-function-of-the-data on 14; float-aggregate-order on 3.

credited by BIRD's own check and NOT_EQUAL here

whathow many
credited by BIRD and NOT_EQUAL here18
multiplicity17
type1
order0
truncation0
other0
the test-suite check answered 11
the test-suite check answered 017

What the run was made of

run
audit-b6efa569-00a2-4421-b91b-09d107e2dac3
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-instruct_postgresql.json sha256:df1edf6aac3c01cf93041bcd7b60378efe6f7359f19add6d2af2345bef092bf9 | https://raw.githubusercontent.com/bird-bench/mini_dev/b3d4bcbbae9a96934ad812551eb400c7a3b23c12/llm/exp_result/sql_output_kg/predict_mini_dev_gpt-35-turbo-instruct_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.520067+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
q45 R-SET NOT_EQUAL type What is the average writing score of each of the schools managed by Ricci Ulrich? List the schools and the corresponding average writing scores.
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?
q230 R-SET NOT_EQUAL multiplicity What are the elements of the toxicology and label of molecule TR060?
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"?
q414 R-SET NOT_EQUAL multiplicity What language is the set of 180 cards that belongs to the Ravnica block translated into?
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?
q978 R-SET NOT_EQUAL multiplicity How many times the circuits were held in Austria? Please give their location and coordinates.
q1035 R-SET NOT_EQUAL multiplicity Give the team_fifa_api_id of teams with more than 50 but less than 60 build-up play speed.
q1057 R-SET NOT_EQUAL type Calculate the average home team goal in the 2010/2011 season in the country of Poland.
q1088 R-SET NOT_EQUAL multiplicity Please list the names of the players whose volley score and dribbling score are over 70.
q1122 R-SET NOT_EQUAL multiplicity State the name of the most strongest player.
q1147 R-SET NOT_EQUAL multiplicity Please name one player whose overall strength is the greatest.
q1361 R-SET EQUAL float-aggregate-order What is the total cost of the pizzas for all the events?
q1380 R-SET EQUAL float-aggregate-order What is the total amount of money spent for food?
q1435 R-SET NOT_EQUAL multiplicity List the names of closed event as "game" that was closed from 3/15/2019 to 3/20/2020.
q1457 R-SET NOT_EQUAL multiplicity Give the full name and contact number of members who had to spend more than average on each expense.
q1506 R-SET NOT_EQUAL multiplicity Please list the product descriptions of the transactions taken place in the gas stations in the Czech Republic.
q1514 R-SET NOT_EQUAL multiplicity What kind of currency did the customer paid at 16:25:00 in 2012/8/24?
q1529 R-SET NOT_EQUAL type not-a-function-of-the-data What is the amount spent by customer "38508" at the gas stations? How much had the customer spent in January 2012?
q1472 ERROR prediction: execute: execute: operator does not exist: text >= integer LINE 6: date BETWEEN 201201 AND 201212 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1473 ERROR prediction: execute: execute: operator does not exist: text >= integer LINE 3: WHERE date BETWEEN 201301 AND 201312 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q1476 ERROR prediction: execute: execute: column "currency" does not exist LINE 1: SELECT SUM(CASE WHEN currency = 'CZK' THEN consumption ELSE... ^
q1479 ERROR prediction: execute: execute: column "currency" does not exist LINE 5: WHERE currency = 'CZK' ^
q1481 ERROR prediction: execute: execute: column "segment" does not exist LINE 2: ...(DISTINCT customerid)) FROM transactions_1k WHERE segment = ... ^
q1524 ERROR prediction: execute: execute: column c.country does not exist LINE 1: SELECT c.country ^
q1531 ERROR prediction: execute: execute: division by zero
q1533 ERROR prediction: execute: execute: division by zero
q1322 ERROR prediction: execute: execute: aggregate functions are not allowed in WHERE LINE 3: ...ent FROM attendance GROUP BY link_to_event HAVING COUNT(even... ^
q1323 ERROR prediction: execute: execute: column "event.type" must appear in the GROUP BY clause or be used in an aggregate function LINE 5: HAVING COUNT(event.event_id) > 20 AND event.type != 'fundrai... ^
q1331 ERROR prediction: execute: execute: column "amount" does not exist LINE 1: SELECT SUM(amount) ^
q1339 ERROR prediction: execute: execute: function month(text) does not exist LINE 3: WHERE link_to_member = 'Elijah Allen' AND (month(expense_dat... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1340 ERROR prediction: execute: execute: column "event_date" does not exist LINE 1: ... budget WHERE event_status = 'completed' AND YEAR(event_date... ^
q1356 ERROR prediction: execute: execute: column member.department does not exist LINE 1: SELECT member.department ^
q1359 ERROR prediction: execute: execute: column "event_name" does not exist LINE 3: WHERE category = 'Advertisement' AND event_name = 'Yearly Ki... ^
q1371 ERROR prediction: statement: the text does not parse: syntax error at or near "s"
q1376 ERROR prediction: execute: execute: column "spent" does not exist LINE 4: ORDER BY MAX(DIVIDE(spent, amount)) DESC ^
q1389 ERROR prediction: execute: execute: column "cost" does not exist LINE 5: WHERE cost = (SELECT MIN(cost) ^
q1390 ERROR prediction: statement: the text does not parse: syntax error at or near "where"
q1392 ERROR prediction: execute: execute: column "income.amount" must appear in the GROUP BY clause or be used in an aggregate function LINE 5: ORDER BY amount DESC ^
q1432 ERROR prediction: execute: execute: column "amount" does not exist LINE 1: SELECT DIVIDE(COUNT(amount = 50), COUNT(member_id)) * 100 ^
q1150 ERROR prediction: statement: the text does not parse: syntax error at or near "where"
q1152 ERROR prediction: statement: the text does not parse: syntax error at or near "where"
q1153 ERROR prediction: execute: execute: column examination.date does not exist LINE 2: Examination.date ^
q1155 ERROR prediction: execute: execute: column patient.patient_id does not exist LINE 3: INNER JOIN Examination ON Patient.patient_id = Examination.p... ^
q1156 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 1: SELECT ID, SUBTRACT(year(current_timestamp), year(Birthday)... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1157 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.ID = Examination.patientID ^
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 examination.patientid does not exist LINE 3: INNER JOIN Patient ON Examination.PatientID = Patient.Patien... ^
q1166 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: INNER JOIN Patient ON Examination.patient_id = Patient.id ^
q1168 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1169 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT SUM(SEX = 'M')/SUM(SEX = 'F') ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1171 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1175 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1179 ERROR run: row_counts: row_counts: relation "public.diagnosis" does not exist LINE 1: SELECT count(*) FROM "public"."diagnosis" ^
q1185 ERROR prediction: statement: the text does not parse: syntax error at or near "THEN"
q1187 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: INNER 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.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1195 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1201 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT DIVIDE(SUM(SEX = 'F'), COUNT(SEX)) * 100 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1205 ERROR prediction: execute: execute: column "ua" does not exist LINE 2: UA ^
q1208 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.ID = Examination.PatientID ^
q1209 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 6: Examination ON Patient.id = Examination.patient_id ^
q1220 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: INNER JOIN Examination ON Patient.ID = Examination.patient_i... ^
q1225 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: INNER JOIN Examination ON Patient.ID = Examination.patient_i... ^
q1227 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 4: ON Patient.ID = Examination.patient_id ^
q1229 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1231 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1232 ERROR prediction: execute: execute: column "age" does not exist LINE 1: SELECT ID, sex, age ^
q1235 ERROR prediction: execute: execute: column examination.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.ID = Examination.PatientID ^
q1239 ERROR prediction: execute: execute: column "age" does not exist LINE 1: SELECT ID, age ^
q1241 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 2: INNER JOIN Examination ON Patient.id = Examination.patient_i... ^
q1242 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 2: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1243 ERROR prediction: statement: the text does not parse: syntax error at or near "="
q1247 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1251 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1252 ERROR prediction: execute: execute: column "igg" does not exist LINE 3: WHERE IGG > 900 AND IGG < 2000 AND Symptoms IS NOT NULL ^
q1254 ERROR prediction: statement: the text does not parse: syntax error at or near "Date"
q1255 ERROR prediction: execute: execute: aggregate function calls cannot be nested LINE 1: SELECT MAX(COUNT(Diagnosis)) ^
q1256 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1257 ERROR prediction: execute: execute: column "cre" does not exist LINE 3: WHERE CRE >= 1.5 AND SUBTRACT((YEAR(CURDATE()), YEAR(Birthda... ^
q1265 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 4: ON Patient.PatientID = Examination.PatientID ^
q1267 ERROR prediction: execute: execute: missing FROM-clause entry for table "examination" LINE 3: WHERE Examination.SM = 'negative' AND Laboratory.Thrombosis ... ^
q1270 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1275 ERROR prediction: execute: execute: column patient.patientid does not exist LINE 3: INNER JOIN Examination ON Patient.PatientID = Examination.Pa... ^
q1281 ERROR prediction: execute: execute: column "patient_id" does not exist LINE 1: ...T MIN(birthday) FROM Patient WHERE id IN (SELECT patient_id... ^
q1302 ERROR prediction: execute: execute: column examination.patient_id does not exist LINE 3: INNER JOIN Examination ON Patient.id = Examination.patient_i... ^
q1029 ERROR prediction: statement: the text does not parse: syntax error at end of input
q1030 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 6: ORDER BY SUM(m.home_team_goal = m.away_team_goal) DESC ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1031 ERROR prediction: execute: execute: function datetime() does not exist LINE 2: SUBTRACT((DATETIME(), birthday)) AS age ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1036 ERROR prediction: execute: execute: column "buildupplaypassing" does not exist LINE 3: WHERE buildUpPlayPassing > (SELECT AVG(buildUpPlayPassing) F... ^
q1037 ERROR prediction: execute: execute: column "preferred_foot" does not exist LINE 1: SELECT 100 * SUM(CASE WHEN preferred_foot = 'left' THEN 1 EL... ^
q1039 ERROR prediction: execute: execute: function divide(numeric, bigint) does not exist LINE 1: SELECT DIVIDE(SUM(long_shots), COUNT(player_fifa_api_id)) A... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1042 ERROR prediction: execute: execute: column match.name does not exist LINE 3: JOIN Match ON League.name = Match.name ^ HINT: Perhaps you meant to reference the column "match.date".
q1048 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 4: WHERE Player.player_name = 'Gabriel Tamas' AND strftime('%Y'... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1058 ERROR prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^
q1068 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 5: WHERE t1.height > 170 AND strftime('%Y', t2.date) >= '2010' ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1076 ERROR prediction: execute: execute: column "player_name" does not exist LINE 1: SELECT SUM(CASE WHEN player_name = 'Abdou Diallo' THEN ball... ^
q1078 ERROR prediction: execute: execute: input of anonymous composite types is not implemented LINE 3: WHERE Player = 'Aaron Lennon' OR Player = 'Abdelaziz Barrada... ^
q1084 ERROR prediction: execute: execute: function strftime(unknown, text) does not exist LINE 3: WHERE strftime('%Y', birthday)<'1986' AND defensive_work_rat... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q1091 ERROR prediction: statement: the text does not parse: syntax error at or near ","
q1092 ERROR prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT MAX(league_name) ^
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 "team_long_name" does not exist LINE 3: WHERE team_long_name = 'Ajax' ^
q1107 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Kevin Constant' ^
q1113 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 3: WHERE team_long_name = 'Hannover 96' AND date LIKE '2015-09-... ^
q1114 ERROR prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Marko Arnautovic' AND date BETWEEN '200... ^
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.height does not exist LINE 4: ORDER BY Player_Attributes.height DESC ^
q1130 ERROR prediction: execute: execute: column "team_short_name" does not exist LINE 1: SELECT team_short_name ^
q1134 ERROR prediction: statement: the text does not parse: trailing junk after numeric literal at or near "6.jumping"
q1135 ERROR prediction: execute: execute: column player.player_id does not exist LINE 3: INNER JOIN Player_Attributes ON Player.player_id = Player_At... ^
q1139 ERROR prediction: execute: execute: missing FROM-clause entry for table "league" LINE 3: WHERE date = '2008-09-24%' AND League.name = 'Belgium Jupile... ^
q1141 ERROR prediction: execute: execute: column "team_long_name" does not exist LINE 3: WHERE team_long_name = 'KSV Cercle Brugge' ^
q1144 ERROR prediction: execute: execute: column player_attributes.player_id does not exist LINE 4: ON Player_Attributes.player_id = Player.player_id ^
q1148 ERROR prediction: execute: execute: column "height" does not exist LINE 1: SELECT DIVIDE(COUNT(height < 180 AND overall_rating > 70),C... ^
q869 ERROR prediction: execute: execute: column "url" does not exist LINE 1: SELECT url ^
q880 ERROR prediction: execute: execute: function fastestlapspeed(boolean) does not exist LINE 1: SELECT 100 * (fastestlapspeed (raceid = 853) - fastestlapspe... ^ 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: column "wins" does not exist LINE 1: ..., drivers.surname, drivers.nationality, MAX(COUNT(wins)), MA... ^
q898 ERROR prediction: execute: execute: column "age" does not exist LINE 1: SELECT MIN(age) AS "Youngest Japanese Driver", forename || ... ^
q901 ERROR prediction: execute: execute: function month(date) does not exist LINE 4: WHERE MONTH(races.date) = 9 AND YEAR(races.date) = 2005 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q909 ERROR prediction: statement: the text does not parse: syntax error at or near "where"
q944 ERROR prediction: execute: execute: operator does not exist: text - text LINE 1: SELECT 100 * (r.time - (SELECT MIN(time) FROM results WHERE ... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q954 ERROR prediction: execute: execute: column "year" does not exist LINE 3: WHERE time IS NOT NULL AND year BETWEEN 2007 AND 2009 AND dr... ^
q955 ERROR prediction: execute: execute: column "year" does not exist LINE 3: WHERE position = 1 AND year < 1975 ^
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"
q972 ERROR prediction: execute: execute: function year(date) does not exist LINE 4: WHERE year(dob) = 1971 AND fastestlaptime IS NOT NULL ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q988 ERROR prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT drivers.forename, drivers.surname, AVG(pitStops.dura... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q990 ERROR prediction: execute: execute: column reference "url" is ambiguous LINE 1: SELECT constructorref, url ^
q717 ERROR prediction: statement: the text does not parse: syntax error at or near "."
q1001 ERROR prediction: execute: execute: column "round" does not exist LINE 4: ...ame = 'Singapore Grand Prix' AND year = 2008) AND round = 3) ^
q724 ERROR prediction: execute: execute: table name "colour" specified more than once
q775 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT 100 * SUM(colour = 'Blue') / COUNT(*) AS percentage ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q782 ERROR prediction: execute: execute: table name "colour" specified more than once
q788 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT 100 * SUM(gender = 'Female' AND publisher_name = 'Mar... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q790 ERROR prediction: statement: the text does not parse: syntax error at or near "SELECT"
q797 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"
q801 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT SUM(gender_id = 1) / SUM(gender_id = 2) AS ratio ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q829 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT SUM(publisher_name = 'DC Comics') - SUM(publisher_na... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q532 ERROR prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 3: WHERE year(creationdate) = 2011 ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q592 ERROR prediction: execute: execute: aggregate functions are not allowed in WHERE LINE 3: WHERE COUNT(name) > 5 ^
q629 ERROR prediction: statement: the text does not parse: trailing junk after numeric literal at or near "2010_count"
q637 ERROR prediction: execute: execute: operator does not exist: text = bigint LINE 3: INNER JOIN tags ON posts.tags = tags.id ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q639 ERROR prediction: execute: execute: column "postid" does not exist LINE 1: SELECT (SELECT COUNT(postid) FROM posts WHERE tags LIKE '%r... ^
q665 ERROR prediction: execute: execute: column p.creationdate does not exist LINE 11: AND EXTRACT(YEAR FROM p.creationdate) = 2010 ^ HINT: Perhaps you meant to reference the column "pl.creationdate" or the column "p.creaiondate".
q669 ERROR prediction: execute: execute: column reference "creationdate" is ambiguous LINE 1: SELECT MIN(CreationDate) ^
q682 ERROR prediction: execute: execute: column "creationdate" does not exist LINE 3: ...favoritecount) FROM posts WHERE date_part('year', creationda... ^ HINT: Perhaps you meant to reference the column "posts.creaiondate" or the column "posts.creaiondate".
q683 ERROR prediction: execute: execute: column posts.creationdate does not exist LINE 1: ...ERE users.reputation > 1000 AND EXTRACT(YEAR FROM posts.crea... ^ HINT: Perhaps you meant to reference the column "posts.creaiondate".
q701 ERROR run: row_counts: row_counts: relation "public.stats_posts" does not exist LINE 1: SELECT count(*) FROM "public"."stats_posts" ^
q716 ERROR prediction: execute: execute: column "upvotes" does not exist LINE 1: SELECT 100 * COUNT(userid) FILTER (WHERE upvotes = 0 AND sco... ^
q352 ERROR prediction: execute: execute: column "language" does not exist LINE 1: SELECT 100 * (SELECT COUNT(id) FROM cards WHERE language = '... ^
q371 ERROR prediction: statement: the text does not parse: syntax error at or near "WHERE"
q402 ERROR prediction: execute: execute: column "isstorylight" does not exist LINE 1: SELECT 100 * SUM(CASE WHEN isStorylight = 1 AND isTextless =... ^
q407 ERROR prediction: execute: execute: column "language" does not exist LINE 3: WHERE language = 'German' AND subtypes IS NOT NULL AND super... ^
q415 ERROR prediction: execute: execute: division by zero
q416 ERROR prediction: execute: execute: column "language" does not exist LINE 3: WHERE language = 'French' AND (power IS NULL OR power = '*') ^
q462 ERROR prediction: execute: execute: column cards.language does not exist LINE 4: WHERE cards.name = 'Ancestor''s Chosen' AND cards.language =... ^
q486 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT 100 * SUM(convertedManaCost = 7) / SUM(convertedManaC... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q487 ERROR prediction: execute: execute: argument of AND must be type boolean, not type bigint LINE 1: SELECT 100 * SUM(hasfoil AND hasnonfoil) / SUM(name = 'Colds... ^
q197 ERROR prediction: execute: execute: function avg(boolean) does not exist LINE 1: SELECT AVG(element = 'o') ^ 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 sum(boolean) does not exist LINE 1: SELECT 100 * SUM(element = 'c') / COUNT(atom_id) AS percenta... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q206 ERROR prediction: statement: the text does not parse: syntax error at end of input
q208 ERROR prediction: execute: execute: column "label" does not exist LINE 1: SELECT MAX(COUNT(label)) ^
q218 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 4: SELECT DIVIDE(SUM(element = 'f') * 100, COUNT(DISTINCT m... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q219 ERROR prediction: statement: the text does not parse: unterminated quoted string at or near "'"
q226 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT DIVIDE(SUM(bond_type = '='), COUNT(bond_id)) as perc... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q227 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT 100 * SUM(label = '+') / COUNT(molecule_id) AS percen... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q228 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT DIVIDE(SUM(element = 'h'), COUNT(atom_id)) as percen... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q232 ERROR prediction: execute: execute: column connected.molecule_id does not exist LINE 4: INNER JOIN connected ON molecule.molecule_id = connected.mol... ^
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 sum(boolean) does not exist LINE 1: SELECT DIVIDE(SUM(label = '+') * 100, COUNT(bond_id)) AS pr... ^ 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 sum(boolean) does not exist LINE 1: SELECT 100 * SUM(element = 'cl') / COUNT(atom_id) AS percent ^ 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 100 * SUM(element = 'cl') / COUNT(molecule_id) AS per... ^
q282 ERROR prediction: execute: execute: function sum(boolean) does not exist LINE 1: SELECT DIVIDE(SUM(element = 'h'), count(element)) as ratio ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
q11 ERROR prediction: execute: execute: column schools.Enrollment (K-12) does not exist LINE 3: WHERE (schools."Enrollment (K-12)" + schools."Enrollment (Ag... ^
q12 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 "INNER"
q27 ERROR prediction: execute: execute: column s.phone does not exist LINE 1: SELECT s.sname, s.avgscrwrite, s.phone ^ HINT: Perhaps you meant to reference the column "sc.phone".
q28 ERROR prediction: statement: the text does not parse: syntax error at or near "5"
q31 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q32 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q46 ERROR prediction: execute: execute: operator does not exist: text = integer LINE 3: WHERE schools.doc = 31 AND schools.gsserved = '1-12' ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q47 ERROR prediction: execute: execute: operator does not exist: text = integer LINE 3: WHERE schools.doc = 52 AND schools.county = 'Alameda' AND sc... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
q48 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q50 ERROR prediction: execute: execute: column s.street does not exist LINE 1: SELECT s.sname, s.street ^
q62 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q72 ERROR prediction: execute: execute: column "City" does not exist LINE 3: ...ial School' AND "Academic Year" = '2014-2015' AND "City" = '... ^
q77 ERROR prediction: statement: the text does not parse: syntax error at or near "`"
q83 ERROR prediction: statement: the text does not parse: syntax error at or near "Provision"
q85 ERROR prediction: statement: the text does not parse: syntax error at or near "%"
q94 ERROR prediction: execute: execute: column a.client_id does not exist LINE 4: ON c.client_id = a.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q95 ERROR prediction: execute: execute: column a.client_id does not exist LINE 3: INNER JOIN client c ON a.client_id = c.client_id ^ HINT: Perhaps you meant to reference the column "c.client_id".
q98 ERROR prediction: statement: the text does not parse: syntax error at or near "INNER"
q100 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".
q112 ERROR prediction: execute: execute: column account.client_id does not exist LINE 3: INNER JOIN account ON client.client_id = account.client_id ^
q116 ERROR prediction: execute: execute: more than one row returned by a subquery used as an expression
q117 ERROR prediction: execute: execute: missing FROM-clause entry for table "total" LINE 1: SELECT 100 * SUM(loan.amount) / SUM(total.amount) AS percent... ^
q137 ERROR prediction: execute: execute: column "a1" does not exist LINE 3: ...ict_id IN (SELECT district_id FROM district WHERE a1 = 1) AN... ^
q129 ERROR prediction: execute: execute: operator does not exist: date ~~ unknown LINE 7: WHERE trans.type = 'VYDAJ' AND trans.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 4: 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: INNER 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