influxdata / influxdata/influxdb

SELECT * query do not show all the fields within a table

Open
#27,371 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

## Describe Development Experience Issue:

I do not see all the columns when I query: "SELECT * FROM table".

Currently, I have the following schema: timestamp, signal_name, value_int, value_real, value_float.

When I query "SELECT * FROM table", I see only one field, either of value_int or value_bool or value_float under the output console. I understand not all fields have data at any given timestamp, but it would be better to see all the columns for better visualization.

These columns wont even appear when I explicitly use their field names within SELECT statement. This would be sometimes misleading.

### Steps to reproduce:

1. Create a table with more than 3 columns (timestamp, one tag, 2 or more fields)
2. Make sure at a given timestamp, only one of the field has data
3. Query for all the data within the table
4. Output consists of only one field

### Desired result:

Output conole should list all the fields/columns present in the table, with horizontal scrolling enabled.

### Actual result:

Output console displays only one field.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported schema and SELECT * query, then trace the query result through the output console. Confirm that explicitly selected fields and fields with no value at a timestamp are still represented, and that the console shows all columns with horizontal scrolling.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.