https://bugs.documentfoundation.org/show_bug.cgi?id=168024
Bug ID: 168024
Summary: Base must be able to create view without catalog name
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
I'm trying to integrate SQL Server's JDBC driver into Base using the
jdbcDriverOOo extension.
When creating a view, the catalog name is included in the view creation query,
and it doesn't work.
The catalog is also displayed in the table tree.
This problem occurs both when my driver is running in sdbc or sdbcx/sdb mode.
So I think Base has the same problem as jdbcDriverOOo when it's the
TableSupplier.
Moreover, this is verified since this problem is reproducible using the native
JDBC driver of LibreOffice and the JDBC driver of Microsoft
Steps to Reproduce:
1. Install and then declare to LibreOffice a JRE or JDK java 11 or higher.
1. Add the attached SQL Server JDBC driver file to the LibreOffice ClassPath.
2. Open Base and create a new database using the JDBC driver (ie: the
LibreOffice JDBC driver).
3. In Base chose Table -> Create view
4. When you try to save this new view, you'll get the error message:
'CREATE/ALTER VIEW' does not allow specifying the database name as a prefix to
the object name.
3.
Actual Results:
We are not able to create a view with SQL Server.
Expected Results:
Be able to create a view with SQL Server.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
It seems to me that it's up to Base to handle this problem.
There are several possibilities, and I'd like to discuss them to find the best
one...
--
You are receiving this mail because:
You are the assignee for the bug.
