ChaseHuangxu opened a new issue, #19786: URL: https://github.com/apache/doris/issues/19786
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description I'm trying to add Apache Doris support to SQLancer, this issue is used to track progress. [PR Link](https://github.com/sqlancer/sqlancer/pull/758) Functions that have been implemented: 1. Connect Doris via JDBC and create Database Statement 2. Basic data type representation of Doris: - INT(LARGEINT, BIGINT, INT, SMALLINT, TINYINT) - FLOAT(DOUBLE, FLOAT) - DECIMAL(DECIMAL, DECIMALV3) - DATE (DATEV2) - DATETIME (DATETIME, DATETIMEV2) - VARCHAR (VARCHAR, CHAR) - BOOLEAN (BOOLEAN) - NULL (NULL) 3. Representation of the Doris data model: UNIQUE, AGGREGATE, DUPLICATE; 4. Representation of the Doris column aggregate type: SUM, MIN, MAX, REPLACE, REPLCAE_IF_NOT_NULL; 5. `CREATE TABLE`, `INSERT`, `DELETE`, `SELECT`, `TRUNCATE`, `DROP TABLE` statement 6. Representation of commonly used SQL operators - aggregate function, such as MIN, SUM; - between and - binary arithemtic operation, such as +, -, *, / - binay comparison operation, such as =, !=, >= - binary logical operation, such as AND, OR - CASE - CAST - IN - JOIN - LIKE - ORDER BY - GROUP BY - Unary Postfix operation, such as is null, is not null - Unary Prefix operation, such as is not, - - Doris function operation, such as LAST_DAYS, ENDS_WITH 7. Three detection rules of SQLancer - NoREC - TLP: WHERE, HAVING, AGGREGATE, DISTINCT, GROUPBY - PQS Current todo list: - [ ] Support for remaining Doris data types, HLL, BITMAP, QUANTILE_STATE, ARRAY, MAP, JSONB, STRUCT - [ ] `CREATE VIEW` statement - [ ] `CREATE INDEX` statement - [ ] Improve support for Doris function: correct generated function arguments, and add error message for Doris function ### Solution _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
