[MDEV-36660] Wrong translation and warning from BIT in virtual column - Jira

XML

Word

Printable

I'm not sure if this is expected, but it seems at least counterintuitive to me:

create table t (c1 bit, c2 long as (c1) virtual);

insert into t values (1, default);

select cast(c1 as unsigned) c1, c2 from t;

select cast(c1 as unsigned) c1, 0 + c2 from t;

drop table t;

create table t (c1 bit, c2 long as (c1) virtual);

insert into t values (1, default);

select cast(c1 as unsigned) c1, c2 from t;

c1      c2

select cast(c1 as unsigned) c1, 0 + c2 from t;

c1      0 + c2

1       0

Warnings:

Warning 1292    Truncated incorrect DOUBLE value: '\0001'

drop table t;

select cast(c1 as unsigned) c1, c2 from t;

c1      c2

1       1

select cast(c1 as unsigned) c1, 0 + c2 from t;

c1      0 + c2

1       1

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.