googleapis / googleapis/google-cloud-python

Underscore Prepended to Numeric Column Labels

Abierto
#15,780 5 comentarios 1 reacción 1 asignado Asignado a @chalmerlowe Ver en GitHub
api: bigquery priority: p3 type: question
Lenguaje dominante
Python
Estrellas
5.4k
Forks
1.8k
Merge medio
3 d 4 h
PR fusionados (30 d)
122

Descripción

#### Environment details

- OS type and version: MacOS Sonoma 4.5 (23F79)
- Python version: `3.11.6`
- pip version: `23.3.1
- `sqlalchemy-bigquery` version: `1.11.0`

#### Steps to reproduce

1. Attempt to label a column with a numeric column name (with or without quoted_name)
2. Get the cursor description for this column. The name has a prepended underscore

#### Code example

```python
import sqlalchemy as sa
engine = ****insert engine creation here****

with engine.connect() as conn:
a = sa.literal("a")
labeled_col = a.label(sa.sql.quoted_name("2", quote=True))
res = conn.execute(sa.select(labeled_col))
name = res.cursor.description[0].name

res_2 = conn.execute("SELECT 'a' AS `2`")
name_2 = res_2.cursor.description[0].name

assert name == name_2 == "2"
```

#### Stack trace
```
AssertionError: assert '_2' == '2'
```

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.