JetBrains / JetBrains/Exposed

Provide a way to define primary and secondary XML Indexes

Open
#1,624 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Kotlin
Stars
9.3k
Forks
798
Avg merge
4d 2h
Merged PRs (30d)
26

Description

Exposed currently has no way to define xml indexes in MS SQL Server.

E.g:

```
CREATE PRIMARY XML INDEX [primary_xml_index_name] ON [table_name]([xml_column_1])

CREATE XML INDEX secondary_xml_index_name ON [table_name]([xml_column_1]) USING XML INDEX [primary_xml_index_name] FOR VALUE
```

Secondary xml indexes can be on PATH, VALUE, or PROPERTY
Documentation at [XML Indexes](https://learn.microsoft.com/en-us/sql/relational-databases/xml/xml-indexes-sql-server?view=sql-server-ver16)

Note: a probable fix is to allow a listOf < DdlAware > objects to be added ad-hoc to a Table and have run after the table is created. The Index class is defined as a data class which prohibits subclassing.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.