Tagged articles
implicit conversion
23 articles · Page 1 of 1
This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.
CTEMySQLPagination
0 likes · 16 min read

The article explains Java's type conversion mechanisms, covering implicit (automatic) conversion, explicit (forced) casting, and numeric promotion, with detailed rules, common pitfalls, code examples, and practical tips for safe and correct usage in everyday development.
Type Conversionexplicit castingimplicit conversion
0 likes · 22 min read

An ORM parameter type mismatch caused MySQL to perform implicit conversion on a VARCHAR index column, turning an indexed query into a full table scan that saturated connection pools, thread pools, Kafka consumers, and upstream services during a high‑traffic promotion, illustrating the full‑stack impact and remediation steps.
Index OptimizationMyBatisMySQL
0 likes · 29 min read

The article explains how Go’s untyped constants act as a hidden privilege, allowing compile‑time high‑precision calculations without overflow, implicit type adaptation, and reduced boilerplate, while contrasting them with typed variables and discussing design trade‑offs and default type pitfalls.
GoType SystemUntyped Constants
0 likes · 9 min read

This article explains how implicit type conversion can silently invalidate database indexes, outlines the underlying rules and type‑precedence logic, provides real‑world MySQL examples, shows how to detect the issue with EXPLAIN, and offers concrete best‑practice solutions.
Index OptimizationMySQLSQL
0 likes · 10 min read

This article explains how MySQL's implicit type conversion during table joins can render indexes unusable or alter join order, and provides practical solutions such as aligning column types, using optimizer hints, and forcing indexes to restore query performance.
MySQLOptimizer Hintsforce index
0 likes · 6 min read

A production MySQL service crashed due to a BIT(1) status column being compared with a string in an indexed query, revealing how implicit type conversion and index usage can cause unexpected bugs and how removing the offending index quickly resolved the issue.
IndexMySQLSQL debugging
0 likes · 7 min read

The article explains how an unexpected MySQL index interaction with a BIT column and implicit type conversion caused a production outage, details the investigation steps, presents the problematic SQL and table schema, and offers a quick fix by removing the offending index.
BIT TypeDatabase DebuggingIndex
0 likes · 6 min read

This article explains JavaScript's explicit and implicit type conversions, demonstrates how to use constructors and methods like String(), Number(), Boolean(), toString(), parseInt(), details falsy and truthy values, and shows practical applications of Boolean in conditional statements, array filtering, and TypeScript.
Explicit ConversionJavaScriptType Conversion
0 likes · 7 min read


大转转FEAug 2, 2024 · Fundamentals
This article examines JavaScript’s implicit type conversion mechanisms, illustrating a quirky yet functional code example, detailing conversion rules for symbols, objects, arrays, numbers, booleans, and undefined/null, and highlighting common pitfalls and practical coding tricks.
JSFuckJavaScriptType Coercion
0 likes · 11 min read


ITPUBJun 30, 2024 · Databases
This article explains how implicit type conversions in PostgreSQL can cause index loss, drastically misestimate row counts, and force inefficient join strategies, illustrating the issue with concrete examples, detailed execution plans, and step‑by‑step optimizations that restore index usage and boost performance thousands of times.
Index OptimizationPerformance TuningPostgreSQL
0 likes · 13 min read

This article explains how MySQL performs implicit type conversion during queries, demonstrates the unexpected results caused by joining mismatched column types, outlines the conversion rules, and provides practical tips to avoid performance degradation and incorrect data retrieval.
MySQLSQLimplicit conversion
0 likes · 10 min read

This article explains JavaScript’s explicit and implicit type conversion mechanisms—including Number(), String(), Boolean(), toString and valueOf—through detailed code examples and clarifies puzzling expressions like [] == ![] and {} == !{}.
JavaScriptStringType Conversion
0 likes · 10 min read
![Why Does [] == ![] Evaluate to True? Unraveling JavaScript Type Conversion](https://wsrv.nl/?url=http%3A%2F%2Fmmbiz.qpic.cn%2Fmmbiz_jpg%2FRqbfwXSnN36SNZjGLThuBmzjNwkyHE0kictB4jLqERv8uQox3mpkib38pwk0XzOCRicfFRGh89iaSx9OoL3PO02vnQ%2F0%3Fwx_fmt%3Djpeg)
This article explains how MySQL implicitly converts mismatched column types—such as comparing a VARCHAR column with a numeric literal—into floating‑point numbers, causing seemingly equal values to match, losing index usage, and potentially producing incorrect query results.
MySQLType Conversionfloating-point
0 likes · 7 min read

This article examines how misplaced quotation marks in MySQL UPDATE statements can unintentionally set fields to zero, explains MySQL’s implicit type conversion that causes the condition to always evaluate true, and offers practical steps for detecting and preventing such bugs.
MySQLSQLUpdate Statement
0 likes · 6 min read

This article explains how incorrect placement of quotation marks in MySQL UPDATE statements can cause the SET values to be evaluated as boolean expressions, leading to implicit type conversion that updates fields to zero, and offers practical steps to prevent such errors.
Database ErrorsMySQLQuotation Marks
0 likes · 5 min read

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.
MySQLSQLUpdate
0 likes · 6 min read

This article explains why a MySQL join query may ignore an index because of implicit character‑set conversion, demonstrates how to diagnose the issue with EXPLAIN and schema queries, and provides a fix by converting the column to UTF8 in the SQL statement.
IndexMySQLSQL
0 likes · 4 min read

This article explains how incorrectly placed double‑quotation marks in MySQL UPDATE and SELECT statements cause implicit type conversion, turning intended string assignments into zero values and making WHERE clauses always true, leading to massive data corruption and unexpected query results.
MySQLQuotation MarksSQL
0 likes · 7 min read

A developer’s production update accidentally set every row’s source_name to 0 because misplaced double‑quotation marks altered the SQL semantics, and the article explains how MySQL interprets such malformed statements and how to recover the data.
Database DebuggingQuotation MarksSQL
0 likes · 6 min read


ITPUBDec 21, 2018 · Databases
A developer ran a series of UPDATE statements that appeared correct, but due to misplaced double‑quotation marks the WHERE clause was parsed incorrectly, causing every row's column to be set to 0; the article explains MySQL's expression evaluation, shows binlog analysis, and offers practical debugging tips.
MySQLSQLUpdate
0 likes · 7 min read

This article explains JavaScript's type coercion mechanisms, covering both implicit and explicit conversions for strings, numbers, booleans, objects, and symbols, and demonstrates how abstract operations like ToPrimitive, ToString, ToNumber, and ToBoolean affect runtime behavior.
ES5Explicit ConversionJavaScript
0 likes · 17 min read

This article demystifies JavaScript currying by first exploring function implicit conversion, then showing how to wrap Array.map with call/apply, and finally presenting practical currying implementations and their characteristics for clearer, more flexible code.
CurryingFunction__call__
0 likes · 9 min read
