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

CONNECT engine table_type=JDBC no data showing for NTEXT datatype

Details

    Description

      When using the Microsoft JDBC driver, columns of type NCHAR and NVARCHAR now are being returned in SELECT statements (as of 10.1.26), but if a column is defined as NTEXT it is blank (columns defined as TEXT do work correctly).

      For testing see the connection info provided privately earlier, the new table is called: all_types but all the connection info remains the same.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          rdyas Robert Dyas created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Assignee Olivier Bertrand [ bertrandop ]
          bertrandop Olivier Bertrand added a comment -

          Which table should I test having NTEXT columns?

          Note that NTEST, TEST and IMAGE types are not defined as JDBC types. The corresponding SQL types are deprecated and will be remove in future versions of SQL Server.

          bertrandop Olivier Bertrand added a comment - Which table should I test having NTEXT columns? Note that NTEST, TEST and IMAGE types are not defined as JDBC types. The corresponding SQL types are deprecated and will be remove in future versions of SQL Server.
          rdyas Robert Dyas added a comment -

          table: all_types
          NTEXT column: myntext

          SELECT myntext FROM all_types

          rdyas Robert Dyas added a comment - table: all_types NTEXT column: myntext SELECT myntext FROM all_types
          bertrandop Olivier Bertrand added a comment -

          fixed 10.1 version should be 10.1.27.
          NTEST is deprecated and should specified as LONGNVARCHAR.

          bertrandop Olivier Bertrand added a comment - fixed 10.1 version should be 10.1.27. NTEST is deprecated and should specified as LONGNVARCHAR.
          bertrandop Olivier Bertrand made changes -
          issue.field.resolutiondate 2017-08-12 16:43:10.0 2017-08-12 16:43:10.17
          bertrandop Olivier Bertrand made changes -
          Fix Version/s 10.0.33 [ 22552 ]
          Fix Version/s 10.2.8 [ 22544 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          rdyas Robert Dyas added a comment -

          At the top of this, why does the Fixed Versions not include 10.1.27 ?? (it says only Fix Version/s:
          10.0.33, 10.2.8)

          rdyas Robert Dyas added a comment - At the top of this, why does the Fixed Versions not include 10.1.27 ?? (it says only Fix Version/s: 10.0.33, 10.2.8)
          bertrandop Olivier Bertrand added a comment -

          Because it was not in the drop down list when I closed this case!

          This is why I included it in my previous comment.

          bertrandop Olivier Bertrand added a comment - Because it was not in the drop down list when I closed this case! This is why I included it in my previous comment.
          rdyas Robert Dyas added a comment -

          Smells ripe for not being included in the build again

          rdyas Robert Dyas added a comment - Smells ripe for not being included in the build again
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1.27 [ 22609 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 82046 ] MariaDB v4 [ 152599 ]

          People

            bertrandop Olivier Bertrand
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.