Toad World® Forums

deviating formatting of column names list in materialized view

All,

I’m on toad 12.11.0.9.

When formatting a materialized view (as opposed to a normal view)
the list of column names gets formatted without any indentation.
Like this:

create materialized view wcsprdro.wcsprd_catentpart
(catentry_id
,partnumber
,shortdescription
,language_id
)

Is this fixable?

Kind regards,
Abe Kornelis

Hi Abe,

With default options I’m getting a “normal” formatting:

CREATE MATERIALIZED VIEW wcsprdro.wcsprd_catentpart
(
catentry_id,
partnumber,
shortdescription,
language_id
)

Otherwise could you paste me the options that you are using (formatter options -> top tab -> copy options buttion)

Thanks,
Andre

Andre,

This is the complete source file:
[View:/cfs-file/__key/communityserver-discussions-components-files/86/3377.wcsprd_5F00_catentpart.sql:320:240]

And this is my current set of formatting options:
[View:/cfs-file/__key/communityserver-discussions-components-files/86/6082.FmtPlus.txt:320:240]

But it’s a saved copy in my subversion.
The actual copy being used should be the same,
but I cannot validate right now since I seem to have
no access rights on this managed system :frowning:

Abe

Andre,

I fixed access, and there appears to be a minor difference.
Here’s a copy of the settings I’m actually using:

[View:/cfs-file/__key/communityserver-discussions-components-files/86/0211.FmtPlus.txt:320:240]

Kind regards,
Abe

Abe,

There was a bug where the parameter list of a materialized view was actually wrongly controlled by the CREATE TABLE list arrangement settings, rather than those of CREATE VIEW as should have been.

Thanks for reporting this issue,
Andre