You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Keanhua (via GitHub)" <gi...@apache.org> on 2023/12/12 05:27:14 UTC
[I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Keanhua opened a new issue, #29371:
URL: https://github.com/apache/shardingsphere/issues/29371
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.4.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
the sql execute ok
### Actual behavior
the sql execute occur exception
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
SELECT a.recieve_account,a.recieve_account_no,a.recieve_account_bank,a.recieve_account_name,t.pay_channel_id,t.id,t.account_unit_id,t.account_unit_type,t.pay_account,t,balance,t.status,t.pay_type,t.pay_unit_id,t.pay_unit_type,a.name as pay_channel_name,t.only_sign,t.created_at,t.createby_id,t.updated_at,t.updateby_id FROM pay_account t INNER JOIN pay_channel a on a.id = t.pay_channel_id WHERE (t.org_id = ?) ORDER BY created_at DESC LIMIT ?
dataSources:
master:
dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
driverClassName: org.postgresql.Driver
url: jdbc:postgresql://ip:port/aaaa?stringtype=unspecified
username: root
password: ********
maxActive: 20
initialSize: 1
minIdle: 1
validationQuery: select 1
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
rules:
- !TRANSACTION
defaultType: BASE
providerType: Seata
- !SINGLE
tables:
- "*.*"
defaultDataSource: master
- !ENCRYPT
tables:
r_record:
columns:
account:
cipher:
name: account
encryptorName: aes_encryptor
encryptors:
aes_encryptor:
type: AES
props:
aes-key-value: 123456
props:
sql-show: false
### Example codes for reproduce this issue (such as a github link).
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "Keanhua (via GitHub)" <gi...@apache.org>.
Keanhua commented on issue #29371:
URL: https://github.com/apache/shardingsphere/issues/29371#issuecomment-1851353369
```
create table pay_account
(
id varchar(36) not null
primary key,
org_id varchar(36),
created_at timestamp(6),
updated_at timestamp(6),
createby_id varchar(36),
updateby_id varchar(36),
account_unit_type varchar(50),
account_unit_id varchar(36),
pay_account varchar(255),
balance numeric(18, 5) default 0,
pay_unit_type varchar(50),
pay_unit_id varchar(36),
pay_type varchar(50),
pay_channel_id varchar(36),
only_sign varchar(2),
status varchar(50)
);
create table pay_channel
(
id varchar(36) not null
primary key,
org_id varchar(36),
created_at timestamp(6),
updated_at timestamp(6),
createby_id varchar(36),
updateby_id varchar(36),
pay_unit_type varchar(50),
pay_unit_id varchar(36),
name varchar(500),
status varchar(50),
pay_type varchar(50),
recieve_account varchar(255),
recieve_account_name varchar(255),
recieve_account_bank varchar(255),
recieve_account_no varchar(255),
apply_org varchar(36),
apply_id varchar(36),
apply_time timestamp(6),
open_id varchar(36),
open_time timestamp(6),
sub_appid varchar(50),
sub_mchid varchar(50),
pay_gateway_id varchar(36),
only_sign varchar(2)
);
```
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #29371:
URL: https://github.com/apache/shardingsphere/issues/29371#issuecomment-1851418749
Thank you @Keanhua, I will investigate this issue later.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "Keanhua (via GitHub)" <gi...@apache.org>.
Keanhua commented on issue #29371:
URL: https://github.com/apache/shardingsphere/issues/29371#issuecomment-1853176889
@strongduanmu sorry,i find the bug, the sql is wrong, i close the issue。sorry for bothering you！
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "Keanhua (via GitHub)" <gi...@apache.org>.
Keanhua commented on issue #29371:
URL: https://github.com/apache/shardingsphere/issues/29371#issuecomment-1851748582
> Thank you @Keanhua, I will investigate this issue later.
thank you very much!
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #29371:
URL: https://github.com/apache/shardingsphere/issues/29371#issuecomment-1851333097
Can you provide table init sql to help us reproduce this exception?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list' [shardingsphere]
Posted by "Keanhua (via GitHub)" <gi...@apache.org>.
Keanhua closed issue #29371: postgresql org.apache.shardingsphere.infra.exception.UnknownColumnException: Unknown column 't' in 'field list'
URL: https://github.com/apache/shardingsphere/issues/29371
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org