Forum Stats

  • 3,874,178 Users
  • 2,266,677 Discussions
  • 7,911,757 Comments

Discussions

lb update seems to retain source schema name

user10310346
user10310346 Member Posts: 3 Green Ribbon

Hi,

I have been looking at the new sqlcl 22.3.1 Wondering if anyone else has come across this or I am doing something stupid.

When issuing lb update command fails with insufficient privileges, debug option indicates schema name is in the sql statement when the default should be false for including qualified schema name.

08:49:05 16:12:54 SQL> lb update -changelog-file controller.xml -debug true

Parameters

---------------------------------------------

basecommand=lb debug=true changelog-file=controller.xml log=false secure-parsing=true output-default-schema=false command=update

---------------------------------------------

End Parameters

--Starting Liquibase at 08:49:16 (version 4.15.0 #0 built at 2022-08-19 14:45+0000)

-- Loaded 2 change(s)

Running Changeset: controller.xml::1666774106323-1::xxxx (generated)

liquibase.exception.MigrationFailedException: Migration failed for changeset controller.xml::1666774106323-1::xxxx (generated):

   Reason: liquibase.exception.DatabaseException: ORA-01031: insufficient privileges

 [Failed SQL: (1031) CREATE TABLE TEST.T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS]

Migration failed for changeset controller.xml::1666774106323-1::xxxx (generated):

   Reason: liquibase.exception.DatabaseException: ORA-01031: insufficient privileges

 [Failed SQL: (1031) CREATE TABLE TEST.T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS]

ORA-01031: insufficient privileges

08:49:19 16:12:54 SQL> sho user

USER is "TEST2"

08:49:36 16:12:54 SQL>

When the sql above is run without schema name, table creates ok:

08:51:00 16:12:54 SQL> CREATE TABLE T1 (ID NUMBER, ITEM_NO NUMBER(6, 0), ITEM_DESC VARCHAR2(100 CHAR)) TABLESPACE USERS;

Table T1 created.

Elapsed: 00:00:00.030

08:51:13 16:12:54 SQL> sho user

USER is "TEST2"


I am running sqlcl on Windows

Thanks