dotnetcore / dotnetcore/FreeSql

CodeFirst 添加对分区表的支持

Open
#1,122 6 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

数据库对分区表的支持情况:

| 数据库类型 | 支持分区类型 | 版本支持情况 | 说明 |
| :-------------------------------------------------------------------------------------------------------------------------------------- | :---------------------------------------- | :--------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [MySQL](https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html) | `RANGE`、`KEY`、`HASH`、`LIST`、`COLUMNS` | `v5.1` 开始支持,`v5.7` 增强 | `LIST`、`RANGE` 在 `v5.5` 版本支持 |
| [SQL Server](https://docs.microsoft.com/zh-cn/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16) | `RANGE` | 所有版本 | 比较特殊的 `RANGE` 支持,参考 [PARTITION FUNCTION](https://docs.microsoft.com/zh-cn/sql/t-sql/statements/create-partition-function-transact-sql?view=sql-server-ver16) |
| [Oracle](https://docs.oracle.com/cd/E18283_01/server.112/e16541/part_admin001.htm) | `RANGE`、`LIST`、`HASH` | `9i`版本开始有限支持 | 现在主要应用的版本是`11g+`,完全支持 |
| [PostgreSQL](https://www.postgresql.org/docs/current/ddl-partitioning.html) | `RANGE`、`LIST`、`HASH` | `v10.x` | 更早的版本也可以使用 `pg_pathman` |
| `达梦` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `神通` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `人大金仓` | `RANGE`、`LIST`、`HASH` | 支持 | |
| `SQLite` | 不支持 | `/` | `/` |
| `Access` | 不支持 | `/` | `/` |
| `Firebird` | 不支持 | `/` | `/` |

后续补充各数据库类型创建或修改 `RANGE` 等分区的 SQL 脚本。

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names no files, tests, or entry points. Begin by locating the CodeFirst paths for the listed database providers and their schema-generation tests; the issue's stated scope is support for creating or modifying RANGE and other partition types, but it does not define provider-specific acceptance criteria.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, mysql, postgresql, sqlite
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.