avamingli commented on issue #928:
URL: https://github.com/apache/cloudberry/issues/928#issuecomment-2667606125
> > to recreate, just run `psql -f problem_ddl_cloudberry.sql` and then
`psql -f problem_query.sql`
>
> Hi, i got error with the DDL file:
>
> ```
> psql:problem_ddl_cloudberry.sql:32295: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32296: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32297: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32298: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32299: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32300: error: invalid command \N
> psql:problem_ddl_cloudberry.sql:32301: error: invalid command \.
> psql:problem_ddl_cloudberry.sql:32303: ERROR: syntax error at or near
"33179"
> LINE 1: 33179 43627 197917 1 2024-11-24 10:20:53.129679 419 6 129600...
> ^
> psql:problem_ddl_cloudberry.sql:41154: error: invalid command \.
> psql:problem_ddl_cloudberry.sql:41158: ERROR: syntax error at or near
"38172"
> ```
>
> Did you have other settings using pg_dump or sth else? exec to see the
detailed version info.
>
> select version();
I removed the \N but still got error at several lines:
```sql
psql:problem_ddl_cloudberry.sql:72: ERROR: invalid input syntax for type
integer: ""
CONTEXT: COPY t1, line 6, column col9: ""
psql:problem_ddl_cloudberry.sql:32304: ERROR: invalid input syntax for type
integer: ""
CONTEXT: COPY t2, line 3, column col9: ""
COPY 8850
ALTER TABLE
```
But return zero data according the reproduce sql:
```sql
col1 | col2 | col3 | col4 | col8 | unid | island_start | rn
------+------+------+------+------+------+--------------+----
(0 rows)
```
both for ORCA and Postgres planner.
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
