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

ENGINE = CONNECT

    XMLWordPrintable

Details

    Description

      UPDATE 10.5.12 to 10.5.13.

      CREATE TABLE pult_boxmdu (
        id int(11) NOT NULL,
        region_ID int(11) NOT NULL,
        PRIMARY KEY (id)
      )
      ENGINE = CONNECT,
      TABLE_TYPE = ODBC,
      TABNAME = 'pult_boxmdu',
      READONLY = 1,
      CHARACTER SET cp1251,
      COLLATE cp1251_ukrainian_ci,
      CONNECTION = 'DSN=Odyssey';
       
      run SELECT id, region_ID FROM pult_boxmdu;
      OUT:
      id	region_ID
      14	3
      8	3
      26	3
      712	2
      22	3
       
      SELECT region_ID FROM pult_boxmdu;
      region_ID
      0
      0
      0
      0
      0
      

      Why "0? How to solve?

      Attachments

        1. my.ini
          1 kB
          Sergii Volikov

        Issue Links

          Activity

            People

              bertrandop Olivier Bertrand
              Sergey_W Sergii Volikov
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.