diff options
| author | unknown <jimw@mysql.com> | 2005-03-15 10:46:43 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-03-15 10:46:43 -0800 |
| commit | b54f4c51bbe5c5b478870c4e0179e78f6f905544 (patch) | |
| tree | 7944a686e8d525c4a77c864d0b91776567514820 /mysql-test/t/mysqlshow.test | |
| parent | 268a3ecc8b6282ddbd082f7f133c7273b087576b (diff) | |
| download | mariadb-git-b54f4c51bbe5c5b478870c4e0179e78f6f905544.tar.gz | |
Add support for showing table type to mysqlshow command. (Bug #5036)
client/mysqlshow.c:
Add support for -t (--show-table-type) switch
mysql-test/mysql-test-run.sh:
Add support for running mysqlshow
Diffstat (limited to 'mysql-test/t/mysqlshow.test')
| -rw-r--r-- | mysql-test/t/mysqlshow.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/mysqlshow.test b/mysql-test/t/mysqlshow.test new file mode 100644 index 00000000000..8da29b91819 --- /dev/null +++ b/mysql-test/t/mysqlshow.test @@ -0,0 +1,20 @@ +# +## Bug #5036 mysqlshow is missing a column +# +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (1),(2),(3); +CREATE TABLE t2 (a int, b int); +show tables; +select "--------------------" as ""; +--exec $MYSQL_SHOW test +select "---- -v ------------" as ""; +--exec $MYSQL_SHOW test -v +select "---- -v -v ---------" as ""; +--exec $MYSQL_SHOW test -v -v +select "----- -t -----------" as ""; +--exec $MYSQL_SHOW test -t +select "---- -v -t ---------" as ""; +--exec $MYSQL_SHOW test -v -t +select "---- -v -v -t ------" as ""; +--exec $MYSQL_SHOW test -v -v -t +DROP TABLE t1, t2; |