Skip to content

local.ERROR: PDOException: SQLSTATE[HY000]: General error: 1105 line 87 column 38 near " rollup^M #6906

Closed

Description

@mawenbin666

pingcap各位大牛早上好,问下为什么我这边跑sql总是有1105报错呢,我是用docker封装的php程序去跑sql脚本的。
#52 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#53 /var/www/html/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#54 {main}
[2018-06-25 16:27:50] local.ERROR: PDOException: SQLSTATE[HY000]: General error: 1105 line 87 column 38 near " rollup^M
" (total length 41523) in /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:319
Stack trace:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(319): PDO->prepare('\r\n select\r\n ...')
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database{closure}('\r\n select\r\n ...', Array)
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('\r\n select\r\n ...', Array, Object(Closure))
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('\r\n select\r\n ...', Array, Object(Closure))

Activity

  1. tiancaiamao commented on Jun 26, 2018

    @tiancaiamao
    Contributor

    From the log of the application, it seems the SQL statement is wrong.
    Please post the error log of TiDB for us to debug. @007mawenbin

  2. shenli commented on Jun 26, 2018

    @shenli
    Member

    @007mawenbin Thanks for your feedback.
    From the error message, I can see there is a MySQL syntax don't support by TiDB. You can get it from tidb-server's log. Use grep to search rollup in the log file.

  3. zz-jason commented on Jun 26, 2018

    @zz-jason
    Member

    Thanks for your feedback, the root cause is that TiDB has not supported the group by modifier currently

  4. zz-jason commented on Jun 26, 2018

    @zz-jason
    Member

    duplicated with this issue: #4250

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    duplicateIssues or pull requests already exists.

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions