← Back to context Comment by bazoom42 21 hours ago Isn’t sql weakly typed? Or does this depend on the engine? 4 comments bazoom42 Reply groundzeros2015 20 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 16 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 4 hours ago What happens if a query compares a string to a number? mike_hearn 4 hours ago You get a type error from the database.
groundzeros2015 20 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 16 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 4 hours ago What happens if a query compares a string to a number? mike_hearn 4 hours ago You get a type error from the database.
bazoom42 4 hours ago What happens if a query compares a string to a number? mike_hearn 4 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.