search

crate / crate-benchmarks

A collection of CrateDB benchmarks.
8 stars 4 forks source link

rnd_queries: Use unix_time for timestamp value generation #165

Closed mfussenegger closed 6 years ago

mfussenegger commented 6 years ago

The change in cr8 https://github.com/mfussenegger/cr8/commit/3ef2040dd49eeeee4937f2e35d368e1e15651313 broke the value generation for timestamps, leading to queries like this:

SELECT count(*) FROM \"benchmarks\".\"query_tests\" WHERE 2016-08-20
23:16:44 >= ANY (\"atimestamp\") AND \"slong\" <= -3771834702135012260
AND \"stimestamp\" != 2017-02-19 23:43:01;