Abnormal behaviour when inserting very large value in decimal column in azure data explorer

Question

So I tried to ingest very large values in decimal column of azure data explorer, it succeeded. But then when I tried to fetch the rows it is showing empty. I ran the following queries :

.create table test_decimal_table(id:decimal)
.ingest inline into table test_decimal_table <| 99999999999999999999999999999999999999
test_decimal_table

So it is showing no rows. I mean if it is not allowed then it should have thrown an exception or something. But it is being successful and then it is not showing anything. And if I do this with some other data in the same column means like below :

.ingest inline into table test_decimal_table <| 99999999999999999999999999999999999999
.ingest inline into table test_decimal_table <| 23.67

Then if try to fetch the rows by running test_decimal_table command then

1 time it is showing only 23.67 and again it is showing no rows and again it is showing 1 row and again no rows. Does anyone has any idea about this.

Answer 1

When working with decimals, you should be using decimal() literals.
For example:

.create table test_decimal_table(id:decimal)
.set-or-append table test_decimal_table <| print id=decimal(1234)
.set-or-append table test_decimal_table <| print id=decimal(1234.567)
test_decimal_table

Answer 2

From my testing, the maximum ingested this way is
.ingest inline into table test_decimal_table <| 9999999999999999999999999999999999
That is 34 , 9's