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

4 comments

Hello Henry,

It does work for me with the 

insert into <table> (<text-column>) values ('Hello
world!');

insert. Are there problems with such statements? Please specify your dialect and database and error (if any) you are getting. Thanks.

0

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

0

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

0

Hey Andrey,

tanks for your fast response. I didn't thought that the multi-line issue explicitly has something to do with SAP Hana.

0

Please sign in to leave a comment.