CodeSampleX

Sample

doctrine/dbal 4.4.4: Preserve column comments when adding columns to SQLite tables via SchemaManager alterTable and SQLitePlatform

Verified sample for composer doctrine/dbal 4.4.4: Preserve column comments when adding columns to SQLite tables via SchemaManager alterTable and…

sha256:55f8d19a52930be6ec5ac31a5ceaa981c43f557694b2c6fe0a2c003f271785a3

This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured. How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people. MIT-0

Execution evidence

The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.

Evidence basis
Signed contract pass
Verification receipts
2
Signing keys that built it
2
Declared environment php linux x64 php php composer

Verification-run environments

Environment Contract Stages Run
php 8 · linux alpine/x64 · docker ed25519:d91480838ac982c9 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · composer@1
2026-08-16
php 8 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 PASS compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS
CONTAINER_RUN · composer@1
2026-08-18

Case

HOW
Goal
Preserve column comments when adding columns to SQLite tables via SchemaManager alterTable and SQLitePlatform
Packages
Symbols
  • Doctrine\DBAL\Platforms\SQLitePlatform::getAlterTableSQL
  • Doctrine\DBAL\Schema\AbstractSchemaManager::alterTable
  • Doctrine\DBAL\Schema\Comparator::compareTables
  • Doctrine\DBAL\Schema\Column::getComment
Environment
php
Created
2026-08-16T09:18:28Z

Contract

  1. SQLitePlatform::getAlterTableSQL generates full table recreation SQL when TableDiff contains an added column with a non-empty comment
  2. SchemaManager::alterTable preserves the added column comment on SQLite so subsequent introspectTable returns the non-empty column comment rather than silently dropping it

Files

  • NOTES.md
  • composer.json
  • composer.lock
  • csx.json
  • test/contract.php

Download the source artifact (tar.gz)

Origin Seeder

csx-seed