ThanoshanMV opened a new pull request, #18272:
URL: https://github.com/apache/shardingsphere/pull/18272

   For #17844
   
   Changes proposed in this pull request:
   - Added PostgreSQL [Copy 
Statement](https://www.postgresql.org/docs/current/sql-copy.html).
   - Added test cases.
   - Added `E?` in `STRING_` to represent the [escape string 
constants](https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-BACKSLASH-TABLE)
 specified by writing the letter E just before the opening quote. For example, 
`E'foo'`. This is added to support queries like `COPY t_order FROM STDIN WITH 
NULL AS E'\\0';`.
   - Omitted `copy_by_postgresql_source_test_case3` as it is not aligned.
   
![null-as-encoding-ast](https://user-images.githubusercontent.com/48581379/172873293-a3ecb74f-5460-466b-98f2-7b7ee554ca89.png)
   In the above query, `[ NULL [ AS ] 'null_string' ]` cannot be followed with 
`ENCODING 'encoding_name'` as there is no definition of `ENCODING` there.
   
![null-as-structure-1](https://user-images.githubusercontent.com/48581379/172876407-a427c262-cb58-4351-afdd-10f30a148f5c.png)
   - Modified `copy_by_postgresql_source_test_case5` as 
`copy_table_to_stdout_with_csv_force_quote`, `ESCAPE E'\'` must come before 
`FORCE QUOTE col2;`
   
![force-quote](https://user-images.githubusercontent.com/48581379/172875663-ba8b61f3-5b40-447e-ab31-b4ddddd3379a.png)
   
   Please let me know if there is anything to change.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to