Skip to content

Wrong gold sql in SQLITE #195 #24

@onesecurity-app

Description

@onesecurity-app

In the downloaded attached file:
mini_dev_sqlite_gold.sql

Question 195 is expected to answer with:
SELECT T1.nationality FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId ORDER BY T2.fastestLapSpeed DESC LIMIT 1

When slightly adjusting the expected gold sql to:
SELECT T1.nationality, T2.fastestLapSpeed FROM drivers AS T1 INNER JOIN results AS T2 ON T2.driverId = T1.driverId ORDER BY T2.fastestLapSpeed DESC

(adding the actual speed and removing the limit).

We can see that the first results show:
Italian 91.610
British 89.540
Brazilian 257.320
German 256.324

And that we are choosing "Italian" based on it being the one with the maximum lexicographic value (starting with a 9) vs any regard to numeric values.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions