insert sometimes doesn't insert anything
Posted: Mon Sep 09, 2019 5:02 pm
This might have to be just a heads up to begin with. I can't give a specific example at this time because the examples where this bug is hitting me are too complex.
Sometimes, when I give an INSERT command, with a complex expression as source and a target of existing high cardinality, the operation appears to work, telling me how many tuples have been inserted, but I find that none of them have been inserted at all. For example, repeating the same operation tells me the same number have been inserted when it should now be saying zero have been inserted.
In the database where this problem arises I notice that there are a large number of files with names like 00000123.jdb and I am guessing these are where my data is actually stored. I'm wondering if the bug is somehow connected with when new .jdb files need to be created.
Perhaps the bug can be found by code inspection. If not, I'll have to provide a .zip file along with a specific example.
Hugh
Sometimes, when I give an INSERT command, with a complex expression as source and a target of existing high cardinality, the operation appears to work, telling me how many tuples have been inserted, but I find that none of them have been inserted at all. For example, repeating the same operation tells me the same number have been inserted when it should now be saying zero have been inserted.
In the database where this problem arises I notice that there are a large number of files with names like 00000123.jdb and I am guessing these are where my data is actually stored. I'm wondering if the bug is somehow connected with when new .jdb files need to be created.
Perhaps the bug can be found by code inspection. If not, I'll have to provide a .zip file along with a specific example.
Hugh