problem with database in IntelliJ 2017.1
Answered
Hello,
I have two problems with IntelliJ in database.
1. If I write query I have problem with apostrophe (I mean '). When I wrote one apostrophe in IntelliJ, idee don't added second apostrophe.
But if I want write close apostrophe idee added one more apostophe, for example, If I have ' and add second ' in result I have somethink like this '''.
But if I write something like this 'xxxxx and add closed apostophe everything is ok.
2. I run a lot of query.
I do something and again I want run some query and I have problem. When I want run query, nothing happens. I can't run any query in mysql.
I must close idee and open again, then everything is ok.
Please sign in to leave a comment.
Hello,
1. Do you have Insert pair quote option enabled in File | Settings | Editor | General | Smart Keys settings? Does it happen only in SQL files? Could you describe the steps to reproduce with the example of the query please?
2.
>I want run some query and I have problem. When I want run query, nothing happens. I can't run any query in mysql.
What problem do you mean exactly? Do you see any errors/warning when this happens (disconnect from the database may be)?
Thank You for answer.
1. I haved enabled 'Insert pair quote'. But I tried disabled and again enabled this option and now, everything is ok.
2. I don't have any error/warnings when I have this situation. It's look like the mysql is frozen but idee still working good.
For example:
select * from foo;
I have result for above query for example:
id. name
1 foo1
2 foo2
In output tab I have: sql> select * from foo
Then I do some other operation but not on sql. Then I go back to the sql and I write new query, for example:
select * from object;
In result I have still earlier operation
id. name
1 foo1
2 foo2
in output tab I still see only sql> select * from foo
Connection is ok, don't have any errors/wornings.
I can run a lot of query but result is still like above.
If I close project and open again I can do operation in sql and everything is ok.
How reproduce this problem? I have no idea.
>Then I go back to the sql and I write new query, for example:
>select * from object;
>In result I have still earlier operation
Do you see that the query was executed? Is it possible to get a short screencast, showing the issue? Having a idea.log file (you can post the output here) after IDE restart and reproducing would also be helpful. Thanks.
When it happens as a workaround please try to disconnect from database (press red "Stop" button in Database tool window when the Data source is selected) and connect again.