Support for Null values

GSQL
1

Does TigerGraph support null values? or It just updates it with default values if nothing is provided for a particular property.

Say, we have a middle name field, and a person does not have one, so will it use the default "" or will there be nothing?

2

I don’t believe that GSQL utilizes null values. Fields are typically initialized to empty/default values following their declarations (including accumulators).

Examples include:

  • 0
  • “” (empty string)
  • false

Here are the exact specifications for primitive default values:
https://docs.tigergraph.com/dev/gsql-ref/ddl-and-loading/system-and-language-basics#primitive-types

And also for accumulators (Table Ac1 - Accumulator Types and Behavior):
https://docs.tigergraph.com/dev/gsql-ref/querying/accumulators#accumulator-types

1 Like