summaryrefslogtreecommitdiff
path: root/Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua
diff options
context:
space:
mode:
Diffstat (limited to 'Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua')
-rw-r--r--Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua13
1 files changed, 6 insertions, 7 deletions
diff --git a/Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua b/Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua
index cf4a3a8b04d..04d5ced3a25 100644
--- a/Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua
+++ b/Master/texmf-dist/tex/context/base/mkiv/util-sql-imp-sqlite.lua
@@ -132,6 +132,7 @@ setmetatable(cache, {
local f_preamble = formatters[ [[
ATTACH `%s` AS `%s` ;
PRAGMA `%s`.synchronous = normal ;
+PRAGMA journal_mode = truncate ;
]] ]
local function execute(specification)
@@ -210,19 +211,17 @@ local function execute(specification)
else
local column = { }
callback = function(data,nofcolumns,values,fields)
- for i=1,nofcolumns do
+ for i=0,nofcolumns-1 do
local field
if keysdone then
- field = keys[i]
+ field = keys[i+1]
else
-- field = get_list_item(fields,i)
- field = ffi_tostring(fields[i-1])
+ field = ffi_tostring(fields[i])
keys[i+1] = field
end
- if field then
- -- column[field] = get_list_item(values,i)
- column[field] = ffi_tostring(values[i-1])
- end
+ -- column[field] = get_list_item(values,i)
+ column[field] = ffi_tostring(values[i])
end
nofrows = nofrows + 1
keysdone = true