You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@paimon.apache.org by lz...@apache.org on 2023/11/16 03:06:06 UTC
(incubator-paimon) branch master updated: [hotfix] Fix syntax error in primary-key-table doc (#2324)
This is an automated email from the ASF dual-hosted git repository.
lzljs3620320 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-paimon.git
The following commit(s) were added to refs/heads/master by this push:
new 2db6372b6 [hotfix] Fix syntax error in primary-key-table doc (#2324)
2db6372b6 is described below
commit 2db6372b6b6ae95645d2ce0f6858a512d658231f
Author: Aitozi <10...@qq.com>
AuthorDate: Thu Nov 16 11:06:02 2023 +0800
[hotfix] Fix syntax error in primary-key-table doc (#2324)
---
docs/content/concepts/primary-key-table.md | 18 +++++++++---------
1 file changed, 9 insertions(+), 9 deletions(-)
diff --git a/docs/content/concepts/primary-key-table.md b/docs/content/concepts/primary-key-table.md
index c47b86670..85326dcac 100644
--- a/docs/content/concepts/primary-key-table.md
+++ b/docs/content/concepts/primary-key-table.md
@@ -190,12 +190,12 @@ CREATE TABLE T (
'fields.a.sequence-group' = 'b',
'fields.b.aggregate-function' = 'first_value',
'fields.c.sequence-group' = 'd',
- 'fields.d.aggregate-function' = 'sum',
+ 'fields.d.aggregate-function' = 'sum'
);
-INSERT INTO T VALUES (1, 1, 1, null, null);
-INSERT INTO T VALUES (1, null, null, 1, 1);
-INSERT INTO T VALUES (1, 2, 2, null, null);
-INSERT INTO T VALUES (1, null, null, 2, 2);
+INSERT INTO T VALUES (1, 1, 1, CAST(NULL AS INT), CAST(NULL AS INT));
+INSERT INTO T VALUES (1, CAST(NULL AS INT), CAST(NULL AS INT), 1, 1);
+INSERT INTO T VALUES (1, 2, 2, CAST(NULL AS INT), CAST(NULL AS INT));
+INSERT INTO T VALUES (1, CAST(NULL AS INT), CAST(NULL AS INT), 2, 2);
SELECT * FROM T; -- output 1, 2, 1, 2, 3
@@ -215,8 +215,8 @@ CREATE TABLE T (
) WITH (
'merge-engine'='partial-update'
);
-INSERT INTO T VALUES (1, 1,null,null);
-INSERT INTO T VALUES (1, null,null,1);
+INSERT INTO T VALUES (1, 1, CAST(NULL AS INT), CAST(NULL AS INT));
+INSERT INTO T VALUES (1, CAST(NULL AS INT), CAST(NULL AS INT), 1);
SELECT * FROM T; -- output 1, 1, null, 1
```
@@ -234,8 +234,8 @@ CREATE TABLE T (
'fields.b.default-value'='0'
);
-INSERT INTO T VALUES (1, 1,null,null);
-INSERT INTO T VALUES (1, null,null,1);
+INSERT INTO T VALUES (1, 1, CAST(NULL AS INT), CAST(NULL AS INT));
+INSERT INTO T VALUES (1, CAST(NULL AS INT), CAST(NULL AS INT), 1);
SELECT * FROM T; -- output 1, 1, 0, 1
```