Follow

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

Overview:

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

0 Comments

Please sign in to leave a comment.