Here is my full bucket:
select * from `silver-spoon`
[
{
"silver-spoon": 12
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 19, 2017 1:25:51 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string9",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 1:52:01 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringt",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 2:07:51 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringm",
"featureDescription": "string",
"featureName": "string",
"id": "16"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 2:23:43 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "DELETE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 19, 2017 3:36:53 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 19, 2017 4:48:24 PM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 19, 2017 6:16:50 PM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string3",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 1:00:27 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string5",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 1:24:17 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string7",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 1:45:42 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": {
"history": {
"action": "CREATE",
"data": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string8",
"featureDescription": "string",
"featureName": "string"
}
},
"roles": [
"DEVELOPER"
],
"time": "Mar 28, 2017 1:47:57 AM",
"type": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity",
"user": "Abhideep"
}
}
},
{
"silver-spoon": 16
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string3",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string5",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string7",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string8",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string9",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringt",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringm",
"featureDescription": "string",
"featureName": "string",
"id": "16"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string2",
"featureDescription": "string",
"featureName": "string"
}
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-6"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-9"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-10"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-11"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-12"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-13"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-14"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-16"
}
},
{
"silver-spoon": {
"cbLookupDocumentkey": "com.fastserve.aawp.aawp.cb.entity.SubscriptionFeatureEntity-15"
}
}
]
This has 32 objects. Now when I execute following:
select subscriptionFeature from `silver-spoon`
I get this (Notice Result Count as 32 here) :
[
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string3",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string5",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string7",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string8",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string9",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringt",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "stringm",
"featureDescription": "string",
"featureName": "string",
"id": "16"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string",
"featureDescription": "string",
"featureName": "string"
}
},
{
"subscriptionFeature": {
"featureCategory": "string",
"featureCode": "string2",
"featureDescription": "string",
"featureName": "string"
}
},
{},
{},
{},
{},
{},
{},
{},
{},
{}
]
While if I get the count, I get 10.
Count is right. But if I add limit:
select subscriptionFeature from `silver-spoon` limit 5
I get this:
[
{},
{},
{},
{},
{}
]
MY question is why its is not giving the right documents and instead giving me blank document. Whats wrong ??