[influxdb] Adding a point with a different tag set and field set to an existing measurement alters the schema :

[g***@gmail.com]

insert debug,host=us3333,result=PASS ctnrName="sakshi.ctnr.1",prj="xyz.12"
selec^C
show measurements

name: measurements
------------------
name
build
create
debug

select * from "debug"

name: debug
-----------
time ctnrName host prj result
1510218785437764998 sakshi.ctnr.1 us3333 xyz.12 PASS

show tag keys from "debug"

name: debug
-----------
tagKey
host
result

show field keys from "debug"

name: debug
-----------
fieldKey fieldType
ctnrName string
prj string

insert debug,host=us3333 result="PASS",ctnrName="sakshi.ctnr.1",prj="xyz.12"
select * from "debug"

name: debug
-----------
time ctnrName host prj result result_1
1510218785437764998 sakshi.ctnr.1 us3333 xyz.12 PASS
1510218845910180112 sakshi.ctnr.1 us3333 xyz.12 PASS

[s***@gmail.com]

I noticed that in the first insert you have the result=PASS as a tag (before the " "), but in the second insert you added it to the fields (after the " ")

This is why you are seeing the "result" tag and "result_1" field in your query.

insert debug,host=us3333,result=PASS ctnrName="sakshi.ctnr.1",prj="xyz.12"
insert debug,host=us3333 result="PASS",ctnrName="sakshi.ctnr.1",prj="xyz.12"

[Frank Inselbuch]

The behavior you are seeing is by design.
You can insert data with a field and a tag with the same name and that data
is distinct.
I believe this should be prevented by IFX and result in an error.
Why don't you raise this as an issue and then the rest of us can +1 it.

insert debug,host=us3333,result=PASS

ctnrName="sakshi.ctnr.1",prj="xyz.12"

selec^C
show measurements

name: measurements
------------------
name
build
create
debug

select * from "debug"

name: debug
-----------
time ctnrName host prj result
1510218785437764998 sakshi.ctnr.1 us3333 xyz.12 PASS

show tag keys from "debug"

name: debug
-----------
tagKey
host
result

show field keys from "debug"

name: debug
-----------
fieldKey fieldType
ctnrName string
prj string

insert debug,host=us3333

result="PASS",ctnrName="sakshi.ctnr.1",prj="xyz.12"

select * from "debug"

name: debug
-----------
time ctnrName host prj result result_1
1510218785437764998 sakshi.ctnr.1 us3333 xyz.12 PASS
1510218845910180112 sakshi.ctnr.1 us3333 xyz.12 PASS

['[e-mail]' via InfluxData]

Following is the link of the issue raised:
https://github.com/influxdata/influxdb/issues/9108.