Uppercase TRUE/FALSE strings cannot be converted to boolean values

[monetdb-team]

Date: 2014-07-24 13:12:08 +0200
From: @hannesmuehleisen
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)

Last updated: 2014-07-31 09:50:18 +0200

Comment 19919

Date: 2014-07-24 13:12:08 +0200
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.20 Safari/537.36
Build Identifier:

content pending bug number

Reproducible: Always

Actual Results:

error

Expected Results:

values are inserted

Comment 19920

Date: 2014-07-24 13:13:08 +0200
From: @hannesmuehleisen

start transaction;
create table bug3519(a boolean);
-- works
insert into bug3519 values (true),(false),(TRUE),(FALSE);
insert into bug3519 values ('true'),('false');
insert into bug3519 values (1),(0),(NULL),('1'),('0');
COPY 5 RECORDS INTO bug3519 FROM stdin NULL as '';
true
false
1
0

select * from bug3519;

-- does not work
insert into bug3519 values ('TRUE'),('FALSE');
COPY 2 RECORDS INTO bug3519 FROM stdin;
TRUE
FALSE

select * from bug3519;
rollback;

Comment 19921

Date: 2014-07-24 13:14:46 +0200
From: MonetDB Mercurial Repository <>

Changeset 55b5c9a2dfe4 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=55b5c9a2dfe4

Changeset description:

Test for Bug #3519

Comment 19922

Date: 2014-07-24 14:00:26 +0200
From: MonetDB Mercurial Repository <>

Changeset 34a277989ae9 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=34a277989ae9

Changeset description:

Fix for Bug #3519

Comment 19923

Date: 2014-07-24 14:00:29 +0200
From: MonetDB Mercurial Repository <>

Changeset 7065c40a3e2a made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7065c40a3e2a

Changeset description:

Approved test output for Bug #3519

Comment 19924

Date: 2014-07-24 14:05:10 +0200
From: MonetDB Mercurial Repository <>

Changeset 91ffd30c2a4f made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=91ffd30c2a4f

Changeset description:

Approved test output for Bug #3519

Comment 19925

Date: 2014-07-24 14:05:13 +0200
From: MonetDB Mercurial Repository <>

Changeset 9e1cedea1b4b made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=9e1cedea1b4b

Changeset description:

Fix for Bug #3519

Comment 19926

Date: 2014-07-24 14:05:16 +0200
From: MonetDB Mercurial Repository <>

Changeset 04636df9c241 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=04636df9c241

Changeset description:

Test for Bug #3519

Comment 19935

Date: 2014-07-30 11:41:39 +0200
From: MonetDB Mercurial Repository <>

Changeset 7b8cebd11132 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7b8cebd11132

Changeset description:

Encore on Bug #3519

Comment 19936

Date: 2014-07-30 11:43:04 +0200
From: MonetDB Mercurial Repository <>

Changeset 579886367c16 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=579886367c16

Changeset description:

Encore on Bug #3519