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
 ```