Query with where & order always resolves with empty result

[dave-trudes]

Hi there, I'm using ydn at version 1.1.2 and have following schema:

stores: [{
  name: 'data',   
  keyPath: 'id',
  type: 'NUMERIC',

  indexes: [
    {
       name: 'status',
       keyPath: 'status',
        type: 'NUMERIC'
    },
    {
       name: 'status, location.name',
       keyPath: ['status', 'location.name']
     }
   ]
}]

// Insert values
db.put(data, [...])

After inserting values, the 'status, location.name' table is populated accordingly. If I then want to execute the following query, the promise always resolves empty.

db.from("data")
  .where("status", "=", 2)
  .order('location.name', true)
  .list()
  .done(resolve).fail(reject);

[yathit]

It looks ok. Could you post runnable code in jsbin?

Thanks

[dave-trudes]

Thank you for your quick reply. Here is the jsbin: http://jsbin.com/cewexewome/edit?js,console,output

[nevech]

I have the same problem if my store have indexes and used localstorage driver.

Test case:

• db.put(data)
• db.values('store')

Returns data without the first operation, but table is populated.

If used indexedDB driver then it work.

[yathit]

Thanks @dave-trudes please update to 1.1.5 for this fix.

@nevech websql and localStorage adaptor are still failing some tests with compound index. I will fix later.