creating-oracle-to-postgres-migration-bug-report

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Chinese

Documenting a defect caused by behavioral differences between Oracle and PostgreSQL
Writing or reviewing a bug report for an Oracle-to-PostgreSQL migration project

Use the template in references/BUG-REPORT-TEMPLATE.md. Each report must include:

Status: ✅ RESOLVED, ⛔ UNRESOLVED, or ⏳ IN PROGRESS
Component: Affected endpoint, repository, or stored procedure
Test: Related automated test names
Severity: Low / Medium / High / Critical — based on impact scope
Problem: Expected Oracle behavior vs. observed PostgreSQL behavior
Scenario: Ordered reproduction steps with seed data, operation, expected result, and actual result
Root Cause: The specific Oracle/PostgreSQL behavioral difference causing the defect
Solution: Changes made or required, with explicit file paths
Validation: Steps to confirm the fix on both databases

使用references/BUG-REPORT-TEMPLATE.md中的模板。每份报告必须包含：

Oracle is the source of truth — frame expected behavior from the Oracle baseline
Call out data layer nuances explicitly: empty string vs. NULL, type coercion strictness, collation, sequence values, time zones, padding, constraints
Client code changes should be avoided unless required for correct behavior; when proposed, document and justify them clearly

Plain language, short sentences, clear next actions
Present or past tense consistently
Bullets and numbered lists for steps and validations
Minimal SQL excerpts and logs as evidence; omit sensitive data and keep snippets reproducible
Stick to existing runtime/language versions; avoid speculative fixes

Save bug reports as

BUG_REPORT_<DescriptiveSlug>.md

where

<DescriptiveSlug>

is a short PascalCase identifier (e.g.,

EmptyStringNullHandling

RefCursorUnwrapFailure

Bug报告保存为

BUG_REPORT_<DescriptiveSlug>.md

，其中

<DescriptiveSlug>

为简短的PascalCase标识符（例如：

EmptyStringNullHandling

、

RefCursorUnwrapFailure

）。