alibaba / alibaba/cobar

如果我在cobar中调用mysql 函数将日期转化为时间戳,也是会报错

Open
#58 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
3.2k
Forks
1.2k
PR merge metrics
No merged PRs in 30d

Description

cobar 不支持mysql函数吗?
mysql> create table myorder(id int auto_increment primary key,city_id int,place_tm int,name varchar(100));

mysql> insert into myorder (id, city_id, place_tm, name) values (1,10,UNIX_TIMESTAMP('2015-06-08 00:00:00'),'testme1');
ERROR 1003 (HY000): route err: different rule columns should have same value number: {PLACE_TM=[], CITY_ID=[10]}

Contributor guide

Open the contributing guide

Research direction

Start with the provided CREATE TABLE and INSERT statement, focusing on how UNIX_TIMESTAMP('2015-06-08 00:00:00') is handled during routing. Trace the source of ERROR 1003 and determine whether the function should be supported or the limitation documented; done means the behavior is corrected or clearly specified.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.