GreptimeTeam / greptimedb

An open-source, cloud-native, distributed time-series database with PromQL/SQL/Python supported. Available on GreptimeCloud.
https://greptime.com/
Apache License 2.0
3.96k stars 282 forks source link

Partition rule expr UnaryOp is not a binary expression #4247

Open WenyXu opened 2 days ago

WenyXu commented 2 days ago

What type of bug is this?

Unexpected error

What subsystems are affected?

Frontend

Minimal reproduce step

Create table

CREATE TABLE `molestiAe`(
`sImiLiQUE` FLOAT NOT NULL,
`amEt` TIMESTAMP(6) TIME INDEX,
`VoLUPtaS` SMALLINT,
`MAGnAm` FLOAT DEFAULT 0.01672709,
tempore DOUBLE,
`Ut` FLOAT NOT NULL,
`EuM` INT NOT NULL,
`sinT` FLOAT NULL,
`dolOReS` BIGINT,
`suNT` SMALLINT,
`aCCuSAntIUM` DOUBLE NOT NULL,
`cOnSequATur` BOOLEAN,
`sEd` DOUBLE NULL,
`qUi` DOUBLE DEFAULT 0.16361014546626762,
`rAtIoNe` FLOAT DEFAULT 0.75340384,
`QuIS` BOOLEAN,
`cupidITAte` FLOAT NOT NULL,
aut BIGINT NULL,
`mOlesTiAS` DOUBLE NULL,
illo DOUBLE NOT NULL,
`proViDENT` SMALLINT,
`eoS` FLOAT DEFAULT 0.2712446,
`EveNIeT` DOUBLE,
quod FLOAT,
`voluPtatibus` INT,
`aSsumenda` INT,
`volUPtAtEm` FLOAT,
et SMALLINT NULL,
`EXpLICaBo` DOUBLE,
PRIMARY KEY(`EveNIeT`, `sImiLiQUE`, `dolOReS`, tempore, `voluPtatibus`, `aSsumenda`, `VoLUPtaS`)
)
PARTITION ON COLUMNS(`sImiLiQUE`) (
`sImiLiQUE` < -113427450000000000000000000000000000000,
`sImiLiQUE` >= -113427450000000000000000000000000000000 AND `sImiLiQUE` < 113427450000000000000000000000000000000,
`sImiLiQUE` >= 113427450000000000000000000000000000000
)

What did you expect to see?

Table created

What did you see instead?

2024-07-02T07:38:19.486902Z  WARN servers::mysql::server: Internal error occurred during query exec, server actively close the channel to let client try next time err=0: Invalid  │
│ prepare statement: Invalid SQL, error: Partition rule expr UnaryOp { op: Minus, expr: Value(Number("113427450000000000000000000000000000000", false)) } is not a binary expr!, at  │
│ src/servers/src/mysql/handler.rs:487:10 

What operating system did you use?

doesn't matter

What version of GreptimeDB did you use?

main

Relevant log output and stack trace

No response