Re: [review] [sqlite]

From: Dominique Devienne (ddevienne_at_[hidden])
Date: 2024-11-18 14:31:39

n Mon, Nov 18, 2024 at 1:09 PM Klemens Morgenstern
<klemensdavidmorgenstern_at_[hidden]> wrote:
> On Mon, Nov 18, 2024 at 6:10 PM Dominique Devienne <ddevienne_at_[hidden]> wrote:
>> On Mon, Nov 18, 2024 at 10:34 AM Klemens Morgenstern via Boost
>> <boost_at_[hidden]> wrote:
>> > On Mon, Nov 18, 2024 at 1:03 AM Barend Gehrels via Boost <boost_at_[hidden]> wrote:
>> > > One of its columns is typed geometry
>> > This is probably a subtype, which would make a great example for custom
>> > conversions. Are you using spatialite?
>> The notion of subtype [4] exist in SQLite, but is very *transient*.

> It would be good to have an example explaining what you just said, because I certainly fell for the subtype gotchas in the past.

https://sqlite.org/forum/forum?s=subtype in general,
and https://sqlite.org/forum/forumpost/340b2fde7a30de50bf3189d6813289f80e6462132a84395804b84ce0dae4e984
in particular for the fact subtypes from views are lost. --DD