OS and Hardware Information

Oct 13, 2025 by pinkandtrash.com 133 views

Introduction

DuckDB is an open-source relational database management system that provides a high-performance, in-memory database engine. However, like any other software, it is not immune to errors and bugs. In this article, we will discuss an internal error that occurs in DuckDB when using the "is not distinct from" operator in combination with the "or" operator. This error is specific to version 1.2.1 of DuckDB and is not present in earlier versions.

What Happens?

The internal error occurs when the "is not distinct from" operator is used in combination with the "or" operator. This is a regression in version 1.2 of DuckDB, which is still present in version 1.2.1. The error does not occur in version 1.1.3 of DuckDB. The error can be reproduced in the command-line interface (CLI), client APIs, or even in the shell.duckdb.org interface.

Reproducing the Error

To reproduce the error, you can use the following SQL query:

create table test as select 'tst' as tst; 
select * from test where tst is not distinct from 'a' or tst is not distinct from 'b';

This query creates a table with a single column "tst" and then selects all rows from the table where the value in the "tst" column is not distinct from either 'a' or 'b'. This query should raise an internal error in version 1.2.1 of DuckDB.

Error Message

The error message that is raised is:

INTERNAL Error:
Expression type not implemented for string statistics zone map

This error message indicates that an assertion failure has occurred within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.

OS and Hardware Information

The error was reported on a Windows 10 x86_64 system. The hardware information is not provided.

DuckDB Version and Client Information

The error was reported in version 1.2.1 of DuckDB. The client information is not provided.

Conclusion

In conclusion, the internal error "Expression type not implemented for string statistics zone map" occurs in version 1.2.1 of DuckDB when using the "is not distinct from" operator in combination with the "or" operator. This error is a regression in version 1.2 of DuckDB and is not present in earlier versions. To reproduce the error, you can use the SQL query provided above.

Recommendations

To resolve this issue, we recommend testing with the latest nightly build of DuckDB. If possible, please provide more information about your system and hardware configuration to help us reproduce and fix the issue.

Additional Information

For more information about internal errors in DuckDB, please refer to the official documentation at https://duckdb.org/docs/dev/internal_errors.

Troubleshooting Steps

If you are experiencing this error, please try the following troubleshooting steps:

Check the version of DuckDB you are using and ensure that it is up-to-date.
Try reproducing the error with the latest nightly build of DuckDB.
Provide more information about your system and hardware configuration to help us reproduce and fix the issue.

Q: What is the internal error "Expression type not implemented for string statistics zone map" in DuckDB?

A: The internal error "Expression type not implemented for string statistics zone map" is a bug in DuckDB that occurs when using the "is not distinct from" operator in combination with the "or" operator. This error is specific to version 1.2.1 of DuckDB and is not present in earlier versions.

Q: What causes this error?

A: The error is caused by an unexpected condition or error in the program's logic within DuckDB. This error is related to the implementation of string statistics zone maps in DuckDB.

Q: How can I reproduce this error?

A: To reproduce the error, you can use the following SQL query:

create table test as select 'tst' as tst; 
select * from test where tst is not distinct from 'a' or tst is not distinct from 'b';

Q: What is the error message that is raised?

A: The error message that is raised is:

INTERNAL Error:
Expression type not implemented for string statistics zone map

Q: What should I do if I encounter this error?

A: If you encounter this error, we recommend testing with the latest nightly build of DuckDB. If possible, please provide more information about your system and hardware configuration to help us reproduce and fix the issue.

Q: Is this error specific to a particular version of DuckDB?

A: Yes, this error is specific to version 1.2.1 of DuckDB. It is not present in earlier versions, such as version 1.1.3.

Q: Can I fix this error myself?

A: We do not recommend attempting to fix this error yourself, as it is a complex issue that requires expertise in DuckDB's internal implementation. Instead, we recommend testing with the latest nightly build of DuckDB and providing more information about your system and hardware configuration to help us reproduce and fix the issue.

Q: Where can I find more information about internal errors in DuckDB?

A: For more information about internal errors in DuckDB, please refer to the official documentation at https://duckdb.org/docs/dev/internal_errors.

Q: What are the troubleshooting steps I can take if I encounter this error?

A: If you are experiencing this error, please try the following troubleshooting steps:

Check the version of DuckDB you are using and ensure that it is up-to-date.
Try reproducing the error with the latest nightly build of DuckDB.
Provide more information about your system and hardware configuration to help us reproduce and fix the issue.

By following these steps, you should be able to resolve the internal error "Expression type not implemented for string statistics zone map" in DuckDB.