https://bugs.documentfoundation.org/show_bug.cgi?id=114755
--- Comment #6 from Lionel Elie Mamane <[email protected]> ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
