|
|
|
It was found that the commit of a SQL create index statement could fail with a WRITE_ERR error (37). A recent revision involving a call to the SECURITY() function caused an additional transaction entry to be added for an index member. When the transaction committed, it used the file control block of the index member rather than the index host, which resulted in the wrong file descriptor being used for the I/O.
The SECURITY() logic now checks if a call was made to set the file owner, group, or password for an index member, and If so, returns an FMOD_ERR error (48, operation incompatible with type of file). For c-treeDB alter table operations, including SQL index creations, the FMOD_ERR error is ignored allowing the SECURITY() function to effectively fail silently and the index creation operation completes without further error.
