[CB-12822] Bug when create an virtual table with fts3 option in the Websql database on UiWebview

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: cordova-ios@4.3.1
• Component/s: cordova-ios
• Labels: performance

Environment

UIWebview Websql database

• Assignee: Unassigned
• Reporter: David Saillard
• Created: 16/May/17 08:37
• Updated: 23/Aug/18 06:43
• Resolved: 07/Jun/17 06:06

Description

Hello,
I develop software with cordova, since 6 years, and actually use the UiWebview with the Websql database because he WkWebview don't use this.

When I execute an transaction for create a virtual table with the option fts3. The query return an error and the table is not create.

When I dont' use the option fts3 for create an normal table, it's OK. I have success operation.

This Problem doesn't exist on iOS 10.3.1 and before.
Steps to Reproduce:
CREATE VIRTUAL TABLE IF NOT EXISTS param USING fts3 ( soc_code VARCHAR(5), prm_table VARCHAR(50), prm_coderec VARCHAR(50), prm_lbl VARCHAR(70), prm_comment VARCHAR(200), prm_actif VARCHAR(1), prm_value VARCHAR(50), prm_order INTEGER, INDEX_PAGINATION INTEGER ) ";

Version:
iOS 10.3.2 beta5

Notes:
I can use in my application Virtual table previously create before upgrade on iOS 10.3.2 beta5. That mean that it's supported, only the creat doesn't run.

Configuration:
ipad air2 64go