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.

    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

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

              Dates

              • Created:
                Updated: