Comments (6)
Closing this as is not needed to ignore set
anymore, it is already implemented.
from go-mysql-server.
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
is not even parseable by vitess.
This is the full list of queries executed by MySQL workbench.
set autocommit=1
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
SHOW SESSION VARIABLES LIKE 'lower_case_table_names'
SELECT current_user()
SET CHARACTER SET utf8
SET NAMES utf8
SHOW SESSION VARIABLES LIKE 'sql_mode'
SELECT CONNECTION_ID()
SHOW SESSION STATUS LIKE 'Ssl_cipher'
USE `db`
SHOW GLOBAL STATUS
Even after passing all those queries, the following error is shown by the app:
I don't know if all this is worth the work it implies for the time being.
from go-mysql-server.
It may not be worth for the first version. We may also want to test other clients, for example:
from go-mysql-server.
Ignoring the SET keyword altogether might not be desirable, since the client might be expecting that those SET have a particular behaviour. Maybe this issue should be changed to just look into what we can do to make it compatible with MySQL Workbench?
from go-mysql-server.
@smola yep. SET
is implemented in #129, but vitess does not support the syntax of all the SET commands workbench sends.
Here's #63 (comment) the full list of commands we need to support for that
from go-mysql-server.
We don;t need to support workbench or any other admin tool, the request of ignoring the SET
was a quick solution to make it work, but if it requires any mid/big work, we are not going to do oit.
from go-mysql-server.
Related Issues (20)
- LIKE fails when new lines are present HOT 4
- Failing test for connection handler in Linux HOT 1
- Compile error: parse.go:248:77: undefined sqlparser.SCHEMAS HOT 7
- Races detected on running gitbase during the test
- Returned types do not fit the schema HOT 2
- upgrade vitess to latest version HOT 1
- Fix node integration tests
- show create table returns incorrect type for varchar
- 2 integration tests are not included in travis
- information_schema.columns data_type has uppercase values HOT 1
- Root opentracing span is not finished
- Async index creation is not working
- Support multiple EXPLODE calls in same SELECT
- Not enough arguments in call to mysql.NewAuthServerStatic HOT 2
- Type not supported: VARBINARY HOT 1
- how do i resolve this?
- adding stored procedure support
- Document major limitations HOT 2
- Archive src-d/go-mysql-server in favor of liquidata-inc/go-mysql-server HOT 7
- ERROR 1105 (HY000) at line 1: unknown error: expecting "EOF" but got 'V' instead HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from go-mysql-server.