[Libreoffice-bugs] [Bug 114755] SQL error: extra parentheses

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114755

--- Comment #6 from Lionel Elie Mamane <lionel at mamane.lu> ---
(In reply to Julien Nabet from comment #4)
> Lionel: here are 2 questions:
> 1) I haven't found SQL ref about INSERT INTO SELECT (...)
>    I never see parenthesis around SELECT block.
> Do you think it'd be ok to remove them?

Yes, removing them should be fine. Both versions should work in most DBMSs (at
least those that support subqueries). The version without parentheses is
actually "more basic SQL", while the version with parentheses is a subquery.
Just hoping it will not break another DBMS.

> 2) Now about the table used for INSERT block, the sql can't succeed since
> the new table doesn't exist yet at this moment.

That's weird. The code should definitely first do the CREATE TABLE and then the
INSERT.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171231/6e44c344/attachment.html>