cockroachdb / cockroachdb/django-cockroachdb

Unsupported query: mixed type addition in SELECT

Open
#19 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
174
Forks
31
PR merge metrics
No merged PRs in 30d

Description

For example:
```
======================================================================
ERROR: test_mixed_type_annotation_numbers (annotations.tests.NonAggregateAnnotationTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/tim/code/django/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.InvalidParameterValue: unsupported binary operator: +
```
Is there a plan to add support?

The SQL adds integer and float columns in a `SELECT` clause:
```sql
SELECT ... ("annotations_book"."pages" + "annotations_book"."rating") AS "combined"
FROM "annotations_book"
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.