This topic describes a compatibility test for Navicat Premium 12.1.27 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 Navicat Premium
  • 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) Navicat Premium 12.1.27

Test scope

  • Test connectivityconnection1Connectivity 2
  • List databases新建连接
  • Create a tableCreate a table
  • List all tablesList all tables
  • Query the schema of a tableQuery the schema of a table 2query the schema of a table
  • Write data to a tableWrite data to a table
  • Create a viewCreate a view
  • Query the structure of a viewQuery a view
  • Query a viewQuery a view