[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-18 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16548698#comment-16548698
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203585948
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
- char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ char[acter] [(length) [characters]]
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [(length) [characters]]
--- End diff --

Yes thanks, I've corrected   


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-18 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16548697#comment-16548697
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203585852
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
- char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ char[acter] [(length) [characters]]
--- End diff --

Yes thanks, I've corrected   


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-18 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16548532#comment-16548532
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203555402
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
- char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ char[acter] [(length) [characters]]
--- End diff --

Should be "char[acter] [(length [characters])]". The optional [characters] 
syntactic element should be inside the parenthesis.


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-18 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16548531#comment-16548531
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203555447
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
- char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ char[acter] [(length) [characters]]
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [(length) [characters]]
--- End diff --

Same here.


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-17 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16547320#comment-16547320
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203239377
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [length [characters]]
--- End diff --

Yes, the origin text is right, I've corrected it  


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-17 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16546866#comment-16546866
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r203094486
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [length [characters]]
--- End diff --

Thanks; you are correct. So, it should say, "nchar [(length 
[characters])]". The length is optional, but if it is present, parentheses are 
required.


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545976#comment-16545976
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202882592
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -756,6 +758,86 @@ Alter TABLE PRODUCT
 ALTER COLUMN vend_id RENAME TO cstm_id;
 ```
 
+* This example demonstrates the character set of NCHAR column cannot be 
altered.
--- End diff --

Thanks @DaveBirdsall your comments have been incorporated  


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545974#comment-16545974
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202882272
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
--- End diff --

Thanks for your review @DaveBirdsall 

`length [characters]` is optional.
If `length` is not specified, then default is 1 character.


![default](https://user-images.githubusercontent.com/20532956/42794351-da9d61f2-89b0-11e8-9fca-10f2e09e6511.png)




> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545964#comment-16545964
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202881043
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [length [characters]]
--- End diff --

`length [characters]` is optional.


![default](https://user-images.githubusercontent.com/20532956/42794015-5c111000-89af-11e8-821f-3153fadabbc5.png)



> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545369#comment-16545369
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202732987
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
-   | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
-   | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific] 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar (length [characters]) 
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+   | varchar2 (length [characters]) 
+  [CHARACTER SET char-set-name]
+  [UPSHIFT] [[NOT] CASESPECIFIC] 
+   | nchar [length [characters]]
--- End diff --

This should say, "nchar (length [characters])"


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545370#comment-16545370
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202732750
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
 
 column-definition is:
column-name data-type
-  ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+  [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
 
 data-type is:
  char[acter] [(length)[characters]]
--- End diff --

This should say, "char[acter] (length [characters])"


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-16 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16545368#comment-16545368
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1645#discussion_r202733241
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -756,6 +758,86 @@ Alter TABLE PRODUCT
 ALTER COLUMN vend_id RENAME TO cstm_id;
 ```
 
+* This example demonstrates the character set of NCHAR column cannot be 
altered.
--- End diff --

See my comments on https://github.com/apache/trafodion/pull/1644. 


> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Commented] (TRAFODION-3144) Correct Syntactic Descriptions of Character String Data Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference Manual*

2018-07-13 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16542884#comment-16542884
 ] 

ASF GitHub Bot commented on TRAFODION-3144:
---

GitHub user liuyu000 opened a pull request:

https://github.com/apache/trafodion/pull/1645

[TRAFODION-3144] Correct Syntactic Descriptions of Character String Data 
Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL 
Reference Manual*



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/liuyu000/trafodion AlterTableStatement_nchar

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1645.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1645


commit aec1a4694f400d5fda3288b3c6c443bc6fdde4dd
Author: liu.yu 
Date:   2018-07-13T10:56:34Z

[TRAFODION-3144] Correct Syntactic Descriptions of Character String Data 
Types and Add Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL 
Reference Manual*




> Correct Syntactic Descriptions of Character String Data Types and Add 
> Examples (NCHAR) for *ALTER TABLE Statement* in *Trafodion SQL Reference 
> Manual*
> --
>
> Key: TRAFODION-3144
> URL: https://issues.apache.org/jira/browse/TRAFODION-3144
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)