Sanket Sarang
Sanket Sarang
If a record has a sparce column, and the specific column is indexed but has a value of `null` in the current record, as that the column is missing in...
Add support for `CURRENT_DATE`, `CURRENT_TIME` and `CURRENT_TIMESTAMP` in SQL queries.
Today stored procedures communicate with the database using a TCP connection over the LAN. This connection is typically over `localhost` and is hence fast, but some time in lost in...
MD5 indexes will work exactly as BTree indexes. They are better suited than BTree indexes for String columns having large and complex data. The are used for exact searches only...
```SQL select * from test.test limit 1 ``` A simple limit query no longer works in version 1.7.10.
The `delete` query properly deletes the data, but retains the index entry for the deleted record. This causes `select distinct` to give inconsistent results. ``` delete from ds.collection where code...
In version 1.7.10, it is observed that when limiting a select to specific columns, the database occasionally misses a few records in the response. The following are logs for the...
The On-Disk Btree index does not delete the column value folder on an update operation, when post operation there are no more records present with the specific column value. This...
Index not getting updated on running an `UPDATE` SQL query to set a field that was not originally present on the record being updated. *Existing record* 1: `{'col1': 1, 'col2':...
The SelectActivityLog is used to compute the number of selects performed on a datastore. This information is used in BlobCity hosted cloud deployments for billing purposes. The feature requires an...