ZeosLib / Feature Requests / Suggestions / #52 Zeos does not support databases that support _catalogs

Database components for Delphi, FreePascal/Lazarus, Kylix, C++ Builder

#52 Zeos does not support databases that support _catalogs_ and schemas

Milestone: None

Status: open

Owner: nobody

Labels: None

Updated: 2025-07-31

Created: 2025-07-31

Creator: marsupilami79

Private: No

This was seen when creating the DuckDb driver. The Zeos loading mechanism isn't well prepared for supporting catalogs and schemas. Because of this we cannot support Catalogs and Schemas at the same time.

See the following source in TZAbstractResultSetMetadata.ReadColumnByName:

  with FMetadata.GetDatabaseInfo do
    if SupportsCatalogsInDataManipulation and (TableRef.Catalog = '') then
      Catalog := FMetadata.GetConnection.GetCatalog
    else if SupportsSchemasInDataManipulation and (TableRef.Schema = '') and (TableRef.Catalog = '') then
      Schema := FMetadata.GetConnection.GetCatalog;

Discussion

Description has changed:

Diff:

--- old
+++ new
@@ -1,6 +1,6 @@
 This was seen when creating the DuckDb driver. The Zeos loading mechanism isn&#39;t well prepared for supporting catalogs and schemas. Because of this we cannot support Catalogs and Schemas at the same time.

-See the following source in &#39;&#39;TZAbstractResultSetMetadata.ReadColumnByName&#39;&#39;:
+See the following source in ``TZAbstractResultSetMetadata.ReadColumnByName``:
 ~~~
   with FMetadata.GetDatabaseInfo do
     if SupportsCatalogsInDataManipulation and (TableRef.Catalog = &#39;&#39;) then

Milestone: -->

Zeos does not support databases that support _catalogs_ and schemas

Database components for Delphi, FreePascal/Lazarus, Kylix, C++ Builder

Milestone

Searches

Help

#52 Zeos does not support databases that support _catalogs_ and schemas

Discussion