matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: Function expression in INSERT statement is not implemented

Open domingozhang opened this issue 3 years ago • 3 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

insert INTO t1 (id,a) VALUES (1,0),
(2,CAST(0x7FFFFFFFFFFFFFFF AS UNSIGNED)), (3,CAST(0x8000000000000000 AS UNSIGNED)), (4,CAST(0xFFFFFFFFFFFFFFFF AS UNSIGNED)); Data truncation: Function expression in INSERT statement value list will be supported in future version. for column 'a' at row 1

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

domingozhang avatar Jun 24 '22 10:06 domingozhang

0.6 will support function expression in insert statement.

JinHai-CN avatar Jun 24 '22 10:06 JinHai-CN

It will implemented in 0.6

domingozhang avatar Jul 01 '22 10:07 domingozhang

same as #2338

ouyuanning avatar Jul 06 '22 00:07 ouyuanning

截屏2022-10-29 22 52 12

tianyahui-python avatar Oct 29 '22 14:10 tianyahui-python

@domingozhang can close issue.

tianyahui-python avatar Oct 29 '22 14:10 tianyahui-python