Skip to content

Error when sql_small_result/sql_big_result+distinct/distinctrow  #129

Open
@actiontech-bot

Description

@actiontech-bot

Raised by: @FlyingMao
Steps:

  1. Query: select sql_big_result distinct pad from sbtest1;
    Return:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS pad
FROM sbtest1
LIMIT 100' at line 1
  1. Query: select sql_small_result distinct pad from sbtest1 order by pad;
    Return: io.mycat.plan.common.exception.MySQLOutPutException:column distinct not found

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions