The value of last column is always null.

[neuroid]

Hi,

I'm testing InfluxDB 0.8.0-rc.2 (installed using the provided deb package). I'm using the default config provided in the deb. I have run into the following issue:

I'm creating a single point in an empty series:

[
    {
        "columns": [
            "column1", 
            "column2"
        ], 
        "name": "events", 
        "points": [
            [
                "value1", 
                "value2"
            ]
        ]
    }
]

After performing a select * from events; query I get the following result:

[
    {
        "columns": [
            "time", 
            "sequence_number", 
            "column1", 
            "column2"
        ], 
        "name": "events", 
        "points": [
            [
                1405956386426, 
                1118560001, 
                "value1", 
                null
            ]
        ]
    }
]

After adding another point with a third column, I get the following result for the same query:

[
    {
        "columns": [
            "time", 
            "sequence_number", 
            "column1", 
            "column2", 
            "column3"
        ], 
        "name": "events", 
        "points": [
            [
                1405957172332, 
                1118350001, 
                "value1", 
                "value2", 
                null
            ], 
            [
                1405956446265, 
                1118340001, 
                "value1", 
                "value2", 
                null
            ]
        ]
    }
]

It seems that the values for the last column are always null. Is this a know issue? This was working fine in 0.7.

[jvshahid]

Unfortunately I can't reproduce this issue locally. Is it possible to reproduce the issue on a fresh installation or share your data with us.

[neuroid]

I just removed the package, nuked /opt/influxdb and installed the package again. Still getting the same issue. Below is a link the entire /opt/influxdb directory. I hope that's ok.

https://www.dropbox.com/s/n2ge4ii4xiozdum/influxdb.tar.gz

[jvshahid]

Do you have a script that I can run locally ?

[neuroid]

#!/bin/sh

DATA='[
    {
        "columns": [
            "column1",
            "column2"
        ],
        "name": "events",
        "points": [
            [
                "value1",
                "value2"
            ]
        ]
    }
]'

curl -d "$DATA" "http://127.0.0.1:8086/db/test/series?u=root&p=root"

QUERY="select%20*%20from%20events%3B"

curl "http://127.0.0.1:8086/db/test/series?u=root&p=root&q=$QUERY&pretty=true"

The output I'm getting:

[el@segfault ~]$ ./influxdb_issue.sh 
[
    {
        "name": "events",
        "columns": [
            "time",
            "sequence_number",
            "column1",
            "column2"
        ],
        "points": [
            [
                1405959747818,
                40001,
                "value1",
                null
            ]
        ]
    }
]

[jvshahid]

Great I can reproduce it locally using the script