Re: [sqlite] FTS - IF NOT EXISTS missing from sqlite_master

On 8/19/18, Daniel Santiago wrote: > Hi, > > It seems that when creating a virtual table the 'IF NOT EXISTS' part is > missing from the sql column in sqlite_master for the recently created table > entry. > > For example: > sqlite> CREATE VIRTUAL TABLE IF NOT EXISTS `Mail` USING FTS4(`subject`, > `

[sqlite] FTS - IF NOT EXISTS missing from sqlite_master

Hi, It seems that when creating a virtual table the 'IF NOT EXISTS' part is missing from the sql column in sqlite_master for the recently created table entry. For example: sqlite> CREATE VIRTUAL TABLE IF NOT EXISTS `Mail` USING FTS4(`subject`, `body`); sqlite> SELECT `sql` FROM `sqlite_master` WH