Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.1.0
-
None
-
2017-7, 2017-8
Description
At the moment for INSERT_SELECT and LDI we turn the row format into csv and pipe into cpimport. This piping only has a 1MB csv row buffer. BLOB lengths are doubled due to hexing so at most you can fit a single 512KB BLOB in a row before things error.
The DML commands don't realise something is wrong until the end of the bulk import. The table remains locked afterwards and needs manual unlocking.
I believe the best way to fix this is to have a row length counter which spots this and errors appropriately as well as having a configurable buffers size for the row.
Alternatively it might be possible to make the row buffer grow with the content.
Attachments
Issue Links
- relates to
-
MCOL-267 TEXT and BLOB data types are not supported
- Closed