Re:A Short Story About SQL’s Biggest Rival
by blendo on Saturday October 10, 2020 @12:58PM
(#24740251)
Do you mean “incorrect” in the sense that comparing a customer_id to an order_id is semantic nonsense?
I agree, and I do wish SQL had stronger typing so the parser could warn you before your query silently runs off the rails. For example, in Oracle, I believe the following is legal, but I wish it wasn’t:
select *
from my tab
where 1 = ‘1’
Example:
select * from customers c inner join orders o on o.order_id = c.customer_id
Legal syntax but clearly incorrect.
[1] https://books.google.co.uk/books?id=t9ZQAAAAMAAJ&source=gbs_...