Function normalizePartitionBound

packages/sql/src/schema/partitioning.ts:292–314

(value: string)

/** @internal */
export function normalizePartitionBound(value: string): string {
  const normalized = normalizeWhitespace(value);

  if (!normalized) {
    return '';
  }

  if (/^default$/i.test(normalized)) {
    return 'default';
  }

  // Prepend `for values` if the caller passed a bare `with/in/from … to …` clause, then lowercase
  // PG bound keywords outside quoted literals (so `FROM (MINVALUE) TO ('hello TO world')` becomes
  // `from (minvalue) to ('hello TO world')` with the inner TO inside the literal preserved).
  // PG's `pg_get_expr` emits `MINVALUE`/`MAXVALUE`/`NULL` in uppercase, so case-folding them here
  // prevents a perpetual diff against user-supplied lowercase bounds.
  const prefixed = /^for values\b/i.test(normalized) ? normalized : `for values ${normalized}`;
  const lowered = mapOutsideLiterals(prefixed, segment =>
    segment.replace(PARTITION_BOUND_KEYWORDS, match => match.toLowerCase()),
  );

  return normalizePartitionSqlFragment(lowered);
}

const createPartitionBound = (value: string): string => normalizePartitionBound(value);