Comment by bazoom42 1 day ago Isn’t sql weakly typed? Or does this depend on the engine? 4 comments bazoom42 Reply groundzeros2015 21 hours ago SQLite is the only one I know of that doesn’t enforce types by default, but I don’t know what the SQL spec requires. pjmlp 17 hours ago No it is strongly typed, there is no accident that all PL extensions to the base query language have such a Ada/Pascal similarity.Additional DML has plenty of options to enforce rules that keep data consistency.While they make the life harder to delete/update/insert items in specific sequences, they can save the day on bad queries. bazoom42 5 hours ago What happens if a query compares a string to a number? mike_hearn 5 hours ago You get a type error from the database.
groundzeros2015 21 hours ago SQLite is the only one I know of that doesn’t enforce types by default, but I don’t know what the SQL spec requires.
pjmlp 17 hours ago No it is strongly typed, there is no accident that all PL extensions to the base query language have such a Ada/Pascal similarity.Additional DML has plenty of options to enforce rules that keep data consistency.While they make the life harder to delete/update/insert items in specific sequences, they can save the day on bad queries. bazoom42 5 hours ago What happens if a query compares a string to a number? mike_hearn 5 hours ago You get a type error from the database.
bazoom42 5 hours ago What happens if a query compares a string to a number? mike_hearn 5 hours ago You get a type error from the database.
SQLite is the only one I know of that doesn’t enforce types by default, but I don’t know what the SQL spec requires.
No it is strongly typed, there is no accident that all PL extensions to the base query language have such a Ada/Pascal similarity.
Additional DML has plenty of options to enforce rules that keep data consistency.
While they make the life harder to delete/update/insert items in specific sequences, they can save the day on bad queries.
What happens if a query compares a string to a number?
You get a type error from the database.