centOS7 on Google Compute Engine

I've created a simple java command line program that you can compile and test - it produces the CORRECT output, so something must be strange with how CONNECT is doing it.

import java.sql.*;

public class ListTables {

  public static void main(String [] args) {

    Connection con = null;

    try {

      con = DriverManager.getConnection("jdbc:sqlserver://parasqltest.database.windows.net:1433;database=test6;user=testuser1@parasqltest;password=AskForPassword;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;");

      DatabaseMetaData meta = con.getMetaData();

      ResultSet res = meta.getTables(null, null, null,  null);

      System.out.println("List of tables: ");

      while (res.next()) {

         System.out.println(

            "   "+res.getString("TABLE_CAT")

           + ", "+res.getString("TABLE_SCHEM")

           + ", "+res.getString("TABLE_NAME")

           + ", "+res.getString("TABLE_TYPE")

           + ", "+res.getString("REMARKS"));

      }

      res.close();

      con.close();

    } catch (Exception e) {

      e.printStackTrace();

    }

  }

}

complile:
javac ListTables.java

run:
java -cp .:/path/to/sqljdbc42.jar ListTables

produces out like this (CORRECT):

List of tables: 

   test6, dbo, rob_test, TABLE, null

   test6, dbo, rob_test_vendor, TABLE, null

   test6, sys, trace_xe_action_map, TABLE, null

   test6, sys, trace_xe_event_map, TABLE, null

   test6, INFORMATION_SCHEMA, CHECK_CONSTRAINTS, VIEW, null

For some reason in CONNECT, the first 3 columns are blank.

Olivier,

Will your fix for table names & column names make it into 10.1.25?

I pushed the fix. Whether or not it is included in the distribution of the next versions does not depend on me.

I was just wondering since the Status for this one is still showing Open rather than Confirmed, In Progress or Fixed (or whatever the right status is).

I just forgot to close it!

I just installed 10.1.25 and this fix is NOT included in that release
We really need this fix.

Was it not included by accident or on purpose? I noticed the change log for 10.1.25 did not list MDEV-12973 either.

Surely not on purpose. But I had confirmation that CONNECT changes had not been included in Version 10.1.25... by accident?

Just saw that this is not listed as fixed in the 10.2.7 Changelog.

Strange... it looks like other CONNECT changes were included in 10.2.7 but not this one... any idea why not included?

Sorry for this. Because of a merge mistake this fix didn't end up in 10.2.7, it'll only be in 10.2.8.

Is this now actually included in 10.1.26 ?
It is not listed in the change log nor the release notes.

OK, initial testing of NVARCHAR is working, so I guess the changes were integrated just not listed in the change log. Pretty big change not to list!

There has been a git problem in the change log that caused it to be lost. However hopefully all the recent fixes should be included.