pingcap/tidb
View on GitHubcast string as time caused an "invalid time format" error, not compatible with mysql
Open
#5,340 opened on Dec 7, 2017
component/expressionhelp wantedpriority/P4sig/executiontype/compatibility
Repository metrics
- Stars
- (40,090 stars)
- PR merge metrics
- (Avg merge 14d 4h) (346 merged PRs in 30d)
Description
Please answer these questions before submitting your issue. Thanks!
- What did you do?
./gentest.pl --dsn dbi:mysql:host=127.0.0.1:port=4000:user=root:database=test --grammar=conf/subquery_semijoin.yy --gendata --thread=1
SELECT OUTR . `col_datetime_nokey` AS X FROM C AS OUTR WHERE ( OUTR . `col_int_nokey` , OUTR . `pk` ) IN ( SELECT DISTINCT INNR . `col_int_nokey` AS X , INNR . `col_int_key` AS Y FROM CC AS INNR2 LEFT JOIN CC AS INNR ON ( INNR2 . `col_time_key` <> INNR . `col_date_key` ) WHERE INNR . `col_int_key` >= INNR . `pk` OR NOT OUTR . `pk` < 0 ORDER BY INNR . `col_varchar_key` ) AND OUTR . `pk` < 8 HAVING X = '18:47:12' ORDER BY OUTR . `col_time_nokey` , OUTR . `pk`
createtable.txt 2. What did you expect to see?
no error
- What did you see instead?
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:35: invalid time format
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:1363:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:1343:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:1398:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:492:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/types/time.go:1252:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/expression/builtin_cast.go:989:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/expression/builtin_compare.go:1892:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/expression/builtin_compare.go:1787:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/expression/scalar_function.go:215:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/expression/expression.go:105:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/executor.go:593:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/join.go:718:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/join.go:824:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/sort.go:116:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/executor.go:498:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/executor/adapter.go:80:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/server/conn.go:809:
/Users/xuhuaiyu/Development/GOPATH/src/github.com/pingcap/tidb/server/conn.go:762:
- What version of TiDB are you using (
tidb-server -V)? 648e51d19e51120e9158f6333c060f17260b7ea6