[0.9.3] cannot select field names with prefix + "." that match the measurement name

[matwey]

Hello,

I am running 0.9.1, and facing the following:

Connected to http://localhost:8086 version 0.9
InfluxDB shell 0.9
> create database test
> use test
Using database test
> insert foo foo.bar.baz=1,foo.bar.bar=2
> select * from foo
name: foo
---------
time                            foo.bar.bar     foo.bar.baz
2015-07-24T05:17:12.089448826Z  2               1

> select "foo.bar.baz" from foo
ERR: unknown field or tag name in select clause: foo."bar.baz"
> select foo.bar.baz from foo
ERR: unknown field or tag name in select clause: foo."bar.baz"

This is either lack of documentation and inconsistency (because if "foo.bar.bar" is illegal name, then it has not to be inserted successfully) or select-statement parser issue.

[beckettsean]

Interestingly enough it requires two dots in the field key for this to show up:

Repro case as from @matwey

> use mydb1
Using database mydb1
> insert foo foo.bar.baz=1
> select * from foo
name: foo
---------
time                foo.bar.baz
2015-07-24T23:09:15.842965617Z  1

> select "foo.bar.baz" from foo
ERR: unknown field or tag name in select clause: foo."bar.baz"
> select foo.bar.baz from foo
ERR: unknown field or tag name in select clause: foo."bar.baz"

Can't repro with only one .

> insert foo foo.bar=1
> select * from foo
name: foo
---------
time                foo.bar foo.bar.baz
2015-07-24T23:09:15.842965617Z      1
2015-07-24T23:10:04.756877936Z  1   

> select "foo.bar" from foo
name: foo
---------
time                foo.bar
2015-07-24T23:10:04.756877936Z  1

[beckettsean]

A single period works but multiple periods render a field unqueryable if explicitly referenced:

> insert foo foo.bar.baz=T
> select * from foo
name: foo
---------
time                foo.bar.baz
2015-08-18T23:43:49.398196253Z  true

#explicitly selecting the field returns nothing
> select "foo.bar.baz" from foo
> select foo.bar.baz from foo


# single period is fine
> insert foo foo.bar=F
> select * from foo
name: foo
---------
time                foo.bar foo.bar.baz
2015-08-18T23:43:49.398196253Z      true
2015-08-18T23:44:55.967966035Z  false   

> select "foo.bar" from foo
name: foo
---------
time                foo.bar
2015-08-18T23:44:55.967966035Z  false

# more than 2 periods leads to no results, as well:
> insert foo foo.bar.baz.bat=1234
> select * from foo
name: foo
---------
time                foo.bar foo.bar.baz foo.bar.baz.bat
2015-08-18T23:43:49.398196253Z      true        
2015-08-18T23:44:55.967966035Z  false           
2015-08-18T23:46:40.447532248Z              1234

> select "foo.bar.baz.bat" from foo
> 

[corylanou]

This actually turns out to be a problem ONLY if the measurement matches the first segment of the field being asked for.

fails:

> use mydb1
Using database mydb1
> insert foo foo.bar.baz=1
> select * from foo
name: foo
---------
time                foo.bar.baz
2015-07-24T23:09:15.842965617Z  1

> select "foo.bar.baz" from foo
> select foo.bar.baz from foo

works:

> use mydb1
Using database mydb1
> insert cpu foo.bar.baz=1
> select * from cpu
name: cpu
---------
time                foo.bar.baz
2015-07-24T23:09:15.842965617Z  1

> select "foo.bar.baz" from foo
name: cpu
---------
time                foo.bar.baz
2015-07-24T23:09:15.842965617Z  1
> select foo.bar.baz from cpu
name: cpu
---------
time                foo.bar.baz
2015-07-24T23:09:15.842965617Z  1