Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
Untriaged
-
1
-
Unknown
Description
Issue found in 7.0.0-3644 CE
Following query is expected to throw an user friendly error in CE - but it returns empty results:
SELECT ADVISOR("SELECT * from `travel-sample` where country is not null")
|
|
[
|
{
|
"$1": {}
|
}
|
]
|
Same query when executed with ADVISE throws an error as expected :
ADVISE SELECT * from `travel-sample` where country is not null;
|
|
[
|
{
|
"code": 3230,
|
"msg": "Advise is enterprise level feature.",
|
"query": "ADVISE SELECT * from `travel-sample` where country is not null;"
|
}
|
]
|
it will be good to keep the error message consistent between these two - same select advisor query in EE returns results as expected:
SELECT ADVISOR("SELECT * from default where name is not null")
|
|
[
|
{
|
"$1": {
|
"recommended_indexes": [
|
{
|
"index": "CREATE INDEX adv_name ON `default`:`travel-sample`.`_default`.`default`(`name`)",
|
"statements": [
|
{
|
"run_count": 1,
|
"statement": "SELECT * from default where name is not null"
|
}
|
],
|
"update_statistics": ""
|
}
|
]
|
}
|
}
|
]
|