datacamp / sqlwhat

https://sqlwhat.readthedocs.io
GNU Affero General Public License v3.0
3 stars 8 forks source link

check_result option to be flexible on column name/order #10

Closed machow closed 7 years ago

machow commented 7 years ago

Minimal example:

CREATE TABLE simple ( id INTEGER)
INSERT INTO simple (1)

Pass both SELECT id FROM simple and SELECT id as id2 FROM simple.

Realistic Example:

For example, both should pass:

SELECT 
    EXTRACT(MONTH FROM start_time) AS month, 
    COUNT(*) 
FROM trips 
GROUP BY month;
SELECT 
    EXTRACT(MONTH FROM start_time) AS month, 
    COUNT(*) as ttl
FROM trips 
GROUP BY month;
machow commented 7 years ago

deployed in 0.0.6 d638c4e1f473d5359dc04a8cc0745c686da4716c