[PHOENIX-6651] !primarykeys cannot list t

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: queryserver-6.0.0
• Component/s: queryserver
• Assignee: Unassigned
• Reporter: YangLei
• Created: 17/Feb/22 01:25
• Updated: 11/Mar/24 08:52

Description

Hi experts.

when I ran !primarykeys in the cmd line of sqlline-thin.py, it listed no information of the table.

while it did list primary key infomation in the cmd line of sqlline.py.

Is this expected or a bug, or some configuration issue? Could you help to check?

0: jdbc:phoenix:thin:url=http://localhost:876> !primarykeys FN2.GROUPCHATINFO
---------------------------------------------------------------+

TABLE_CAT

TABLE_SCHEM

TABLE_NAME

COLUMN_NAME

KEY_SEQ

PK_NAME

---------------------------------------------------------------+
---------------------------------------------------------------+

 

+
0: jdbc:phoenix:> !primarykeys FN2.GROUPCHATINFO
--------------------------------------------------------------------------------------------------------------------------+

TABLE_CAT

TABLE_SCHEM

TABLE_NAME

COLUMN_NAME

KEY_SEQ

PK_NAME

ASC_OR_DESC

DATA_TYPE

TYPE_NAME

COLUMN_SIZE

TYPE_ID

VIEW

--------------------------------------------------------------------------------------------------------------------------+

FN2

GROUPCHATINFO

CHATID

1

A

12

VARCHAR

null

12

--------------------------------------------------------------------------------------------------------------------------+
0: jdbc:phoenix:>

 

Thanks