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. For more options, visit https://groups.google.com/d/optout.
