TeslaCN commented on issue #10646:
URL:
https://github.com/apache/shardingsphere/issues/10646#issuecomment-855545491
When timestamp column type's oid is `0`, it worked.
```
PostgreSQL
Type: Parse
Length: 94
Statement:
Query: insert into t_order_0 (order_id, create_time, user_id) values
($1, $2, $3)
Parameters: 3
Type OID: 20
Type OID: 0
Type OID: 20
PostgreSQL
Type: Bind
Length: 72
Portal:
Statement:
Parameter formats: 3
Format: Binary (1)
Format: Text (0)
Format: Binary (1)
Parameter values: 3
Column length: 8
Data: 00000179e46e5e8d
Column length: 26
Data: 323032312d30362d30372031313a30353a30392e3030362b3038
Column length: 8
Data: 00000000000022ba
Result formats: 0
PostgreSQL
Type: Describe
Length: 6
Portal:
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: 1 rows
PostgreSQL
Type: Sync
Length: 4
```
When Proxy executing the actual statement, the timestamp column type's oid
was set to `1043` which is `varchar`.
```
PostgreSQL
Type: Parse
Length: 94
Statement:
Query: insert into t_order_1 (create_time, user_id, order_id) values
($1, $2, $3)
Parameters: 3
Type OID: 1043
Type OID: 20
Type OID: 20
PostgreSQL
Type: Bind
Length: 72
Portal:
Statement:
Parameter formats: 3
Format: Text (0)
Format: Binary (1)
Format: Binary (1)
Parameter values: 3
Column length: 26
Data: 323032312d30362d30372031313a30353a30392e3032332b3038
Column length: 8
Data: 00000000000022b8
Column length: 8
Data: 08723d96a807b001
Result formats: 0
PostgreSQL
Type: Describe
Length: 6
Portal:
PostgreSQL
Type: Execute
Length: 9
Portal:
Returns: all rows
PostgreSQL
Type: Sync
Length: 4
```
--
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:
[email protected]
