Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DATABASECHANGELOG_DETAILS invalid after initial SQLcl Project deploy on clean environment

sscsMay 25 2026 — edited May 25 2026

SQLcl versions 26.1.0 and 26.1.2 produces the below invalid view on project deploy onto my version 19.24.0.0.0 clean environment (empty schema). Column names appear as both lowercase and uppercase, leading to ORA-00957: duplicate column name.

CREATE OR REPLACE VIEW DATABASECHANGELOG_DETAILS AS
SELECT da.deployment_id,
      da.id,
      da.author,
      da.filename,
      da.sequence,
      da.dateexecuted,
      da.status,
      da.md5sum,
      da.description,
      da.comments,
      d.liquibase,
      da.contexts,
      da.labels,
      da.sql,
      da.sxml,
      da.EXECTYPE,
      da.DESCRIPTION,
      da.COMMENTS,
      da.TAG,
      da.CONTEXTS,
      da.LABELS
 FROM MYSCHEMA.DATABASECHANGELOG d
 LEFT JOIN MYSCHEMA.DATABASECHANGELOG_ACTIONS da
   ON d.id = da.id
  AND d.author = da.author
  AND d.filename = da.filename
ORDER BY 1, 7;

(Formatted for readability)

Comments
Post Details
Added on May 25 2026
4 comments
164 views