What's wrong with this SQL query doubling the boundary row?
What's wrong with this SQL query doubling the boundary row in a report. The SQL code uses BETWEEN for a date range. In SQL BETWEEN is inclusive on both ends so the boundary gets counted twice if used in a join.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sq...
Why does this SQL JSON extract never use the index?
Why does this SQL JSON extract never use the index. The SQL code queries JSON with JSON_EXTRACT. In MySQL that cannot use a regular index. In SQL use a generated column with an index.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqljsonextract #sqlindex #sq...
PrecisionSQL
Arne הס
Arne Hess 🫑
TKHUNT