Ticket #620 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

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

Change History

Changed 3 years ago by romicadascalescu

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.