Results for “syntax-differences”

Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.

PowerShell Windows patterns. Critical pitfalls, operator syntax, error handling.

Reference for test filter syntax across VSTest and MTP platforms, covering MSTest, NUnit, xUnit v3, and TUnit frameworks with examples and translation guidance.

Create, refresh, and rewrite PR titles and descriptions following Sentry conventions, focusing on reviewer-facing content that describes the full branch diff.

Compares two code versions for semantic equivalence by tracing both side-by-side, identifying divergences, and producing a structured verdict.

Write PHP following PSR coding standards, SOLID principles, and code-quality guidelines. Use for PHP style, design, refactoring, naming, and guard clauses—not Composer/PSR-4 project configuration.

Apply Optionals, Protocols, Extensions, and Type Safety patterns in Swift. Use when working with Swift Optionals, Protocols, Extensions, or type-safe APIs.

Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.

Runs three parallel reviewers to find code reuse, quality, and efficiency issues in a diff, then applies safe fixes and reports risky ones.

Type hints are checked by a separate tool (`mypy`, `pyright`), never by CPython

Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.

Generates unit tests for code changed in the current branch by comparing against origin/main and following existing test conventions.

野原新之助（子供向）认知与表达框架（压缩蒸馏）：五岁黄腔净版化、想象力、家庭温情 触发：蜡笔小新 等。全年龄净版

MySQL 与 MariaDB 的 Schema、查询、索引、事务、复制及连接池模式——面向数据库管理员与后端开发者

Explains MariaDB's REPLACE statement: its delete-then-insert behavior, when it triggers, data-loss risks, and the upsert alternative. Use when writing or reviewing REPLACE statements.

WP-CLI-first principle — use WP-CLI instead of generating PHP code whenever possible, with command reference, ACF seeding patterns, and environment-aware execution

Covers MariaDB-specific SELECT syntax and behavior, including optimizer hints, LIMIT extensions, row locking, temporal queries, and file output.

Language-specific super-code guidelines for swift.

Explains MariaDB-specific REVOKE syntax and behavior, including the five grammar forms, privilege requirements, error semantics, and role/proxy revocation nuances.

Apply core PHP language standards and modern 8.x features. Use when working with PHP 8.x features like enums, fibers, readonly properties, or named arguments.

Applies senior Python rules for typing, async, APIs, persistence, tests, packaging, and architecture.

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

SynthText: Synthetic Data for Text Detection

Analyzes a completed phase diff for high-confidence behavior-preserving simplifications and applies only explicitly approved proposals, reducing duplication, dead code, needless complexity, or avoidable inefficiency.