General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Yeah, a bad habit it may be. That said, I had not seen an index on bintoc() fail neither, until yesterday
>
>Seems like I may be in for a change of habit after all, (I'm assessing the changes currently), until the index on Integer fails one day
>
>Still, I wonder, if bintoc() index fails under certain circumstances, there's a probability that an integer index will just as well. I'm just curious as to why and under what circumstances
>
I'm not sure 100%, but this is correlate with the CHR(0)
( C++ nullString endtag ) and the index string COMPACT routine.
If you define index with last key char = CHR(0) character, you can to meet this bug
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only