Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add de-dup #15

Closed
nnsgmsone opened this issue Mar 24, 2021 · 0 comments
Closed

Add de-dup #15

nnsgmsone opened this issue Mar 24, 2021 · 0 comments
Assignees
Labels
kind/tech-request New feature or request

Comments

@nnsgmsone
Copy link
Contributor

No description provided.

@nnsgmsone nnsgmsone added the kind/tech-request New feature or request label Mar 24, 2021
@nnsgmsone nnsgmsone self-assigned this Mar 25, 2021
@nnsgmsone nnsgmsone mentioned this issue Mar 25, 2021
7 tasks
jiangxinmeng1 referenced this issue in jiangxinmeng1/matrixone Apr 20, 2022
Signed-off-by: asuka <312856403@qq.com>
jiangxinmeng1 referenced this issue in jiangxinmeng1/matrixone Apr 29, 2022
Signed-off-by: asuka <312856403@qq.com>
mooleetzi added a commit to mooleetzi/matrixone that referenced this issue Jan 17, 2023
nnsgmsone pushed a commit to dongdongyang33/matrixone that referenced this issue Feb 18, 2023
zengyan1 pushed a commit to zengyan1/matrixone that referenced this issue Mar 27, 2023
Signed-off-by: Aylei <rayingecho@gmail.com>
triump2020 referenced this issue in triump2020/matrixone May 16, 2023
ouyuanning added a commit to ouyuanning/matrixone that referenced this issue Nov 17, 2023
* refactor fuzzyfilter to use new interface

* make bvt 100% pass

* init bloomfilter

* use new bloomfilter

* minor improve

* bug fixed
mergify bot pushed a commit that referenced this issue May 28, 2024
…h MySQL (#15… (#16457)

Newly added Files table in the InformationScheme system database, compatible with MySQL client tools


___

### **PR Type**
Enhancement, Tests


___

### **Description**
- Added a new `FILES` table to the Information Schema, compatible with MySQL client tools.
- Defined the DDL for the `FILES` table in the Information Schema.
- Registered the `FILES` table DDL in the list of predefined DDLs.
- Updated various test results to include the new `FILES` table in the Information Schema.



___



### **Changes walkthrough** 📝
<table><thead><tr><th></th><th align="left">Relevant files</th></tr></thead><tbody><tr><td><strong>Enhancement
</strong></td><td><table>
<tr>
<td>
<details>
<summary><strong>tenant_upgrade_list.go</strong><dd><code>Add upgrade entry for Information Schema FILES table</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

pkg/bootstrap/versions/v1_2_1/tenant_upgrade_list.go

<li>Added <code>upg_information_schema_files</code> to <code>tenantUpgEntries</code>.<br> <li> Defined <code>upg_information_schema_files</code> with schema, table name, upgrade <br>type, SQL, and check function.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-e08c063d32ac1af46a631746dea277c48e4916b11acc9b38555c361093cabe0c">+12/-0</a>&nbsp; &nbsp; </td>

</tr>

<tr>
<td>
<details>
<summary><strong>predefined.go</strong><dd><code>Define DDL for Information Schema FILES table</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

pkg/util/sysview/predefined.go

<li>Added <code>InformationSchemaFilesDDL</code> for creating the <code>FILES</code> table in the <br>Information Schema.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-ee564c7f5edabc5eafa17faa19b402eda3a8731838a2717ab199dd26798b1e76">+41/-0</a>&nbsp; &nbsp; </td>

</tr>

<tr>
<td>
<details>
<summary><strong>sysview.go</strong><dd><code>Register Information Schema FILES DDL</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

pkg/util/sysview/sysview.go

<li>Included <code>InformationSchemaFilesDDL</code> in the list of predefined DDLs.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-e6c41651545df9f38e71c4fe8d74e9ee7a78264b5cfd2d93029022d704b95176">+1/-0</a>&nbsp; &nbsp; &nbsp; </td>

</tr>
</table></td></tr><tr><td><strong>Tests
</strong></td><td><table>
<tr>
<td>
<details>
<summary><strong>system_table.result</strong><dd><code>Update system table test results for FILES table</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

test/distributed/cases/database/system_table.result

<li>Added <code>files</code> table to the list of tables in the Information Schema.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-aa812d22c085106383adea72e43e86a0eb5064c03d17402e798f9aed78e29149">+1/-0</a>&nbsp; &nbsp; &nbsp; </td>

</tr>

<tr>
<td>
<details>
<summary><strong>system_variables.result</strong><dd><code>Update system variables test results for FILES table</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

test/distributed/cases/database/system_variables.result

<li>Added <code>files</code> table to the list of tables in the Information Schema.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-8b7aa37a412621c9cc5ea633f0f44ccef24496de3d7d9ea295b249dfab4be6ee">+1/-0</a>&nbsp; &nbsp; &nbsp; </td>

</tr>

<tr>
<td>
<details>
<summary><strong>database_statistics.result</strong><dd><code>Update database statistics test results for FILES table</code>&nbsp; &nbsp; </dd></summary>
<hr>

test/distributed/cases/dml/show/database_statistics.result

<li>Updated the number of tables in the Information Schema to include the <br><code>files</code> table.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-df23824b49f2821d75a690ad1320c27d7fa873f410d7a95e8ebe7737c4face32">+2/-2</a>&nbsp; &nbsp; &nbsp; </td>

</tr>

<tr>
<td>
<details>
<summary><strong>mo_cloud.result</strong><dd><code>Update mo_cloud test results for FILES table</code>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </dd></summary>
<hr>

test/distributed/cases/mo_cloud/mo_cloud.result

<li>Updated the number of tables in the Information Schema to include the <br><code>files</code> table.<br> <li> Added <code>files</code> table to the list of tables in the Information Schema.<br>


</details>


</td>
<td><a href="https://github.com/matrixorigin/matrixone/pull/16457/files#diff-8bd47e20767de1021a622241282eeb367611df3cd6449111ea058f050690aaa0">+3/-1</a>&nbsp; &nbsp; &nbsp; </td>

</tr>
</table></td></tr></tr></tbody></table>

___

> 💡 **PR-Agent usage**:
>Comment `/help` on the PR to get a list of all available PR-Agent tools and their descriptions

Approved by: @daviszhen, @zhangxu19830126, @aressu1985, @sukki37
@aylei aylei mentioned this issue Jun 5, 2024
gouhongshen referenced this issue in gouhongshen/matrixone Jul 18, 2024
ouyuanning pushed a commit to ouyuanning/matrixone that referenced this issue Oct 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/tech-request New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant