You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/06/06 09:36:04 UTC
[GitHub] [incubator-doris] kangkaisen opened a new issue #3792: Non-nullable Largeint column max and min result is wrong
kangkaisen opened a new issue #3792:
URL: https://github.com/apache/incubator-doris/issues/3792
1
```
CREATE TABLE IF NOT EXISTS `test_basic` (
`id_int` int(11) NOT NULL,
`id_tinyint` tinyint NOT NULL,
`id_smallint` smallint NOT NULL,
`id_bigint` bigint NOT NULL,
`id_largeint` largeint NOT NULL,
`id_float` float NOT NULL,
`id_double` double NOT NULL,
`id_char` char(10) NOT NULL,
`id_varchar` varchar(100) NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(`id_int`)
DISTRIBUTED BY HASH(`id_int`) BUCKETS 10
PROPERTIES (
"replication_num" = "1"
);
```
2
```
insert into test_basic (id_int, id_tinyint, id_smallint, id_bigint, id_largeint, id_float, id_double, id_char, id_varchar) values
(1, 10, 100, 1000, 10000, 100000.1, 1000000.1, 'kks_char', 'kks_varchar'),
(2, 20, 200, 2000, 20000, 200000.1, 2000000.1, 'kks_char2', 'kks_varchar2'),
(3, 30, 300, 3000, 30000, 300000.1, 3000000.1, 'kks_char3', 'kks_varchar3'),
(4, 40, 400, 4000, 40000, 400000.1, 4000000.1, 'kks_char4', 'kks_varchar4');
```
3. min id_largeint should be 10000, not 0.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] kangkaisen closed issue #3792: Non-nullable Largeint column max and min result is wrong
Posted by GitBox <gi...@apache.org>.
kangkaisen closed issue #3792:
URL: https://github.com/apache/incubator-doris/issues/3792
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org