Current Schema in Liquibase valueComputed Field
I Have an as Part of a Changeset. However When Using valueComputed I'd Like to Be Able to Refer to the Current Scheme. Because at the Moment I Have This: and...
I have an as part of a changeset. However when using valueComputed I'd like to be able to refer to the current scheme. Because at the moment I have this:
<update tableName="foo">
<column name="name" valueComputed="(select b.name from bar b where baz.id = b.id)" />
</update>
And the issue is that the generated SQL is something like this:
UPDATE some_scheme.foo SET name = (select b.name from bar b where baz.id = b.id)
Notie that the generated update has some_scheme attached to it, and I'd like to be able to access this in my valueComputed field. Is that possible?