Skip to content

Console does not show property column in SELECT result if returned property values are null #731

@vic0824

Description

@vic0824

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

  1. start ArcadeDB
  2. start the Console and connect to the server
  3. create a database
  4. create a type Order
  5. create the following properties (all of type String): processor, vstart, vstop, pstart, pstop, status, node
  6. insert a record for which some of the properties are null
  7. 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

`

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions