View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006901 | VCOMPONENT-VKERNEL | Indexes | public | 2014-07-28 06:47 | 2014-08-11 06:34 |
Reporter | Ruslan Zasukhin | Assigned To | Ruslan Zasukhin | ||
Priority | normal | Severity | feature | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Platform | ALL | OS | ALL | OS Version | ALL |
Product Version | 5.6 | ||||
Target Version | 5.6 | Fixed in Version | 5.6 | ||
Summary | 0006901: [NEW] Hash Indexes for String, VarChar, Binary, VarBinary fields. | ||||
Description | This feature allows to produce hash-index, which keeps 4-bytes hash value of a string or binary value. Works on SQL and API level. ==== Cons ==== * Index can be Unique or NotUnique. * Can be used for strings of any length. This allow break limit in 256-bytes strings in index of Valentina engine before that. * Index is much smaller. ==== Cons ==== * Allowed only operations 'EQUAL' and 'NOT EQUAL'. | ||||
Tags | No tags attached. | ||||
duplicate of | 0001164 | resolved | Ruslan Zasukhin | Provide a EVFlags.fIsHashed flag for enabling hashed indexing of VarChar, String, and Blob Text Fields. |
child of | 0004636 | resolved | Ruslan Zasukhin | Unique indexing on large strings produces unexpected duplicate key errors |
Date Modified | Username | Field | Change |
---|---|---|---|
2014-07-28 06:47 | Ruslan Zasukhin | New Issue | |
2014-07-28 06:47 | Ruslan Zasukhin | Status | new => assigned |
2014-07-28 06:47 | Ruslan Zasukhin | Assigned To | => Ruslan Zasukhin |
2014-07-28 06:48 | Ruslan Zasukhin | Relationship added | duplicate of 0001164 |
2014-07-28 06:48 | Ruslan Zasukhin | Relationship added | child of 0004636 |
2014-07-28 06:50 | Ruslan Zasukhin | Target Version | 6.0 => 5.6 |
2014-08-11 06:34 | Ruslan Zasukhin | Note Added: 0007880 | |
2014-08-11 06:34 | Ruslan Zasukhin | Status | assigned => resolved |
2014-08-11 06:34 | Ruslan Zasukhin | Fixed in Version | => 5.6 |
2014-08-11 06:34 | Ruslan Zasukhin | Resolution | open => fixed |