Empty N1QL Response

n1ql
query

#1

i am wondering scince 4 Hours i get on some querys simply empty responses but thats not true or possible i think there is a error that dont gets errored or so:

‘SELECT COUNT(*) total, meta().id cbKey, * FROM dscms AS value USE INDEX (id_ix USING GSI) WHERE meta().id LIKE ‘video%’’

for example returns null ‘[]’ but as i at last selected COUNT it must return!!! null '[{"$1":0}]'
if it dont finds documents and should return null ‘[{"$1":0}]’ with real count if it has matches


#2

this post dont includes my used backticks i used backtickts for the things like value and so to work probally


#3
N1qlStringQuery {
options: { statement: 'SELECT COUNT(*) `total`, meta().id FROM dscms USE INDEX (`id_ix` USING GSI) WHERE  meta().id LIKE \'video_#%\'' },
isAdhoc: true }
null '[{"id":"video_#xxxxxxxxx_#02EF2E03A1A6089E4ECE933024E2A155","total":429693}]'

N1qlStringQuery {
options: { statement: 'SELECT COUNT(*) `total`, meta().id FROM `dscms` USE INDEX (`id_ix` USING GSI)' },
isAdhoc: true }
null '[]'

#4

I found out the following if i select * from a bucket that has a lot of documents the response is empty when i limit the filds it works so this error with empty response depends some how on query size of the result set or something like that but dont found settings for that added extra ram to index and bucket don’t helps.