[0.9.3] Acceptable boolean syntax differs for data writes and data queries #3939

Open
rkuchan opened this Issue Sep 1, 2015 · 3 comments

Comments

Projects
None yet
4 participants
@rkuchan
Contributor

rkuchan commented Sep 1, 2015

I'm able to insert data with the following booleans:

> insert hamlet bool=T
> insert hamlet bool=t
> insert hamlet bool=true
> insert hamlet bool=True
> insert hamlet bool=TRUE
> insert hamlet bool=F
> insert hamlet bool=f
> insert hamlet bool=false
> insert hamlet bool=False
> insert hamlet bool=FALSE
> select * from hamlet
name: hamlet
------------
time                bool
2015-09-01T23:52:40.159867148Z  true
2015-09-01T23:52:48.540448454Z  true
2015-09-01T23:52:50.666636305Z  true
2015-09-01T23:52:53.726779008Z  true
2015-09-01T23:52:56.933272099Z  true
2015-09-01T23:53:00.567120453Z  false
2015-09-01T23:53:02.074383331Z  false
2015-09-01T23:53:04.178181474Z  false
2015-09-01T23:53:08.836037464Z  false
2015-09-01T23:53:13.032263442Z  false

When I attempt to query with t ,T, or random string I get unexpected results, eg.:

> select * from hamlet where bool=t
name: hamlet
------------
time                bool
2015-09-01T23:53:00.567120453Z  false
2015-09-01T23:53:02.074383331Z  false
2015-09-01T23:53:04.178181474Z  false
2015-09-01T23:53:08.836037464Z  false
2015-09-01T23:53:13.032263442Z  false
> select * from hamlet where bool=T
name: hamlet
------------
time                bool
2015-09-01T23:53:00.567120453Z  false
2015-09-01T23:53:02.074383331Z  false
2015-09-01T23:53:04.178181474Z  false
2015-09-01T23:53:08.836037464Z  false
2015-09-01T23:53:13.032263442Z  false
> select * from hamlet where bool='beetle'
name: hamlet
------------
time                bool
2015-09-01T23:53:00.567120453Z  false
2015-09-01T23:53:02.074383331Z  false
2015-09-01T23:53:04.178181474Z  false
2015-09-01T23:53:08.836037464Z  false
2015-09-01T23:53:13.032263442Z  false
@corylanou

This comment has been minimized.

Show comment
Hide comment
@corylanou

corylanou Sep 13, 2015

Contributor

This should probably be done at the same time: #4037

Contributor

corylanou commented Sep 13, 2015

This should probably be done at the same time: #4037

apriendeau added a commit to apriendeau/influxdb that referenced this issue Sep 18, 2015

apriendeau added a commit to apriendeau/influxdb that referenced this issue Sep 19, 2015

@pdknsk

This comment has been minimized.

Show comment
Hide comment
@pdknsk

pdknsk Sep 27, 2015

May I suggest to document this? The current milestone suggest a later release date.

pdknsk commented Sep 27, 2015

May I suggest to document this? The current milestone suggest a later release date.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment