Bug #4603 SHOW TABLES table_type incorreclty named

Submitted:	18 Jul 2004 22:22	Modified:	19 Jul 2004 11:12
Reporter:	Trudy Pelzer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.1-alpha-debug	OS:	Linux (SuSE 8.2)
Assigned to:	Oleksandr Byelkin	CPU Architecture:	Any

Description:
While testing views, I noted that SHOW TABLES has a column named "Type", which has two options: "table" and "view".

According to WL#941 and the SQL Standard, the name of the column should be "table_type" and the correct options are "BASE TABLE" and "VIEW".

How to repeat:
create table t1 (col1 int,col2 char(22));
create view vt1 as select  from t1;
show tables;

Thank You for bugreport! 
I trust you about standard, but WL#941 have not information about SHOW TABLES output 
so I made best what my imegination allow me :). I will fix it soon.

ChangeSet 
  1.1708 04/07/19 12:07:33 bell@sanja.is.com.ua +13 -0 
  standard values for table type in SHOW TABLES (BUG#4603)

Thank you for bugreport again. 
Bug is fixed, bugfix is pushed to our internal source repository and will be accessable in 
public repository, soon (it should be in several hours)

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.