This topic describes a compatibility test for DbVisualizer 10.0.24 and AnalyticDB for MySQL, and provides screenshots of test results. Compatibility is tested for a variety of aspects including connectivity, database listing, and table creation.

Test environment

Java MySQL
  • java version "1.8.0_161"
  • Java(TM) SE Runtime Environment (build 1.8.0_161-b12)
  • Java HotSpot(TM) 64-Bit Server VM (build 25.161-b12, mixed mode)
 mysql Ver5.6.46 for osx10.13 on x86_64 (Homebrew)

Test scope

  • Test connectivityConnection to AnalyticDB for MySQL
  • List databasesList databases
  • Create a tableCreate a table
  • List all tablesList all tables
  • Query the schema of a tableQuery the schema of a table
  • Write data to a tableWrite data to a table
  • Query the data of a tableQuery the data of a table
  • Create a viewCreate a view
  • Query the structure of a viewQuery the structure of a view
  • Query a viewQuery a view