Result sets with blank newlines break the library

[Fmstrat]

A result set with a newline such as:

id = 3
text = This is a test of things

info = This info

I.E. text has a newline character in it. It breaks the library thinking it's another row.

[PietroFara]

Hi Fmstrat,
thank you for your report. Tomorrow I'm going to try to fix it. Do you have any suggestion? If so you can make a pull request with your solution

[Fmstrat]

I don't, sorry. I just made the select only grab the columns I needed. That being said, I did find that:

• Quotes are needed around $DB here: https://github.com/curaro/sqlite_lib.bash/blob/master/sqlite_lib.bash#L7
• Quotes are needed around $1 here: https://github.com/curaro/sqlite_lib.bash/blob/master/sqlite_lib.bash#L19

[Fmstrat]

You could use a temp variable to define the first column on the first iteration of the loop. Then, if a blank line is run into, make sure the next line is the first column, if not, add a newline to the previous value.

[PietroFara]

I'm working on it. For now I fixed the multple line columns bug (with lines that always have something). Blank new lines is a very tricky problem, in the next days I'm going to try to implement your solution.
Thanks for your support, keep writing me :)