Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
6.5.0
-
Untriaged
-
Centos 64-bit
-
Yes
Description
Build: 6.5.0-3994
Assume, we have pretty simple bucket in couchbase instance, containing just 3 docs:
[
|
{
|
"varchar_field1": "oALDoptAQw" |
},
|
{
|
"varchar_field1": "jaHVuOoPaC" |
},
|
{
|
"varchar_field1": "pYYMXixekX" |
}
|
]
|
and corresponding data in mysql instance.
Then run the following queries:
n1ql:
SELECT varchar_field1, POSITION(varchar_field1, "o") FROM simple_table_db_58108062_simple_table where varchar_field1 in ['oALDoptAQw', 'pYYMXixekX', 'jaHVuOoPaC'] |
which gives the following results:
[
|
{
|
"$1": 0, |
"varchar_field1": "oALDoptAQw" |
},
|
{
|
"$1": 6, |
"varchar_field1": "jaHVuOoPaC" |
},
|
{
|
"$1": -1, |
"varchar_field1": "pYYMXixekX" |
}
|
]
|
and corresponding mysql query:
SELECT varchar_field1, POSITION( "o" IN varchar_field1) FROM simple_table where varchar_field1 in ('oALDoptAQw', 'pYYMXixekX', 'jaHVuOoPaC'); |
which gives the following results:
|
+----------------+----------------------------------+
|
| varchar_field1 | POSITION( "o" IN varchar_field1) | |
+----------------+----------------------------------+
|
| oALDoptAQw | 1 | |
| jaHVuOoPaC | 7 | |
| pYYMXixekX | 0 | |
+----------------+----------------------------------+
|
We see that mysql results are shifted by +1 compare to couchbase results.