search

taoyds / spider

scripts and baselines for Spider: Yale complex and cross-domain semantic parsing and text-to-SQL challenge
https://yale-lily.github.io/spider
Apache License 2.0
848 stars 193 forks source link

[schema error] composite key #20

Closed leoeaton closed 5 years ago

leoeaton commented 5 years ago

There are composite key sets in some tables according to the *.sql file. For example, in college_2 database, the 6th line in the file TextBookExample.sql says "primary key (building, room_number)", which indicate building and room_number are composite key of this table. However, in the tables.json, building is annotated as the only primary key of the table. I notice there are also some other databases where such issue exists.

taoyds commented 5 years ago

Thanks for your report. We used a script to automatically extract schema info for each database. I am sure why this happens. I already recorded your findings [here(https://github.com/taoyds/spider/issues/24). We will correct the tables.json file in the next release. Please comment under that issue thread if you find more errors.