# Select statement not showing all bins at client aql

**URL:** <https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656>\
**Category:** AQL\
**Created:** [September 28, 2017, 11:56am UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656 "2017-09-28T11:56:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nikhil\_bandal](https://avatars.discourse-cdn.com/v4/letter/n/65b543/32.png) [@nikhil\_bandal](https://discuss.aerospike.com/u/nikhil_bandal)\
**Post date:** [September 28, 2017, 11:56am UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656/1 "2017-09-28T11:56:08Z")

</div>

I have install aerospike on one server and client on another server and insert a record from server side AQL. Inserted record have 55 bins, when i query it from server side aql it shows all 55 bins for that record, but if when i query the same record from client side it shows only 32 bins.

Not sure what is the issue, can someone please suggest.

Server version - aerospike-server-enterprise-3.14.1.4-1.el7.x86\_64 Client version - aerospike-client-c-devel-4.1.5-1.el7.x86\_64

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [September 28, 2017, 9:46pm UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656/2 "2017-09-28T21:46:21Z")

</div>

Can you please show the select statements, host target, and output from both AQL and the client code? Is there a “WHERE” clause, or is this purely a scan? You are using aerospike-client-c-devel-4.1.5-1.el7.x86\_64 for your own code, correct?

---

<div class="post-metadata">

**Author:** ![nikhil\_bandal](https://avatars.discourse-cdn.com/v4/letter/n/65b543/32.png) [@nikhil\_bandal](https://discuss.aerospike.com/u/nikhil_bandal)\
**Post date:** [September 29, 2017, 10:25am UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656/3 "2017-09-29T10:25:44Z")

</div>

Hello,

I confirm, using “aerospike-client-c-devel-4.1.5-1.el7.x86\_64” for my C code Further, the Select is based on PK.

Attached snaps for both the output: (1) First one is server output

 ![server](https://us1.discourse-cdn.com/flex019/uploads/aerospike/original/1X/2c44b46dd6eeb84aca2591bf473e0f2c7099c1f9.PNG)

(2) Second shows client output.

 ![client](https://us1.discourse-cdn.com/flex019/uploads/aerospike/original/1X/4e368cd4ccb874d8afbbd38c409a56de2748899d.PNG)

Further, following are the packages at server end: aerospike-client-c-devel-4.1.5-1.el7.x86\_64 aerospike-tools-3.13.0.1-1.el7.x86\_64 aerospike-amc-community-4.0.12-1.x86\_64 aerospike-server-enterprise-3.14.1.4-1.el7.x86\_64

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [September 29, 2017, 5:41pm UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656/4 "2017-09-29T17:41:15Z")

</div>

Can you run the AQL statement with the same -h option from the server?

---

<div class="post-metadata">

**Author:** ![nikhil\_bandal](https://avatars.discourse-cdn.com/v4/letter/n/65b543/32.png) [@nikhil\_bandal](https://discuss.aerospike.com/u/nikhil_bandal)\
**Post date:** [October 4, 2017, 5:57am UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656/5 "2017-10-04T05:57:12Z")

</div>

I resolve the problem, it happen because of the server and client version mismatch, after upgrading the client version (3.12.0) to server version (3.13.0.1) it’s working fine.