⬅ Forum: Building VoltDB Applications

We do not currently support the "IS NULL" SQL operator.

For now, you can get "IS NULL" functionality as follows:

1. Add "import org.voltdb.VoltType;" to your stored procedure.
2. Change your SQL statement to "... WHERE partitioned_col = ? AND other_col = ? ..."
3. Pass the appropriate data type's NULL representation (for "other_col") as a parameter when you queue the SQL statement. If you were using a BIGINT column you would use VoltType.NULL_BIGINT. Your call would look similar to "voltQueueSQL(sqlStmt, parmPartitionCol, VoltType.NULL_BIGINT).

The full list of NULL representations is available in src/frontend/org/voltdb/VoltType.java

-Tim

We do not currently support the "IS NULL" SQL operator.

For now, you can get "IS NULL" functionality as follows:

1. Add "import org.voltdb.VoltType;" to your stored procedure.
2. Change your SQL statement to "... WHERE partitioned_col = ? AND other_col = ? ..."
3. Pass the appropriate data type's NULL representation (for "other_col") as a parameter when you queue the SQL statement. If you were using a BIGINT column you would use VoltType.NULL_BIGINT. Your call would look similar to "voltQueueSQL(sqlStmt, parmPartitionCol, VoltType.NULL_BIGINT).

The full list of NULL representations is available in src/frontend/org/voltdb/VoltType.java

-Tim

Thanks. That's just what I was looking for.

I could make an extra column BUT THANKS...

To: desheikh/OMAIR

Please note that you are replying to a very old thread that contains outdated information.
Are you trying to research a specific issue of your own with a more recent version of the product?
If you'd like to provide details, we can try to help you with it.