PolarDB:Orca compatibility

HELLO

• Usage: Same as Redis.

• Return value: Different. Orca returns only server and proto.

AUTH

• Usage: Different.

  • Redis: AUTH [username] password — the username parameter is optional.

  • Orca: AUTH username password — the username parameter is mandatory.

• Return value: Same as Redis.

CLIENT

Only the GETNAME, SETNAME, ID, INFO, LIST, and HELP subcommands are supported. Other subcommands are not supported.

FLUSHALL

• Usage: Different.

  • Redis: FLUSHALL [ASYNC | SYNC] — the ASYNC or SYNC parameter is optional.

  • Orca: FLUSHALL — no parameters are supported.

• Return value: Same as Redis.

FLUSHDB

• Usage: Different.

  • Redis: FLUSHDB [ASYNC | SYNC] — the ASYNC or SYNC parameter is optional.

  • Orca: FLUSHDB — no parameters are supported.

• Return value: Same as Redis.

Pub/Sub state restriction

Clients in the SUBSCRIBE state can only run PING, SUBSCRIBE, PSUBSCRIBE, UNSUBSCRIBE, and PUNSUBSCRIBE. Other commands are not supported in this state.

ZRANGE

Usage: ZRANGE key start stop [BYSCORE | BYLEX] [REV] [LIMIT offset count] [WITHSCORES]. When BYLEX is specified, the sorting behavior follows that of ZRANGEBYLEX.

Lexicographical ordering in Sorted Sets

The following commands use lexicographical ordering: ZLEXCOUNT, ZRANGEBYLEX, ZREMRANGEBYLEX, and ZREVRANGEBYLEX.

Lexicographical ordering is meaningful only when all elements in a Sorted Set have the same score. When scores differ, the order of returned elements is undefined, and Orca and Redis may behave inconsistently.