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

CONNECT Engine - ODBC: Too long value for SRCDEF

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 10.1.19
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:
      None
    • Environment:
      Windows 7

      Description

      If I create the following table:

       
      DROP TABLE IF EXISTS scada_data_processing.`t1_temp_aux_eo_ots_with_consumption_subset_population`;
       
      CREATE TABLE scada_data_processing.`t1_temp_aux_eo_ots_with_consumption_subset_population` 
      (
        `NumOT` varchar(36) NOT NULL,
        `OT_With_Consumption` BOOLEAN
      ) ENGINE=CONNECT
        TABLE_TYPE=ODBC
        CONNECTION="exp_operativa"  
        OPTION_LIST="UseDSN=Yes,User=************,Password=************"
        SRCDEF =
        "
          SELECT
            A.[NumOT] AS NumOT,
            CASE
              WHEN
                count(CASE WHEN B.[NumOT] IS NOT NULL THEN 1 ELSE 0 END) >=1
              THEN
                1
              ELSE
                0
            END AS OT_With_Consumption
          FROM
            exp_operativa.GPA99.T_OTS AS A
            LEFT JOIN exp_operativa.GPA99.T_MOVEMENTS AS B
              ON A.[NumOT] = B.[NumOT]
          WHERE
            [NumOT] IN ('401591205', '401761515', '401761682', '401761698', '401761721', '401762159', '401774167', '401774169', '401774171', '401774179', '401774182', '401774186', '401774193', ..., '501032891');
            AND B.[Enabled] = 1
          GROUP BY
            A.[NumOT]
        ";
      

      I obtain error when creating the table "Too long value for SRCDEF". Could this limitation be removed by creating (For example) a Server Variable that controls this parameter.

      Thank you.

      Kind regards,
      Juan

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              Juan Juan Telleria
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration