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
812 stars 193 forks source link

Incorrect value in order_items table (customers_and_products_contacts set) #69

Open RicardoBrancas opened 3 years ago

RicardoBrancas commented 3 years ago

The column order_quantity in the order_items table contains a value which appears to be incorrect:

order_quantity
3
7
9
male
3
4
...

Furthermore the column has type VARCHAR(80) but one of the golden queries performs a SUM over this column:

SELECT T1.product_name, sum(T2.order_quantity)
FROM products AS T1
JOIN order_items AS T2 ON T1.product_id = T2.product_id
GROUP BY T1.product_id