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

CONNECT engine - The same result as the original source DBMS is not coming out.

    XMLWordPrintable

Details

    Description

      I tested Microsoft SQL Server <=> MariaDB.
      When you look at the record through the connect engine, it will look exactly.
      However, when insert data from MariaDB, there is a space to the full length of the column in addition to the data inserted(I think that is pad). Even when the insert data is retrieved from the SQL Server, the entire length of the inserted recoed is filled full column length.
      For example, select datalength(name) from testtb2; , The original data is the result value of 5, but the data inserted through MariaDB is equal to the column length of 50. like below.

      1> select name from testtb2;
      2> go
      name
      --------------------------------------------------
      test1
      test2
      test3
      74716
      test4

      (5 rows affected)

      1> select datalength(name) from testtb2;
      2> go

      -----------
      5
      5
      5
      50 <=== inserted from MariaDB using connect engine.
      50 <=== inserted from MariaDB using connect engine.

      (5 rows affected)

      If it is something that can be improved, I think it would be better for the user to improve it.
      Would it be possible to improve?!

      Attachments

        Activity

          People

            Unassigned Unassigned
            Seonghwan Kim Seonghwan Kim
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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