Malformed schema in Windows since using sqlite 3.8.11.1
Getting malformed schema in Windows using the following schema code:
CREATE UNIQUE INDEX unique_vaccination ON immunizations (
child_id,
ifNull(immunization_type_id, '')
);
In linux, my app works, but in Windows it doesn't since SELECT sqlite_version();
shows that it's using 3.8.11.1. I tried to change the files with sqlite's latest amalgamated sources in libgda/sqlite/sqlite-src
and rebuild libgda-5.0
but it still retains the 3.8.11.1 version. How do I upgrade it?
Thanks for the help.
Edited by Shem Pasamba