Bug 336560 - Primary keys not imported from MDB files
Summary: Primary keys not imported from MDB files
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Migration/Import/Export (show other bugs)
Version: 2.9 Alpha
Platform: unspecified All
: NOR normal
Target Milestone: 2.9.11
Assignee: Jarosław Staniek
URL:
Keywords: bounty
Depends on: 277583
Blocks:
  Show dependency tree / graph
 
Reported: 2014-06-21 21:36 UTC by Jarosław Staniek
Modified: 2016-03-03 22:49 UTC (History)
0 users

See Also:
Latest Commit: http://commits.kde.org/kexi/5a2ab83ab935d3710ea9daa924427e75a833f247
Version Fixed In: 2.9.11

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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