Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Uppercase TRUE/FALSE strings cannot be converted to boolean values #3519

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

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
@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants