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

Unsupported SQL data type, err:Unsupported SQL data type, type:VARBINARY. #637

Closed
jiacai2050 opened this issue Feb 10, 2023 · 0 comments · Fixed by #653
Closed

Unsupported SQL data type, err:Unsupported SQL data type, type:VARBINARY. #637

jiacai2050 opened this issue Feb 10, 2023 · 0 comments · Fixed by #653
Labels
bug Something isn't working

Comments

@jiacai2050
Copy link
Contributor

Describe this problem

Create table with varbinary will throw error.

2023-02-10 18:04:16.977 ERRO [server/src/grpc/storage_service/mod.rs:257] Failed to handle request, mod:sql_query, handler:handle_query, err:Rpc error, code:500, message:Failed to create plan, qu
ery:CREATE TABLE IF NOT EXISTS ceresdb (                                                                                                                                                           
                str_tag string TAG,                                                                                                                                                                
                int_tag int32 TAG,                                                                                                                                                                 
                var_tag VARBINARY TAG,                                                                                                                                                             
                str_field string,                                                                                                                                                                  
                int_field int32,                                                                                                                                                                   
                bin_field string,                                                                                                                                                                  
                t timestamp NOT NULL,                                                                                                                                                              
                TIMESTAMP KEY(t)) ENGINE=Analytic with                                                                                                                                             
(enable_ttl='false'), cause:Failed to create plan, err:Unsupported SQL data type, err:Unsupported SQL data type, type:VARBINARY.                                                                   
Backtrace:                                                                                       
 0 <snafu::backtrace_shim::Backtrace as snafu::GenerateBacktrace>::generate::hae5493024171cea8                                                                                                     
   /home/chenxiang/.cargo/registry/src/github.com-1ecc6299db9ec823/snafu-0.6.10/src/backtrace_shim.rs:15
   common_types::datum::UnsupportedDataType<__T0>::build::hd328396a801bd9d0                                                                                                                        
   /home/chenxiang/ceresdb/common_types/src/datum.rs:14                                     
 1 common_types::datum::UnsupportedDataType<__T0>::fail::hf24c888d994be662                                                                                                                         
   /home/chenxiang/ceresdb/common_types/src/datum.rs:14                             
 2 <common_types::datum::DatumKind as core::convert::TryFrom<&sqlparser::ast::data_type::DataType>>::try_from::h52db0aa41eec82d4
   /home/chenxiang/ceresdb/common_types/src/datum.rs:235                                                                                                                                           
 3 sql::planner::parse_column::h61a0a174a1cff1ca                                                                                                                                                   
   /home/chenxiang/ceresdb/sql/src/planner.rs:951                                                                                                                                                  
 4 sql::planner::PlannerDelegate<P>::create_table_to_plan::{{closure}}::h0cc4f7e8384aa3d1                                                                                                          
   /home/chenxiang/ceresdb/sql/src/planner.rs:478                                                                                                                                                  
 5 core::iter::adapters::map::map_try_fold::{{closure}}::h4b9fbdbaf06092f6                                                                                                                         
   /rustc/d394408fb38c4de61f765a3ed5189d2731a1da91/library/core/src/iter/adapters/map.rs:91                                                                                                        
 6 core::iter::traits::iterator::Iterator::try_fold::hd566d40d047a9498 

Steps to reproduce

See create table statement above

Expected behavior

No error

Additional Information

No response

@jiacai2050 jiacai2050 added the bug Something isn't working label Feb 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant