SQL-0002: No Results When Using "IN" on Indexed Nullable Column


When a column is defined of type nullable and is indexed, trying to select data using the 'in' clause will cause Kinetica to return no results.


Example Use Case:

1. Create table Test with a nullable and indexed column:

2. Insert values into table:

3. Select from the table using 'in' clause:


Solution / Workaround:

This is a known issue and has been fixed in version 6.1 GA 15 and 6.2 GA 3 or newer.

For customers unable to immediately upgrade:

  • Removing the index will allow the 'in' clause to work successfully
  • Using a 'not-null' column will also allow the 'in' clause to work successfully


Additional Information:

  • Affects Version(s):
    • 6.1 GA 14 or older
    • 6.2 GA 2 or older


Should you have any questions or concerns, please visit our Official Documentation and Support Page.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.