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]> 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]. > 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/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/CALGqCvM06BGMYCB9jaijjB7cBMjJZr7pq1hvRrZ0vNPNXEXeGA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
