Opened 15 years ago
Closed 15 years ago
#620 closed defect (fixed)
SQLite - avoid cache well defined views.
Reported by: | romicadascalescu | Owned by: | romicadascalescu |
---|---|---|---|
Priority: | major | Milestone: | 3.6.0 |
Component: | SQLite Provider | Version: | 3.5.0 |
Severity: | 3 | Keywords: | |
Cc: | External ID: |
Description
There are cases when views are simple views and SQLite provider can detect the main class and use the spatial index of the main class. Rules:
- Table and main property names needs to be provided in a case sensitive way.
- Primary Key of the view needs to be added in fdo_columns as read-only (fdo_data_details = 0x02)
- All not well defined property of the view need to be added in fdo_columns providing the right type (e.g. 'test' as TEST_COL).
- The geometry property of the view needs to be added in geometry_columns
Note:
See TracTickets
for help on using tickets.