Problems with unique fields with SQLite on Android

[friedel]

I get an exception when connecting to a SQLite database on Android (UniDAC 7.3.9). I use "unique" id fields in several tables. When I remove the "unique" markers, everything works fine. When I replace the unique fields in the tables by separate unique indexes, everything works fine. Same database file on Windows works fine.

Seems to be a bug... Any ideas?

[MaximG]

To investigate the issue, please compose and send us a small sample, execution of which causes this issue, including test DB, using via the e-support form ( https://www.devart.com/company/contactform.html )

[friedel]

The problem occurs on a Lenovo TAB 2 A8-50 (Android 5.1) and a Samsung Galaxy Tab 4 7.0 (SM-T235, Android 5.1.1). No problems on any other of my devices, all with newer Android versions. Maybe a problem with Android 5.1?

Delphi version 10.2.3, UniDAC version 7.3.9. SQLite database file was built with "DB Browser for SQLite" version 3.10.1.

Unfortunately I only get an exception "segmentation fault", no further error message or hint.

Sample project sent via e-mail, ticket ID 262173.

[MaximG]

We will check the performance of the application on Android 5.x you sent and let you know about the results in the near future.