influxdata / influxdata/influxdb
SELECT * query do not show all the fields within a table
- 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
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