DBeaver client via MySQL JDBC driver

[wilf...@uw.edu]

Hi all

       Finished the tutorial for Horizontal Sharding, all is good.  I can connect using the command like tool mysql.

       When connecting from DBeaver via a MySQL JDBC driver, querying the messages table gave me this error:

SQL Error [1105] [HY000]: vtgate: http://localhost:15001/: unsupported: offset limit for cross-shard queries
  vtgate: http://localhost:15001/: unsupported: offset limit for cross-shard queries
  vtgate: http://localhost:15001/: unsupported: offset limit for cross-shard queries

        Connecting to "Shard 0", using the same client tool works just fine.
     
        How does everyone connect to Vitess other than from command line?

[Sugu Sougoumarane]

We plan to get to full SQL support soon. Here is the current list of unsupported constructs: https://github.com/youtube/vitess/blob/master/data/test/vtgate/unsupported_cases.txt.

When you connect to a specific shard, vitess blindly passes the query through, which is why your query works in that case.

As for connecting directly, people use various tools including DBeaver. There is a bug open for Workbench. Someone was working through that list.

PS: We have a slack channel also. Let me know if you need an invite.

--
You received this message because you are subscribed to the Google Groups "vitess" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vitess+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[wilf...@uw.edu]

Thanks Sugu!!

To unsubscribe from this group and stop receiving emails from it, send an email to vitess+un...@googlegroups.com.