[libgda] GdaParser: remove spaces and enters before next statement

[Daniel Espinosa Ortiz <despinosa src gnome org>]

commit 1554ecf6748776e662d3bf978b545da29024532a
Author: Daniel Espinosa <esodan gmail com>
Date:   Fri Nov 29 23:16:31 2019 -0600

    GdaParser: remove spaces and enters before next statement
    
    Batch parsing, should remove spacesa and enters before
    return next statement.
    
    Fix issue #203

 libgda/sql-parser/gda-sql-parser.c |  3 +++
 tests/parser/testdata.xml          | 13 ++++++++++++-
 2 files changed, 15 insertions(+), 1 deletion(-)
---
diff --git a/libgda/sql-parser/gda-sql-parser.c b/libgda/sql-parser/gda-sql-parser.c
index 675d2e592..76f0caab1 100644
--- a/libgda/sql-parser/gda-sql-parser.c
+++ b/libgda/sql-parser/gda-sql-parser.c
@@ -587,6 +587,9 @@ gda_sql_parser_parse_string (GdaSqlParser *parser, const gchar *sql, const gchar
                if (* priv->context->next_token_start) {
                        gint i = priv->context->next_token_start - priv->sql;
                        *remain = sql + i;
+                       while (**remain == ' ' || **remain == '\n') {
+                               *remain = sql + (++i);
+                       }
                }
        }
 
diff --git a/tests/parser/testdata.xml b/tests/parser/testdata.xml
index 1b4de5e09..3d0e86730 100644
--- a/tests/parser/testdata.xml
+++ b/tests/parser/testdata.xml
@@ -150,7 +150,7 @@
 
   <test id="25">
     <sql>aa bb;  ; c</sql>
-    <expected>{"statements":[{"statement":{"sql":"aa 
bb;","stmt_type":"UNKNOWN","contents":[{"value":"aa"},{"value":" "},{"value":"bb"}]}},{"statement":{"sql":" 
c","stmt_type":"UNKNOWN","contents":[{"value":" "},{"value":"c"}]}}]}</expected>
+    <expected>{"statements":[{"statement":{"sql":"aa 
bb;","stmt_type":"UNKNOWN","contents":[{"value":"aa"},{"value":" 
"},{"value":"bb"}]}},{"statement":{"sql":"c","stmt_type":"UNKNOWN","contents":[{"value":"c"}]}}]}</expected>
   </test>
 
   <test id="26">
@@ -1047,4 +1047,15 @@
     <sql>UPDATE coupons SET limit = 1 WHERE coupons.id = 1</sql>
     <expected>{"statements":[{"statement":{"sql":"UPDATE coupons SET limit = 1 WHERE coupons.id = 
1","stmt_type":"UPDATE","contents":{"table":"coupons","fields":["limit"],"expressions":[{"value":"1"}],"condition":{"operation":{"operator":"=","operand0":{"value":"coupons.id"},"operand1":{"value":"1"}}}}}}]}</expected>
   </test>
+
+  <test id="issue#203">
+    <sql>SELECT * FROM test; SELECT * FROM test2;</sql>
+    <expected>{"statements":[{"statement":{"sql":"SELECT * FROM 
test;","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"*"}}],"from":{"targets":[{"expr":{"value":"test"},"table_name":"test"}]}}}},{"statement":{"sql":"SELECT
 * FROM 
test2;","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"*"}}],"from":{"targets":[{"expr":{"value":"test2"},"table_name":"test2"}]}}}}]}</expected>
+  </test>
+
+  <test id="issue#203-2">
+    <sql>SELECT * FROM test;
+SELECT * FROM test2;</sql>
+    <expected>{"statements":[{"statement":{"sql":"SELECT * FROM 
test;","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"*"}}],"from":{"targets":[{"expr":{"value":"test"},"table_name":"test"}]}}}},{"statement":{"sql":"SELECT
 * FROM 
test2;","stmt_type":"SELECT","contents":{"distinct":"false","fields":[{"expr":{"value":"*"}}],"from":{"targets":[{"expr":{"value":"test2"},"table_name":"test2"}]}}}}]}</expected>
+  </test>
 </testdata>