search

stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
865 stars 141 forks source link

bug: A table of type NUMERIC, inserting a maximum value, displayed as 0 #104

Closed 422351990 closed 2 years ago

422351990 commented 2 years ago

Describe the problem A table of type NUMERIC, inserting a maximum value, displayed as 0

Expected behavior The expected values are 9999999999999999999999999999.9999999999、-9999999999999999999999999999.9999999999

How To Reproduce Execute to create tables of type DECIMAL

Create Table: CREATE TABLE `TYPE009` (
  `COL` decimal(18,10) DEFAULT NULL
) ENGINE=STONEDB DEFAULT CHARSET=utf8

Perform the maximum value of the insert NUMERIC (38,10) type Perform insert minimum values of type DECIMAL (38,10)

INSERT INTO TYPE009 VALUES(99999999.9999999999);
INSERT INTO TYPE009 VALUES(-99999999.9999999999);
SELECT * FROM TYPE009;

Environment Ubuntu 20.04.4 LTS Server version: 5.6.24-StoneDB

Additional context none

haitaoguan commented 2 years ago

This Bug is the same as Bug 103。 https://github.com/stoneatom/stonedb/issues/103 @hustjieke

hustjieke commented 2 years ago

related to #103