[Libreoffice-bugs] [Bug 116953] EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jun 10 16:55:49 UTC 2018


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

--- Comment #8 from Drew Jensen <drewjensen.inbox at gmail.com> ---
one more comment.

I'm a bit surprised to hear the MySQL and PostgresSQL connectors don't support
this. 

The SQl2003 standard included a defined the INFORMATION_SCHEMA, which was
expanded IIRC in 2005 and 2008. The INFORMATION_SCHEMA would give a
standardized access to things such as view definitions. 

HSQLdb was one of the early adopters of the standard. PostgreSQL, MS SQLServer
and MySQL all support it. 

Firebird 3.0 does not conform to the standard in this respect. 

I believe the decision was to support the 2003 standard as a baseline. Which
meant that for those RDBMS(s) that didn't conform those sdbc drivers would need
to recreate the code for access to those artifacts. The MySQL and PostregsSQL
should of been able to use the HSQLdb code, for these types of things, almost
unchanged. At least I believe that was the plan.

-- 
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/20180610/94fc1b75/attachment.html>


More information about the Libreoffice-bugs mailing list