37.3    SQL Syntax: Where
  • HFQL: Direct SQL Access
  • 37.0 HFQL/SQL Overview
  • 37.1 SQL Syntax
  • 37.2 SQL Syntax: Select
  • 37.3 SQL Syntax: Where
  • 37.4 SQL Syntax: Limitations
  • 37.5 SQL Syntax: Examples
    • 37.5    SQL Syntax: Examples   
       Table of Contents

    SQL Syntax: Limitations

    37.4.1SQL Syntax Limitations

     

    The following known limitations apply to the HFQL SQL syntax. These limitations are not considered permanent or unsolvable, but were implemented for practical reasons. Please get in touch if you have use cases that they are restricting, or if you would like to help address them.

    • When using GROUP BY expressions, the query will fail if more than 10000 unique values are found to group by.

    • When using ORDER BY expressions, the query will fail if more than 10000 values are found to order by.

    37.4.2Syntax Limitations

     

    • Expressions with WHERE clauses do not support parentheses or OR statements, only AND statements.

    • JOIN statements are not supported.

    • Comments are not currently supported

       37.3    SQL Syntax: Where
  • HFQL: Direct SQL Access
  • 37.0 HFQL/SQL Overview
  • 37.1 SQL Syntax
  • 37.2 SQL Syntax: Select
  • 37.3 SQL Syntax: Where
  • 37.4 SQL Syntax: Limitations
  • 37.5 SQL Syntax: Examples
    • 37.5    SQL Syntax: Examples