#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 <ian...@gmail.com >
> 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" <=
>> 145367999ms ORDER BY time DESC LIMIT 1
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 14536764000 -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" <= 145367999ms ORDER BY time DESC LIMIT 1
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 14536764000 -23.087604422453467 OK
>>
>> name: egtesta-a1
>>
>> timevalue_EIGAI status
>> 14536799900 13.959871755318915 OK
>>
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 14530716000 -5.323965719289276 OK
>>
>> name: egtesta-a1
>>
>> timevalue_EIGAI status
>> 14530751900 -6.0113449367000555 OK
>>
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 14524668000 18.85614054031754 OK
>>
>> name: egtesta-a1
>>
>> timevalue_EIGAI status
>> 14524703900 -0.2193950233187678 OK
>>
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 1451862 -7.2098001702068615 OK
>>
>> name: egtesta-a1
>>
>> timevalue_EIGAI status
>> 14518655900 -3.86140507819 OK
>>
>>
>>
>>
>> for v13, we get what we expect. -> CORRECT
>>
>>
>>
>> > SELECT "time", value_EIGAI, status FROM "egtesta-c1", "egtesta-a1"
>> WHERE "time" <= 145367999ms ORDER BY time DESC LIMIT 1
>> name: egtesta-c1
>>
>> timevalue_EIGAI status
>> 14536764000 -23.087604422453467 OK
>>
>> name: egtesta-a1
>>
>> timevalue_EIGAI status
>> 14536799900 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 influxdb+u...@googlegroups.com .
>> To post to this group, send email to infl...@googlegroups.com
>> .
>> 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_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 influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
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.