Bug 336560

Summary:	Primary keys not imported from MDB files
Product:	[Applications] KEXI	Reporter:	Jarosław Staniek <staniek>
Component:	Migration/Import/Export	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED FIXED
Severity:	normal	Keywords:	bounty
Priority:	NOR
Version:	2.9 Alpha
Target Milestone:	2.9.11
Platform:	unspecified
OS:	All
Latest Commit:	http://commits.kde.org/kexi/5a2ab83ab935d3710ea9daa924427e75a833f247	Version Fixed In:	2.9.11
Sentry Crash Report:
Bug Depends on:	277583
Bug Blocks:

Description Jarosław Staniek 2014-06-21 21:36:32 UTC

Primary keys not imported from MDB.

A hint: a copy of mdbtools should be updated, in particular mdb_read_indices() would be fixed this way:
https://github.com/brianb/mdbtools/commit/be2a287f5c5d9cb78c103f9d98a74ea6cd055311

Comment 1 Jarosław Staniek 2016-01-23 00:15:24 UTC

In review, Northwind database imports properly importes with keys, e.g. from
http://www.2013.net/courses/access/

Comment 2 Jarosław Staniek 2016-01-26 01:27:09 UTC

Finally, the fix has been donated by me.

Comment 3 Jarosław Staniek 2016-02-29 23:36:07 UTC

Git commit 5a2ab83ab935d3710ea9daa924427e75a833f247 by Jaroslaw Staniek.
Committed on 29/02/2016 at 23:07.
Pushed by staniek into branch 'master'.

MDB Import: Update to mdbtools from June 2014
Related: bug 277583

This also fixes primary keys import

FIXED-IN:2.9.11

Test Plan: Northwind database imports properly with keys, try e.g. from http://www.2013.net/courses/access/

Differential Revision: https://phabricator.kde.org/D855

(from calligra.git)

M  +92   -38   src/migration/mdb/3rdparty/mdbtools/include/mdbtools.h
M  +53   -18   src/migration/mdb/3rdparty/mdbtools/libmdb/catalog.c
M  +201  -131  src/migration/mdb/3rdparty/mdbtools/libmdb/data.c
M  +19   -1    src/migration/mdb/3rdparty/mdbtools/libmdb/dump.c
M  +132  -12   src/migration/mdb/3rdparty/mdbtools/libmdb/file.c
M  +41   -21   src/migration/mdb/3rdparty/mdbtools/libmdb/iconv.c
M  +122  -78   src/migration/mdb/3rdparty/mdbtools/libmdb/index.c
M  +3    -4    src/migration/mdb/3rdparty/mdbtools/libmdb/like.c
M  +13   -8    src/migration/mdb/3rdparty/mdbtools/libmdb/map.c
M  +9    -34   src/migration/mdb/3rdparty/mdbtools/libmdb/mem.c
M  +53   -24   src/migration/mdb/3rdparty/mdbtools/libmdb/money.c
M  +22   -22   src/migration/mdb/3rdparty/mdbtools/libmdb/options.c
A  +215  -0    src/migration/mdb/3rdparty/mdbtools/libmdb/props.c     [License: LGPL (v2+)]
M  +53   -8    src/migration/mdb/3rdparty/mdbtools/libmdb/sargs.c
A  +77   -0    src/migration/mdb/3rdparty/mdbtools/libmdb/stats.c     [License: LGPL (v2+)]
M  +86   -39   src/migration/mdb/3rdparty/mdbtools/libmdb/table.c
M  +3    -3    src/migration/mdb/3rdparty/mdbtools/libmdb/worktable.c
M  +113  -78   src/migration/mdb/3rdparty/mdbtools/libmdb/write.c
D  +0    -7    src/migration/mdb/3rdparty/mdbtools/update_diffs.sh
M  +4    -0    src/migration/mdb/ChangeLog
M  +6    -1    src/migration/mdb/src/CMakeLists.txt
M  +6    -21   src/migration/mdb/src/keximdb/mdbmigrate.cpp
M  +1    -4    src/migration/mdb/src/keximdb/mdbmigrate.h

http://commits.kde.org/kexi/5a2ab83ab935d3710ea9daa924427e75a833f247