Create temporary table as error

[Ivan Smahin]

Hi Mark,

> On Aug 3, 2015, at 8:11 PM, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
> 
> Hi,
> 
> I have set up two identical databases, one in Valentina and one in MySQL. I run the following code:
> 
> CREATE TEMPORARY TABLE table3 AS SELECT * FROM table1 WHERE FALSE;
> 
> According to the documentation at
> http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:create_table
> this should work, but I get the following error:
> 
> 19:06:24 Get Table : No table with name table3
> 
> Why?

I guess you are talking about warning-log record - not an error?
So, your statement was executed and you get the "table3", but with that warning.
Would you report this to the mantis?


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com