jsonSQL
jsonSQL copied to clipboard
Number comparison doesn't return correct values
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.