[feature request] make regex work on field keys and values

[kurtharriger]

The following query returns results:
select * from "multiHistReport" where time > now() - 1h and eventDescription='component ready' and userAgent= 'Chrome' and pageHash= '_iterationstatus' order by asc

but this query does not:
select * from "multiHistReport" where time > now() - 1h and eventDescription='component ready' and userAgent=~ /Chrome/ and pageHash= '_iterationstatus' order by asc

The difference is the regex for userAgent.

I have found influx 0.9 to require a space after ~ and other regex expressions work fine so not sure why this one does not.

[kurtharriger]

It occurred to me what is different in this case.
I ported a samza job targeting influx 0.8 to influx 0.9. In influx 0.8 these were fields, when I ported it to influx 0.9 I did not change this to be tags.

So the difference it would seem is that regex only works on tags not fields.

[kurtharriger]

I moved the field values into tags and confirmed I was then able to use a regex.
However, I did need to drop and recreate the database for this to work. It appears if a field with the column name exists the regex does not work even if tag column is also present.

[pauldix]

What if you make the regex /.*Chrome.*/?

[kurtharriger]

I had tried that too without success before moving the columns to tags.

[beckettsean]

Issue #2615 already opened to prevent duplicate tag and field keys. #2714 will fix the =~ 'literal' bug.