Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

select system.public.tables will return error #129

Closed
jiacai2050 opened this issue Jul 22, 2022 · 1 comment · Fixed by #174
Closed

select system.public.tables will return error #129

jiacai2050 opened this issue Jul 22, 2022 · 1 comment · Fixed by #174
Assignees
Labels
A-SQL Area: SQL layer bug Something isn't working

Comments

@jiacai2050
Copy link
Contributor

jiacai2050 commented Jul 22, 2022

Describe this problem

SELECT
    `timestamp`,
    `catalog`,
    `schema`,
    `table_name`,
    `engine`
FROM
    system.public.tables
WHERE
    table_name = '01_system_table1';

Currently, execute SQL above will cause an error


Failed to execute query, err: Server(ServerError { code: 500, msg: "Failed to execute interpreter, query: SELECT     `timestamp`,     `catalog`,     `schema`,     `table_name`,     `engine` FROM     system.public.tables WHERE     table_name = '01_system_table1';. Caused by: Failed to execute select, err:Failed to execute logical plan, err:Failed to collect record batch stream, err:Stream error, msg:Convert from arrow record batch, err:External error: Execution error: Failed to read table, partition:3, err:Failed to scan table, table:tables, err:Failed to append datum, err:Data type conflict, expect:UInt64, given:String." })

Steps to reproduce

Execute SQL above

Expected behavior

No error

Additional Information

https://github.com/CeresDB/ceresdb/blob/334bc6ce13aac2e72a0771419b4aefe2164255e9/tests/cases/01_system/system_tables.result#L11

ref #154

@jiacai2050 jiacai2050 added bug Something isn't working A-SQL Area: SQL layer labels Jul 22, 2022
@dust1
Copy link
Contributor

dust1 commented Aug 3, 2022

hello, can assign me?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-SQL Area: SQL layer bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants