ArcadeDB Version: v22.12.1
JDK Version: openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment Corretto-11.0.12.7.1 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM Corretto-11.0.12.7.1 (build 11.0.12+7-LTS, mixed mode)
OS: CentOS release 6.9 (Final)
Expected behavior
If a query against a type is executed, the Console should display a column for each property defined for that type, regardless of the value.
Actual behavior
If the query returns a set of records for which the values of a property are null, the Console only shows columns for which there is at least one property value which is not null.
Steps to reproduce
- start ArcadeDB
- start the Console and connect to the server
- create a database
- create a type Order
- create the following properties (all of type String): processor, vstart, vstop, pstart, pstop, status, node
- insert a record for which some of the properties are null
- execute a select on the type and verify that it does not contain the columns corresponding to the properties that have a value = null
This is the result of my test (I have written [@]rid using square brackets to avoid mentioning the GitHub user called rid):
`> select from Order
Command executed in 2ms
insert into Order set processor = 'SIR1LRM-7.1', vstart = '20220319_002624.404379', vstop = '20220319_002826.525650', pstart = null, pstop = null, status = 'PENDING', node = null
DOCUMENT @type:Order [@]rid:#14:4
+---------+----------------------+
|NAME |VALUE |
+---------+----------------------+
|vstart |20220319_002624.404379|
|vstop |20220319_002826.525650|
|processor|SIR1LRM-7.1 |
|status |PENDING |
+---------+----------------------+
Command executed in 2ms
select from Order
DOCUMENT @type:Order [@]rid:#14:4
+---------+----------------------+
|NAME |VALUE |
+---------+----------------------+
|vstart |20220319_002624.404379|
|vstop |20220319_002826.525650|
|processor|SIR1LRM-7.1 |
|status |PENDING |
+---------+----------------------+
Command executed in 3ms
`
ArcadeDB Version: v22.12.1
JDK Version: openjdk version "11.0.12" 2021-07-20 LTS
OpenJDK Runtime Environment Corretto-11.0.12.7.1 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM Corretto-11.0.12.7.1 (build 11.0.12+7-LTS, mixed mode)
OS: CentOS release 6.9 (Final)
Expected behavior
If a query against a type is executed, the Console should display a column for each property defined for that type, regardless of the value.
Actual behavior
If the query returns a set of records for which the values of a property are null, the Console only shows columns for which there is at least one property value which is not null.
Steps to reproduce
This is the result of my test (I have written [@]rid using square brackets to avoid mentioning the GitHub user called rid):
`> select from Order
Command executed in 2ms
DOCUMENT @type:Order [@]rid:#14:4
+---------+----------------------+
|NAME |VALUE |
+---------+----------------------+
|vstart |20220319_002624.404379|
|vstop |20220319_002826.525650|
|processor|SIR1LRM-7.1 |
|status |PENDING |
+---------+----------------------+
Command executed in 2ms
DOCUMENT @type:Order [@]rid:#14:4
+---------+----------------------+
|NAME |VALUE |
+---------+----------------------+
|vstart |20220319_002624.404379|
|vstop |20220319_002826.525650|
|processor|SIR1LRM-7.1 |
|status |PENDING |
+---------+----------------------+
Command executed in 3ms
`