Are you able to reproduce this issue using SQL only? Could you share the DDL, insert and select statements that lead to the described issue?
I tried the following queries, but they work as expected. CREATE TABLE people (id int PRIMARY key, first_name varchar, last_name varchar); INSERT INTO people (id, first_name, last_name) VALUES (1, 'John', 'Doe'); INSERT INTO people (id, first_name, last_name) VALUES (2, 'John', 'Foe'); SELECT id FROM people; Denis On 17 Oct 2019, 09:02 +0300, Kurt Semba <kse...@extremenetworks.com>, wrote: > Hi all, > > Is it possible for a table through the SQL interface to only return some > subset of data if querying against a specific column? > > e.g. > > We have a cache configuration defined based on Java SQL Query annotations > that contains an id field and some other string fields. The value of the id > field in all entries also matches the value of the cache entry key). > > The table contains 3 entries, however if I execute “select id from table” > through sqlline, I only am able to see 1 entry. However, if I execute “select > id, name from table”, I see all of them. > > Are there any steps I can take to better diagnose this? > > Thank you > Kurt >
