Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5455

ConnectSE: ODBC: do not throw an error on empty CATFUNC=Columns

    XMLWordPrintable

Details

    Description

      drop table if exists t1;
      create table t1 engine=connect table_type=odbc catfunc=columns 
      connection='DSN=pgodbc' tabname='t3';
      select * from t1;

      If the table 't3' does not exist in the remote DSN, the SELECT
      query returns an error:

      ERROR 1296 (HY000): Got error 174 'No data found for table t3' from 

      It should return an empty set.

      It does not seem to be useful to send a warning (instead of the error) on every SELECT.
      But sending a warning at CREATE TABLE time could probably be useful, to make
      the user aware that there is no such table on the remoter data source.

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.