Multiline insert
Hey,
is there any possibility to run an insert statement with a string which contains line feeds?
An example could be the following statement:
insert into <table> (<text-column>) values ('Hello
world!');
This statement only run with:
insert into <table> (<text-column>) values ('Hello' || char(10) || 'world!');
kind regards
Please sign in to leave a comment.
Hello Henry,
It does work for me with the
insert. Are there problems with such statements? Please specify your dialect and database and error (if any) you are getting. Thanks.
Hey Andrey,
I tested it few minutes ago with HSQL and it works for me, too.
The issue comes up when using SAP Hana as target database with a connection setup via "Driver and Data Source" in DataGrip.
I also found another problem while using DataGrip with SAP Hana. When a table has a name like "name.space.with.dots::TEST_TABLE" and I try to see the content by using F4, it doesn't work. To see the content I have to write a select statement.
Greetings
SAP Hana is not supported, please vote for related request: https://youtrack.jetbrains.com/issue/DBE-630
Issue with Table Editor is tracked as https://youtrack.jetbrains.com/issue/DBE-1033
Hey Andrey,
tanks for your fast response. I didn't thought that the multi-line issue explicitly has something to do with SAP Hana.