weird error message when INSERT INTO table

[wzzzzd]

dev=> create table t(a varchar default(date '2022-07-29 19:16:23'), b double default(0.1145141919180));
CREATE_TABLE
dev=> insert into t values (timestamp '2022-07-29 19:17:29', NULL);
ERROR:  QueryError: Scheduler error: Rpc error: gRPC status: status: Internal, message: "internal error: [PlanNode: Ok(Insert(InsertNode { table_source_id: 1001, column_ids: [] }))] Failed to build executor: internal error: [PlanNode: Ok(Values(ValuesNode { tuples: [ExprTuple { cells: [ExprNode { expr_type: Cast, return_type: Some(DataType { type_name: Varchar, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), rex_node: Some(FuncCall(FunctionCall { children: [ExprNode { expr_type: Cast, return_type: Some(DataType { type_name: Timestamp, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), rex_node: Some(FuncCall(FunctionCall { children: [ExprNode { expr_type: ConstantValue, return_type: Some(DataType { type_name: Varchar, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), rex_node: Some(Constant(ConstantValue { body: [50, 48, 50, 50, 45, 48, 55, 45, 50, 57, 32, 49, 57, 58, 49, 55, 58, 50, 57] })) }] })) }] })) }, ExprNode { expr_type: ConstantValue, return_type: Some(DataType { type_name: Double, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), rex_node: None }] }], fields: [Field { data_type: Some(DataType { type_name: Varchar, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), name: \"\" }, Field { data_type: Some(DataType { type_name: Double, precision: 0, scale: 0, is_nullable: true, interval_type: Unspecified, field_type: [] }), name: \"\" }] }))] Failed to build executor: Expr error: Cast2(Timestamp, Varchar)", details: [], metadata: MetadataMap { headers: {"content-type": "application/grpc", "risingwave-error-bin": "CAEShQxpbnRlcm5hbCBlcnJvcjogW1BsYW5Ob2RlOiBPayhJbnNlcnQoSW5zZXJ0Tm9kZSB7IHRhYmxlX3NvdXJjZV9pZDogMTAwMSwgY29sdW1uX2lkczogW10gfSkpXSBGYWlsZWQgdG8gYnVpbGQgZXhlY3V0b3I6IGludGVybmFsIGVycm9yOiBbUGxhbk5vZGU6IE9rKFZhbHVlcyhWYWx1ZXNOb2RlIHsgdHVwbGVzOiBbRXhwclR1cGxlIHsgY2VsbHM6IFtFeHByTm9kZSB7IGV4cHJfdHlwZTogQ2FzdCwgcmV0dXJuX3R5cGU6IFNvbWUoRGF0YVR5cGUgeyB0eXBlX25hbWU6IFZhcmNoYXIsIHByZWNpc2lvbjogMCwgc2NhbGU6IDAsIGlzX251bGxhYmxlOiB0cnVlLCBpbnRlcnZhbF90eXBlOiBVbnNwZWNpZmllZCwgZmllbGRfdHlwZTogW10gfSksIHJleF9ub2RlOiBTb21lKEZ1bmNDYWxsKEZ1bmN0aW9uQ2FsbCB7IGNoaWxkcmVuOiBbRXhwck5vZGUgeyBleHByX3R5cGU6IENhc3QsIHJldHVybl90eXBlOiBTb21lKERhdGFUeXBlIHsgdHlwZV9uYW1lOiBUaW1lc3RhbXAsIHByZWNpc2lvbjogMCwgc2NhbGU6IDAsIGlzX251bGxhYmxlOiB0cnVlLCBpbnRlcnZhbF90eXBlOiBVbnNwZWNpZmllZCwgZmllbGRfdHlwZTogW10gfSksIHJleF9ub2RlOiBTb21lKEZ1bmNDYWxsKEZ1bmN0aW9uQ2FsbCB7IGNoaWxkcmVuOiBbRXhwck5vZGUgeyBleHByX3R5cGU6IENvbnN0YW50VmFsdWUsIHJldHVybl90eXBlOiBTb21lKERhdGFUeXBlIHsgdHlwZV9uYW1lOiBWYXJjaGFyLCBwcmVjaXNpb246IDAsIHNjYWxlOiAwLCBpc19udWxsYWJsZTogdHJ1ZSwgaW50ZXJ2YWxfdHlwZTogVW5zcGVjaWZpZWQsIGZpZWxkX3R5cGU6IFtdIH0pLCByZXhfbm9kZTogU29tZShDb25zdGFudChDb25zdGFudFZhbHVlIHsgYm9keTogWzUwLCA0OCwgNTAsIDUwLCA0NSwgNDgsIDU1LCA0NSwgNTAsIDU3LCAzMiwgNDksIDU3LCA1OCwgNDksIDU1LCA1OCwgNTAsIDU3XSB9KSkgfV0gfSkpIH1dIH0pKSB9LCBFeHByTm9kZSB7IGV4cHJfdHlwZTogQ29uc3RhbnRWYWx1ZSwgcmV0dXJuX3R5cGU6IFNvbWUoRGF0YVR5cGUgeyB0eXBlX25hbWU6IERvdWJsZSwgcHJlY2lzaW9uOiAwLCBzY2FsZTogMCwgaXNfbnVsbGFibGU6IHRydWUsIGludGVydmFsX3R5cGU6IFVuc3BlY2lmaWVkLCBmaWVsZF90eXBlOiBbXSB9KSwgcmV4X25vZGU6IE5vbmUgfV0gfV0sIGZpZWxkczogW0ZpZWxkIHsgZGF0YV90eXBlOiBTb21lKERhdGFUeXBlIHsgdHlwZV9uYW1lOiBWYXJjaGFyLCBwcmVjaXNpb246IDAsIHNjYWxlOiAwLCBpc19udWxsYWJsZTogdHJ1ZSwgaW50ZXJ2YWxfdHlwZTogVW5zcGVjaWZpZWQsIGZpZWxkX3R5cGU6IFtdIH0pLCBuYW1lOiAiIiB9LCBGaWVsZCB7IGRhdGFfdHlwZTogU29tZShEYXRhVHlwZSB7IHR5cGVfbmFtZTogRG91YmxlLCBwcmVjaXNpb246IDAsIHNjYWxlOiAwLCBpc19udWxsYWJsZTogdHJ1ZSwgaW50ZXJ2YWxfdHlwZTogVW5zcGVjaWZpZWQsIGZpZWxkX3R5cGU6IFtdIH0pLCBuYW1lOiAiIiB9XSB9KSldIEZhaWxlZCB0byBidWlsZCBleGVjdXRvcjogRXhwciBlcnJvcjogQ2FzdDIoVGltZXN0YW1wLCBWYXJjaGFyKQ", "date": "Fri, 29 Jul 2022 11:17:40 GMT", "content-length": "0"} }.

[BugenZhao]

The actual error should be Failed to build executor: Expr error: Cast2(Timestamp, Varchar). For the verbose error message, we've already opened an issue for this. #3730

[wzzzzd]

The actual error should be Failed to build executor: Expr error: Cast2(Timestamp, Varchar). For the verbose error message, we've already opened an issue for this. #3730

Got it. It seems this issue can be closed.