guyfedwards commented on issue #1922: URL: https://github.com/apache/cassandra-gocql-driver/issues/1922#issuecomment-3696635039
A bit more debugging and I'm somewhat even more confused although I wonder if it's more to do with my lack of understanding. Running the following returns the correct result: ```go SELECT request_id FROM requests WHERE id = ? ``` Then adding more columns slowly reduces the number of results, e.g. ```go SELECT request_id, secondcolumn FROM requests WHERE id = ? ``` This returns ~600 less results than the single column query. This is however consistent with querying directly with cqlsh so that's at least something. I don't quite understand why `select count(*)...` would return the correct number of results but `select *...` would return a subset and likewise `select x,y,z ...` reducing results with each additional column. For info, in the test database all columns apart from id, cassandra_unixhour, request_id, request_received are null which means it's not just excluding rows that are missing the column. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
