\l returns error in psql #36833
Description
Bug Report
Which version of ShardingSphere did you use?
shardingsphere-proxy 5.5.2
postgres 17.2 as backend
Expected behavior
\l returns list of all databases.
Actual behavior
\l returns ERROR: Unknown column 'd.datlocale' in 'field list'. .
root@docker-desktop:~/DDC# psql -h host.docker.internal -p 5440 -U postgres
Password for user postgres:
psql (17.6 (Ubuntu 17.6-1.pgdg22.04+1), server 12.3-ShardingSphere-Proxy 5.5.2)
Type "help" for help.
postgres=> \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | Locale | ICU Rules | Access privileges
-----------+----------+----------+-----------------+------------+------------+--------+-----------+-----------------------
postgres | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
template0 | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
testdb | postgres | UTF8 | libc | en_US.utf8 | en_US.utf8 | | |
(4 rows)
postgres=> \c
psql (17.6 (Ubuntu 17.6-1.pgdg22.04+1), server 12.3-ShardingSphere-Proxy 5.5.2)
You are now connected to database "postgres" as user "postgres".
postgres=> \c testdb
You are now connected to database "testdb" as user "postgres".
testdb=> \l
ERROR: Unknown column 'd.datlocale' in 'field list'.
testdb=>Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
run docker compose up -d in this file.
SQL to execute are shown above