-- This test verifies that a table could be dropped with columns stats computed
-- The column stats for table without partition will go to TAB_COL_STATS
CREATE DATABASE IF NOT EXISTS tblstatsdb1;
USE tblstatsdb1;
CREATE TABLE IF NOT EXISTS testtable (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE testtable;
ANALYZE TABLE testtable COMPUTE STATISTICS FOR COLUMNS key;

CREATE TABLE IF NOT EXISTS TestTable1_n0 (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE TestTable1_n0;
ANALYZE TABLE TestTable1_n0 COMPUTE STATISTICS FOR COLUMNS key;

CREATE TABLE IF NOT EXISTS TESTTABLE2_n0 (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE TESTTABLE2_n0;
ANALYZE TABLE TESTTABLE2_n0 COMPUTE STATISTICS FOR COLUMNS key;

DROP TABLE tblstatsdb1.testtable;
DROP TABLE tblstatsdb1.TestTable1_n0;
DROP TABLE tblstatsdb1.TESTTABLE2_n0;
DROP DATABASE tblstatsdb1;

CREATE DATABASE IF NOT EXISTS TBLSTATSDB2;
USE TBLSTATSDB2;
CREATE TABLE IF NOT EXISTS testtable (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE testtable;
ANALYZE TABLE testtable COMPUTE STATISTICS FOR COLUMNS key;


CREATE TABLE IF NOT EXISTS TestTable1_n0 (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE TestTable1_n0;
ANALYZE TABLE TestTable1_n0 COMPUTE STATISTICS FOR COLUMNS key;


CREATE TABLE IF NOT EXISTS TESTTABLE2_n0 (key STRING, value STRING);
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE TESTTABLE2_n0;
ANALYZE TABLE TESTTABLE2_n0 COMPUTE STATISTICS FOR COLUMNS key;


DROP TABLE TBLSTATSDB2.testtable;
DROP TABLE TBLSTATSDB2.TestTable1_n0;
DROP TABLE TBLSTATSDB2.TESTTABLE2_n0;
DROP DATABASE TBLSTATSDB2;