sxt-proof-of-sql icon indicating copy to clipboard operation
sxt-proof-of-sql copied to clipboard

Add nullable column support

Open JayWhite2357 opened this issue 5 months ago • 23 comments

Background and Motivation

Currently, we have not implemented support for columns with null values. This is a very useful and ubiquitous primitive for any database engine.

Changes Required

  • [ ] Support adding a flag (or some other mechanism) to the columns types in order to support nullable columns. Logically, this is the same as adding a new column datatype for each existing datatype.
  • [ ] Support existing operations on nullable columns. (e.g. we should be able to add a nullable bigint to a non-nullable bigint)

JayWhite2357 avatar Sep 25 '24 16:09 JayWhite2357