GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/590
JIRA TRAFODION-2099 Add support for boolean datatype
-- boolean datatype support in create, cast and params
Ex:
create table t (a boolean);
insert into t values (true), (false);
select * from t where a = true;
-- boolean datatype support for hive columns
-- unarith op support. Currently used for '!' operator that
negates a boolean value.
Ex: select * from t where !a = false;
-- support for more tinyint and largeint unsigned conversion/comparison
operations in expressions and pcode
-- some code cleanup: removed reference to downrev compiler code genration
-- create table if not exists as select... syntax support
-- regress/seabase/TEST003 updated with additional tests
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_bool_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/590.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #590
----
commit d48a0c94353caf83a2036fd7c2727152814255e9
Author: Anoop Sharma <[email protected]>
Date: 2016-07-10T23:02:05Z
JIRA TRAFODION-2099 Add support for boolean datatype
-- boolean datatype support in create, cast and params
Ex:
create table t (a boolean);
insert into t values (true), (false);
select * from t where a = true;
-- boolean datatype support for hive columns
-- unarith op support. Currently used for '!' operator that
negates a boolean value.
Ex: select * from t where !a = false;
-- support for more tinyint and largeint unsigned conversion/comparison
operations in expressions and pcode
-- some code cleanup: removed reference to downrev compiler code genration
-- create table if not exists as select... syntax support
-- regress/seabase/TEST003 updated with additional tests
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---