阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品,为监控而生的数据库连接池
This report summarizes scanner evidence for alibaba/druid, a Java project with 28,155 GitHub stars. SynthScan examined 690,882 lines of code across 6472 source files, recording 145 pattern matches distributed across 9 syntactic categories. The legacy adjusted pattern signal is 0.5 (Low pattern signal); it is not an authorship estimate.
Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.
Use each vector to guide manual verification of the underlying findings.
Payload schema: 1.0.0 · Engine: 2.0.0 · Scoring: heuristic-density-v1 · Scan date: 2026-10-31.
Can maintainers explain intent, assumptions, and trade-offs? 125 finding(s).
Are imports declared and package/API names verified? 18 finding(s).
Are wrappers, guards, and repeated structures necessary? 2 finding(s).
Which changes need focused human review? 145 finding(s).
This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.
Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.
This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.
The scanner identified 145 distinct pattern matches across 9 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| CRITICAL | …est/java/com/alibaba/druid/postgresql/PGLimitTest.java | 17 | String sqlLimit = com.alibaba.druid.sql.PagerUtils.limit(sql, dbType, | CODE |
| CRITICAL | …est/java/com/alibaba/druid/postgresql/PGLimitTest.java | 20 | String sqlCount = com.alibaba.druid.sql.PagerUtils.count(sql, dbType); | CODE |
| CRITICAL | …/test/java/com/alibaba/druid/benckmark/pool/Case1.java | 187 | org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource(); | CODE |
| CRITICAL | …/test/java/com/alibaba/druid/benckmark/pool/Case0.java | 151 | org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource(); | CODE |
| CRITICAL | …src/test/java/com/alibaba/druid/bvt/bug/Issue1898.java | 13 | String formatted = com.alibaba.druid.sql.SQLUtils.format(sql, "mysql"); | CODE |
| CRITICAL | …/test/java/com/alibaba/druid/bvt/sql/TestNewSpout.java | 351 | public static final String filterDbs = org.apache.commons.lang3.StringUtils.join(SqlUtil.filterDb, ","); | CODE |
| CRITICAL | …ram/MySqlParameterizedOutputVisitorTest_restore_0.java | 19 | String formattedSql = com.alibaba.druid.bvt.sql.mysql.param.ParseUtil.restore(sqlTemplate, table, params); | CODE |
| CRITICAL | …main/resources/support/http/resources/js/jquery.min.js | 2 | !function(e,t){"use strict";"object"==typeof module&&"object"==typeof module.exports?module.exports=e.document?t(e,!0):f | CODE |
| CRITICAL | …/com/alibaba/druid/wall/spi/SQLServerWallProvider.java | 52 | return new com.alibaba.druid.wall.spi.SQLServerWallVisitor(this); | CODE |
| CRITICAL | …in/java/com/alibaba/druid/wall/spi/PGWallProvider.java | 46 | return new com.alibaba.druid.wall.spi.PGWallVisitor(this); | CODE |
| CRITICAL | …aba/druid/support/calcite/CalciteMySqlNodeVisitor.java | 585 | this.sqlNode = new com.alibaba.druid.support.calcite.TDDLSqlSelect( | CODE |
| CRITICAL | …aba/druid/support/calcite/CalciteMySqlNodeVisitor.java | 640 | this.sqlNode = new com.alibaba.druid.support.calcite.TDDLSqlSelect( | CODE |
| CRITICAL | …aba/druid/support/calcite/CalciteMySqlNodeVisitor.java | 710 | this.sqlNode = new com.alibaba.druid.support.calcite.CalciteSqlBasicCall( | CODE |
| CRITICAL | …aba/druid/support/calcite/CalciteMySqlNodeVisitor.java | 1414 | this.sqlNode = new com.alibaba.druid.support.calcite.CalciteSqlBasicCall(functionOperator, | CODE |
| CRITICAL | …aba/druid/support/calcite/CalciteMySqlNodeVisitor.java | 1452 | this.sqlNode = new com.alibaba.druid.support.calcite.CalciteSqlBasicCall(functionOperator, | CODE |
| CRITICAL | …ibaba/druid/support/ibatis/DruidDataSourceFactory.java | 28 | dataSource = com.alibaba.druid.pool.DruidDataSourceFactory.createDataSource(map); | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …va/com/alibaba/druid/demo/sql/SchemaStatTest_odps.java | 41 | // System.out.println(statVisitor.getColumns()); | COMMENT |
| LOW | …st/java/com/alibaba/druid/benckmark/sql/SqlHolder.java | 41 | static { | COMMENT |
| LOW | …st/java/com/alibaba/druid/benckmark/sql/SqlHolder.java | 101 | COMMENT | |
| LOW | …src/test/java/com/alibaba/druid/bvt/bug/Issue5847.java | 21 | sql = "select a.*, (a.swanav-lead(a.swanav,1,null::numeric) over w)/lead(a.swanav,1,null::numeric) over w as roe | COMMENT |
| LOW | …a/com/alibaba/druid/bvt/stat/DruidStatServiceTest.java | 221 | assertThat(first, is(not(nullValue()))); | COMMENT |
| LOW | …a/com/alibaba/druid/bvt/stat/DruidStatServiceTest.java | 241 | // Map<String, Object> dataSourceStat = dataSourceList.get(0); | COMMENT |
| LOW | …ba/druid/bvt/filter/wall/WallStatTest_alter_table.java | 41 | // } | COMMENT |
| LOW | …re/src/test/java/com/alibaba/druid/bvt/pool/Case3.java | 21 | import java.sql.Connection; | COMMENT |
| LOW | …re/src/test/java/com/alibaba/druid/bvt/pool/Case3.java | 41 | // Connection conn = dataSource.getConnection(); | COMMENT |
| LOW | …rc/test/java/com/alibaba/druid/bvt/pool/Issue4316.java | 1 | package com.alibaba.druid.bvt.pool; | COMMENT |
| LOW | …rc/test/java/com/alibaba/druid/bvt/pool/Issue4316.java | 21 | // DruidPooledConnection connection1 = druidDataSource.getConnection(); | COMMENT |
| LOW | …alibaba/druid/bvt/sql/schemaStat/SchemaStatTest23.java | 41 | assertEquals(4, statVisitor.getConditions().size()); | COMMENT |
| LOW | …alibaba/druid/bvt/sql/postgresql/issues/Issue5780.java | 21 | public void test_parse_alter_table_sql() { | COMMENT |
| LOW | …alibaba/druid/bvt/sql/postgresql/issues/Issue5752.java | 81 | // + " timestamp with time zone 'epoch' + foo_timestamp * interval '1 second';", | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DDLParserTest.java | 261 | // dst = parser.ddlStmt(); | COMMENT |
| LOW | …com/alibaba/druid/bvt/sql/cobar/DMLCallParserTest.java | 61 | assertEquals("CALL p()", output); | COMMENT |
| LOW | …com/alibaba/druid/bvt/sql/cobar/DMLCallParserTest.java | 81 | // sql = "call p()"; | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1461 | // public void testShow() throws Exception { | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1481 | // | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1501 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1521 | // assertEquals("SHOW GLOBAL STATUS LIKE 'expr'", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1541 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1561 | // assertEquals("SHOW SESSION STATUS WHERE b'10' ^ b'11'", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1581 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1601 | // assertEquals("SHOW TABLE STATUS FROM db WHERE (SELECT a) > (SELECT b)", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1621 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1641 | // assertEquals("SHOW TABLES LIKE 'expr'", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1661 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1681 | // assertEquals("SHOW FULL TABLES", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1701 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1721 | // assertEquals("SHOW GLOBAL VARIABLES WHERE ~ a IS NULL", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1741 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1761 | // assertEquals("SHOW SESSION VARIABLES", output); | COMMENT |
| LOW | …ava/com/alibaba/druid/bvt/sql/cobar/DALParserTest.java | 1781 | // parser = new DALParser(lexer, new SQLExprParser(lexer)); | COMMENT |
| LOW | …com/alibaba/druid/bvt/sql/oracle/OracleMergeTest7.java | 61 | // assertTrue(visitor.getColumns().contains(new TableStat.Column("employees", "employee_id"))); | COMMENT |
| LOW | …m/alibaba/druid/bvt/sql/oracle/pl/Oracle_pl_for_1.java | 61 | } | COMMENT |
| LOW | …baba/druid/bvt/sql/oracle/pl/Oracle_pl_open_for_0.java | 81 | // System.out.println("Tables : " + visitor.getTables()); | COMMENT |
| LOW | …a/com/alibaba/druid/bvt/sql/oracle/pl/Oracle_pl_2.java | 41 | } | COMMENT |
| LOW | …/alibaba/druid/bvt/sql/oracle/pl/oracle_pl_open_1.java | 41 | COMMENT | |
| LOW | …om/alibaba/druid/bvt/sql/oracle/pl/Oracle_pl_if_0.java | 41 | for (SQLStatement statement : statementList) { | COMMENT |
| LOW | …a/com/alibaba/druid/bvt/sql/oracle/pl/Oracle_pl_4.java | 41 | statement.accept(visitor); | COMMENT |
| LOW | …baba/druid/bvt/sql/oracle/pl/Oracle_pl_while_loop.java | 41 | SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(JdbcConstants.ORACLE); | COMMENT |
| LOW | …druid/bvt/sql/oracle/alter/OracleAlterTableTest20.java | 61 | COMMENT | |
| LOW | …t/sql/oracle/visitor/OracleSchemaStatVisitorTest6.java | 61 | // | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest111.java | 121 | // + " NVL(D.JCFS, 0),\n" + " 0,\n" | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest111.java | 141 | // + " NVL(SUM(B.FPSL), 0) AS BYYMFS\n" | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest111.java | 161 | // | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest111.java | 181 | // System.out.println("orderBy : " + visitor.getOrderByColumns()); | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest107.java | 21 | COMMENT | |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest107.java | 41 | // + " \"stop\")), NULL), nvl2(object_node, xmlelement(\"node\", | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest107.java | 61 | // + " object_name,\n" + " cardinality,\n" + " bytes,\n" + " temp_space,\n" | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest107.java | 81 | // | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest107.java | 101 | // "\tJOIN b ON a.id = b.aid \n" + | COMMENT |
| LOW | …/bvt/sql/oracle/select/OracleSelectTest86_comment.java | 81 | assertEquals(0, visitor.getOrderByColumns().size()); | COMMENT |
| LOW | …a/druid/bvt/sql/oracle/select/OracleSelectTest109.java | 41 | // String text = SQLUtils.toOracleString(stmt); | COMMENT |
| LOW | …druid/bvt/sql/oracle/select/OracleSelectTest84_as.java | 61 | assertEquals(0, visitor.getRelationships().size()); | COMMENT |
| LOW | …id/bvt/sql/oracle/create/OracleCreatePackageTest1.java | 61 | System.out.println("orderBy : " + visitor.getOrderByColumns()); | COMMENT |
| LOW | …id/bvt/sql/oracle/create/OracleCreatePackageTest3.java | 141 | // | COMMENT |
| LOW | …vt/sql/oracle/createTable/OracleCreateTableTest72.java | 61 | "\t\"SOURCE_CODE\" VARCHAR2(32) NOT NULL ENABLE,\n" + | COMMENT |
| LOW | …vt/sql/oracle/createTable/OracleCreateTableTest69.java | 61 | // | COMMENT |
| 51 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM | …/main/java/com/alibaba/druid/pool/DruidDataSource.java | 3023 | final String factoryName = className + "Factory"; // XXX: not robust | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 248 | (128, '_transient_feed_ac0b00fe65abe10e0c5b588f3ed8c7ca', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 255 | (134, '_transient_feed_57bc725ad6568758915363af670fd8bc', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| MEDIUM⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| LOW⚡ | …com/alibaba/druid/sql/dialect/h2/visitor/wordpress.sql | 264 | (142, '_transient_feed_867bd5c64f85878d03a060509cd2f92c', 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3:"rss";a:1:{i:0;a:6:{s:4 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | openspec/config.yaml | 3 | # ============================================================================ | COMMENT |
| MEDIUM | openspec/config.yaml | 5 | # ============================================================================ | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | core/src/main/java/com/alibaba/druid/sql/SQLUtils.java | 2496 | // Step 1: Parse both SQLs and get their token lists | COMMENT |
| LOW⚡ | core/src/main/java/com/alibaba/druid/sql/SQLUtils.java | 2500 | // Step 2: Calculate Levenshtein distance based on tokens | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | core/src/main/java/com/alibaba/druid/sql/SQLUtils.java | 2496 | // Step 1: Parse both SQLs and get their token lists | COMMENT |
| LOW⚡ | core/src/main/java/com/alibaba/druid/sql/SQLUtils.java | 2500 | // Step 2: Calculate Levenshtein distance based on tokens | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | …6-02-20-split-sql-expr-parser-primary-method/design.md | 22 | ### Decision 1: Keep `primary()` as orchestration entry point | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | core/src/test/resources/bvt/parser/synapse/1.txt | 42 | VALUES ('John Doe', 'john@example.com') | CODE |
| LOW | core/src/test/resources/bvt/parser/synapse/1.txt | 46 | VALUES ('John Doe', 'john@example.com') | CODE |