View Issue Details

IDProjectCategoryView StatusLast Update
0006901VCOMPONENT-VKERNELIndexespublic2014-08-11 06:34
ReporterRuslan Zasukhin Assigned ToRuslan Zasukhin  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version5.6 
Target Version5.6Fixed in Version5.6 
Summary0006901: [NEW] Hash Indexes for String, VarChar, Binary, VarBinary fields.
DescriptionThis 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'.


TagsNo tags attached.

Relationships

duplicate of 0001164 resolvedRuslan Zasukhin Provide a EVFlags.fIsHashed flag for enabling hashed indexing of VarChar, String, and Blob Text Fields. 
child of 0004636 resolvedRuslan Zasukhin Unique indexing on large strings produces unexpected duplicate key errors 

Issue History

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