Details
-
Bug
-
Resolution: Unresolved
-
Minor
-
7.2.0
-
7.2.0-5230
-
Untriaged
-
0
-
Unknown
Description
With hashjoin probe/build hint, we should improve error message if collection is not specified.
For example in the following cases (Same for build):
EXPLAIN SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r ON r.sourceairport /*+ hashjoin probe() */ = a.faa WHERE a.city = 'San Francisco' AND a.country = 'United States'; |
or
EXPLAIN SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route r ON r.sourceairport /*+ hashjoin probe */ = a.faa WHERE a.city = 'San Francisco' AND a.country = 'United States'; |
We get following error which should be more prescriptive e.g. missing collection name.
'hashjoin probe': 'Invalid specification for hint hashjoin. ASX1001: Syntax error: In line 1 >>probe<< Encountered <EOF> at column 5. (in line 1, at column 102)' |
|
'hashjoin build': 'Invalid specification for hint hashjoin. ASX1001: Syntax error: In line 1 >>build<< Encountered <EOF> at column 5. (in line 1, at column 102)', |
|
'hashjoin build()': 'Invalid specification for hint hashjoin. ASX1001: Syntax error: In line 1 >>build()<< Encountered ")" at column 7. (in line 1, at column 102)' |
|
'hashjoin probe()': 'Invalid specification for hint hashjoin. ASX1001: Syntax error: In line 1 >>probe()<< Encountered ")" at column 7. (in line 1, at column 102)', |