#7263 added (belatedly) on gitbhub 7263 https://github.com/influxdata/influxdb/issues/7263
cheers, Ian On Tuesday, 30 August 2016 05:28:56 UTC+10, Sean Beckett wrote: > > This is not an issue I recall seeing before. Please open a bug report on > the repo: https://github.com/influxdata/influxdb/issues/new. > > On Sun, Aug 28, 2016 at 8:57 PM, ian lutz <[email protected] <javascript:>> > wrote: > >> Hi All. Please observe the below, it looks like i have hit a bug. Anyone >> else getting this ? >> >> both dbs have the same data in it. >> >> On v1-rc1 and on v13 we get this: (the same for both) -> CORRECT >> >> >> >> SELECT "time", value_EIGAI, status FROM "egtesta-c1" WHERE "time" <= >> 1453679990000ms ORDER BY time DESC LIMIT 1 >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1453676400000000000 -23.087604422453467 OK >> >> >> >> >> >> now, lets try and query for another measurement as well: >> >> >> >> for v1-rc1 we get this, which is the bug: -> we are getting more results >> than we expect. We expect a result for each measurement. -> INCORRECT >> >> > SELECT "time", value_EIGAI, status FROM "egtesta-c1", "egtesta-a1" >> WHERE "time" <= 1453679990000ms ORDER BY time DESC LIMIT 1 >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1453676400000000000 -23.087604422453467 OK >> >> name: egtesta-a1 >> ---------------- >> time value_EIGAI status >> 1453679990000000000 13.959871755318915 OK >> >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1453071600000000000 -5.323965719289276 OK >> >> name: egtesta-a1 >> ---------------- >> time value_EIGAI status >> 1453075190000000000 -6.0113449367000555 OK >> >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1452466800000000000 18.85614054031754 OK >> >> name: egtesta-a1 >> ---------------- >> time value_EIGAI status >> 1452470390000000000 -0.2193950233187678 OK >> >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1451862000000000000 -7.2098001702068615 OK >> >> name: egtesta-a1 >> ---------------- >> time value_EIGAI status >> 1451865590000000000 -3.861405078111119 OK >> >> >> >> >> for v13, we get what we expect. -> CORRECT >> >> >> >> > SELECT "time", value_EIGAI, status FROM "egtesta-c1", "egtesta-a1" >> WHERE "time" <= 1453679990000ms ORDER BY time DESC LIMIT 1 >> name: egtesta-c1 >> ---------------- >> time value_EIGAI status >> 1453676400000000000 -23.087604422453467 OK >> >> name: egtesta-a1 >> ---------------- >> time value_EIGAI status >> 1453679990000000000 13.959871755318915 OK >> >> >> Anyone else experiencing this ? Thanks!! >> Cheers, >> Ian >> >> >> >> >> >> >> >> >> >> >> >> -- >> Remember to include the InfluxDB version number with all issue reports >> --- >> You received this message because you are subscribed to the Google Groups >> "InfluxDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/influxdb. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/influxdb/fa586998-e1df-497b-9023-3b53ffb50505%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/fa586998-e1df-497b-9023-3b53ffb50505%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sean Beckett > Director of Support and Professional Services > InfluxDB > -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/9bc36058-6c9f-4bea-8294-8e8abe38ccf7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
