weijunlu opened a new issue, #2688: URL: https://github.com/apache/drill/issues/2688
Boolean expression failed to execute in mysql plugin 1. The version information is as follows: apache drill> select commit_message, commit_time from sys.version; +----------------------------------------------------------------------------------+---------------------------+ | commit_message | commit_time | +----------------------------------------------------------------------------------+---------------------------+ | DRILL-8314: Add support for automatically retrying and disabling broken storage plugins (https://github.com/apache/drill/pull/2655) | 18.10.2022 @ 18:15:31 CST | 2. Create tables and insert data in mysql database. CREATE TABLE bt1 ( c1 int , c2 tinyint(1) DEFAULT NULL ) INSERT INTO bt1 VALUES (1,1),(10,0); 3. Create mysql Plugins in Storage label via http://localhost:8047/storage pages 4. The sql statement is executed as follows apache drill (mysql.test)> use mysql.test; +------+----------------------------------------+ | ok | summary | +------+----------------------------------------+ | true | Default schema changed to [mysql.test] | apache drill (mysql.test)> select c2,c2 and true , 2...............semicolon> c2 and c2, 3...............semicolon> c2 or true , 4...............semicolon> c2 or c2 , 5...............semicolon> c2 and false , 6...............semicolon> c2 or false , 7...............semicolon> not c2 8...............semicolon> from bt1 9...............semicolon> where c1=1; Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. Sql: SELECT `c2`, `c2`, `c2`, CAST(TRUE AS BOOLEAN), `c2`, CAST(FALSE AS BOOLEAN), `c2`, NOT `c2` FROM `test`.`bt1` WHERE `c1` = 1 Fragment: 0:0 [Error Id: a7344f04-4964-4913-bded-7b098280906f on DESKTOP-PHHB7LC:31010] (state=,code=0) But there was no problem with the other commit in the master version. 1. The version information is as follows: apache drill> select commit_message, commit_time from sys.version; +-----------------------------------------------------------+---------------------------+ | commit_message | commit_time | +-----------------------------------------------------------+---------------------------+ | DRILL-8273: Complex typed columns cannot be made implicit | 31.07.2022 @ 14:34:14 CST | +-----------------------------------------------------------+---------------------------+ 2. apache drill (mysql.test)> select c2,c2 and true , 2...............semicolon> c2 and c2, 3...............semicolon> c2 or true , 4...............semicolon> c2 or c2 , 5...............semicolon> c2 and false , 6...............semicolon> c2 or false , 7...............semicolon> not c2 8...............semicolon> from bt1 9...............semicolon> where c1=1; +------+--------+--------+--------+--------+--------+--------+--------+ | c2 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | +------+--------+--------+--------+--------+--------+--------+--------+ | true | 1 | 1 | 1 | 1 | 0 | 1 | 0 | +------+--------+--------+--------+--------+--------+--------+--------+ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
