Another thing: you say you created the table with a shell script. How *exactly*? Quoting is important here, since both the shell and SQL have their own ideas about quoting. If the creation succeeded, it may be that the names were converted to all lowercase because of incorrect quoting in the shell. Check sys.tables. On 10/03/18 09:55, Stefan Manegold wrote:
If MonetDB says the table does not exist, then it most probably indeed does not exist, and hence you cannot remove it (well, there is then obviously not need to remove the non-existing table). You can double-check with, e.g., select * from "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001"; select * from schemas s join tables t on s.id = t.schema_id where s.name = 'DM_MON_TSV_STG_T1' and t.name = 'AMA_US_IRI_8135_2001';
I would be surprised (and consider it a bug that should be reported and fixed), if MonetDB excepted the given create statement without issuing an error; cf.,
sql>create table t (); syntax error, unexpected ')', expecting FOREIGN or PRIMARY or UNIQUE in: "create table t ()"
Best, Stefan
----- On Mar 10, 2018, at 8:29 AM, Sreejith Sharma Sreejith.Sharma@harman.com wrote:
All,
We are finding a strange issue where below table has been created via a shell script. Strangely it doesn’t show up any columns and when we try to drop it’s saying table doesn’t exists.
Is there any way below can happen? Is this because it’s corrupted? How can we remove this?
CREATE TABLE "DM_MON_TSV_STG_T1"."AMA_US_IRI_8135_2001" (
);
Regards,
Sreejith
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender