jsonSQL icon indicating copy to clipboard operation
jsonSQL copied to clipboard

Number comparison doesn't return correct values

Open Tomino2112 opened this issue 8 years ago • 0 comments

Hi, It seems that number comparison doesnt work properly?

Here is the db data:

[ { _rowId: 1,
    symbol: 'PFE',
    '': '▼',
    last_sale_price: 32.23,
    last_sale_size: 100,
    volume: 337205,
    last_sale_time: '18:25:00',
    company_name: 'Pfizer Inc' },
  { _rowId: 2,
    symbol: 'S',
    '': '▲',
    last_sale_price: 7.835,
    last_sale_size: 100,
    volume: 199229,
    last_sale_time: '18:25:21',
    company_name: 'Sprint Corp' },
  { _rowId: 3,
    symbol: 'SLB',
    '': '▼',
    last_sale_price: 71.485,
    last_sale_size: 100,
    volume: 143878,
    last_sale_time: '18:24:50',
    company_name: 'Schlumberger Ltd' } ]

Query:

* where last_sale_price>40

Result:

[ { _rowId: 2,
    symbol: 'S',
    '': '▲',
    last_sale_price: 7.835,
    last_sale_size: 100,
    volume: 199229,
    last_sale_time: '18:25:21',
    company_name: 'Sprint Corp' },
  { _rowId: 3,
    symbol: 'SLB',
    '': '▼',
    last_sale_price: 71.485,
    last_sale_size: 100,
    volume: 143878,
    last_sale_time: '18:24:50',
    company_name: 'Schlumberger Ltd' } ]

Obviously the _rowId: 2 which has last_sale_price: 7.835 should not be in results. I cannot figure out why it is.

Tomino2112 avatar Jul 20 '17 10:07 Tomino2112