Skip to content

Oracle ignores function column when reflecting indexes, including sorted cols #9597

@CaselIT

Description

@CaselIT

Indexes like

Index("foo_idx", desc(column("x")))

reflect as no columns, since the columns that's reflected is a "system pseudocolumn" sync_nc that's ignored.

Fixing this does not seem too hard, since we now support expression index reflection and we can use ALL_IND_EXPRESSIONS to reflect these

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingoraclereflectionreflection of tables, columns, constraints, defaults, sequences, views, everything else

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions