Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104

Enable Phoenix test cases with Calcite-Phoenix

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Task
    • Status: In Progress
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      The following Jenkins job is run daily to track our progress: https://builds.apache.org/job/Phoenix-calcite/

      Attachments

        1.
        		 Support "EXPLAIN" grammar as a shorthand for "EXPLAIN PLAN FOR" Sub-task Resolved Wei Xue Actions
        2.
        		 Date/Time/Timestamp bidirectional conversion between Avatica and Phoenix Sub-task Resolved Wei Xue Actions
        3.
        		 Change test driver to use Calcite-Phoenix Sub-task Resolved Wei Xue Actions
        4.
        		 Make default Calcite-Phoenix JDBC driver compatible with standalone Phoenix driver interfaces Sub-task Open Wei Xue Actions
        5.
        		 Allow comma before CONSTRAINT to be optional Sub-task Resolved Eric Lomore Actions
        6.
        		 Allow TRUE and FALSE to be used as literal constants Sub-task Resolved Eric Lomore Actions
        7.
        		 Double-quote column names that use reserved keywords Sub-task Resolved Eric Lomore Actions
        8.
        		 Remove usage of bind variables in CREATE TABLE ... SPLIT ON (?,?,?) Sub-task Open Eric Lomore Actions
        9.
        		 Replace use of SELECT null with CAST(null AS <type>) Sub-task Resolved Eric Lomore Actions
        10.
        		 Fix CalciteIT CalciteGlobalIndexIT CalciteLocalIndexIT regressions Sub-task Resolved Wei Xue Actions
        11.
        		 Support both "!=" and "<>" in Calcite-Phoenix Sub-task Resolved Wei Xue Actions
        12.
        		 Track incompatibilities between Calcite/Phoenix and Phoenix Sub-task Open Unassigned Actions
        13.
        		 Create Table: Single column primary key may not be null Sub-task Resolved Eric Lomore Actions
        14.
        		 Schema update is not visible to following statements of the same connection due to CalciteSchema caching. Sub-task Resolved Wei Xue Actions
        15.
        		 SQLException code's not propagating as expected Sub-task Resolved Eric Lomore Actions
        16.
        		 Set conformance level to PhoenixSqlConformance Sub-task Resolved Wei Xue Actions
        17.
        		 Enable utility functions for SELECT queries Sub-task Resolved Eric Lomore Actions
        18.
        		 Implement TODOs in PhoenixTableModify#upsert to allow writes to tenant specific tables Sub-task Resolved Rajeshbabu Chintaguntla Actions
        19.
        		 USER keyword in calcite used as column name in some it tests Sub-task Resolved Rajeshbabu Chintaguntla Actions
        20.
        		 Update JDBC urls to match connection type Sub-task Open Unassigned Actions
        21.
        		 ConcurrentModificationException from PhoenixSchema in adding secondary indexes Sub-task Resolved Wei Xue Actions
        22.
        		 Replace usage of bind variables in BaseTest.createTestTable() Sub-task Open Unassigned Actions
        23.
        		 Handle SequenceResolving through ConnectionQueryServices interface Sub-task Resolved Eric Lomore Actions
        24.
        		 Calcite doesn't recognize SYSTEM table Sub-task Resolved Unassigned Actions
        25.
        		 Resolve sequence incompatibilities in phoenix-calcite Sub-task Open Eric Lomore Actions
        26.
        		 Calcite has specific requirements for date and datetime operations Sub-task Open Unassigned Actions
        27.
        		 PhoenixTableModify calls on ResultSet for unit tests Sub-task Open Unassigned Actions
        28.
        		 Add StatementContext instance in PhoenixImplementorImpl Sub-task Resolved Wei Xue Actions
        29.
        		 Double quote SYSTEM, USER,DATE keywords in IT tests Sub-task Resolved Rajeshbabu Chintaguntla Actions
        30.
        		 Allow accessing full (legacy) Phoenix EXPLAIN information via Calcite Sub-task Open Gabriel Reid Actions
        31.
        		 Support sequence arithmetic in Calcite-Phoenix Sub-task Resolved Eric Lomore Actions
        32.
        		 Execute DDLs with normal statement than preparedStatement Sub-task Open Rajeshbabu Chintaguntla Actions
        33.
        		 Handle row timestamp columns properly in phoenix calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        34.
        		 Class-cast exceptions caused by TestUtil.getSplits() and TestUtil.getGuidePostsList() Sub-task Resolved Wei Xue Actions
        35.
        		 CREATE TABLE with immutable rows property is failing in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        36.
        		 Fix CREATE TABLE DDL parsing issues in Phoenix Calcaite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        37.
        		 Many tests failing for not resolving table name properly in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        38.
        		 Many tests failing for not resolving table name properly in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        39.
        		 Not able resolve columns in predicate while querying views in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        40.
        		 Fix issues with Split keys and Replace bind values with actual split keys in CREATE TABLE DDL in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        41.
        		 Fix parsing issues in CREATE VIEW DDL in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        42.
        		 Resolve Date/Time/Timestamp incompatibility in bind variables Sub-task Resolved Wei Xue Actions
        43.
        		 Upsert or Delele queries failing to translate LogicalTableModify into MutableRel in Phoenix-Calcite Sub-task Resolved Wei Xue Actions
        44.
        		 Add missing aggregate functions like AVG,STDDEV_POP in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        45.
        		 Support CASE statements in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        46.
        		 CURRENT_DATE and CURRENT_TIME cannot be resolved in Phoenix-Calcite Sub-task Resolved Unassigned Actions
        47.
        		 Support declaring default values in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        48.
        		 Old value is overwriting with null when latest upsert has missing columns from the index in Phoenix-Calcite. Sub-task Open Rajeshbabu Chintaguntla Actions
        49.
        		 YEAR/MONTH/DAY/HOUR/MINUTES/SECOND built-in functions do not work in Calcite-Phoenix Sub-task Resolved Wei Xue Actions
        50.
        		 UPSERT with literal values into unsigned columns does not work Sub-task Open Wei Xue Actions
        51.
        		 Implement getConnectioInfo methods in PhoenixCalciteConnection Sub-task Resolved Rajeshbabu Chintaguntla Actions
        52.
        		 Double quote tracing table column tags.count in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        53.
        		 Table in PhoenixTable#tableMapping is getting replaced by original PTable after commit in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        54.
        		 Column alias can't be resolved in GROUP BY clause Sub-task Resolved Rajeshbabu Chintaguntla Actions
        55.
        		 Can't use original table name to prefix a column once the table is associated with an alias Sub-task Open Wei Xue Actions
        56.
        		 Replace name parameter for ResultSet.getXXX(String name) with Calcite column names Sub-task Open Wei Xue Actions
        57.
        		 Calcite-Phoenix exceptions do not match error code or specific SQLException sub-classes Sub-task Open Rajeshbabu Chintaguntla Actions
        58.
        		 Support AVG aggregate function and disable AggregateReduceFunctionsRule Sub-task Open Wei Xue Actions
        59.
        		 Infinite loop in local index tests having filters on non indexed columns in Phoenix-Calcite Sub-task Resolved Wei Xue Actions
        60.
        		 Upserts into salted table are failing in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        61.
        		 Add Row-Value-Constructor support Sub-task Resolved Wei Xue Actions
        62.
        		 CREATE SEQUENCE query parsing failed when INCREMENT BY negative values in Phoenix-Calcite Sub-task Patch Available Ashish Misra Actions
        63.
        		 CREATE TABLE parsing failed with COLUMN_ENCODED_BYTES=NONE property in Phoenix-Calcite Sub-task Open Ashish Misra Actions
        64.
        		 Avoid creating a cast for ROW data type Sub-task Resolved Wei Xue Actions
        65.
        		 Fix 'Phoenix schema not found' error Sub-task Resolved Wei Xue Actions
        66.
        		 Double quote SYSTEM, USER,DATE keywords in some more IT tests Sub-task Resolved Rajeshbabu Chintaguntla Actions
        67.
        		 Not able to resolve sequences in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        68.
        		 Assertion failure in ConnectionQueryServicesTestImpl#close making failed tests not listed for Phoenix-Calcite branch in Jenkins Sub-task Open Rajeshbabu Chintaguntla Actions
        69.
        		 Implement setDate in PhoenixCalcitePreparedStatement to pass java.sql.Date as java.util.Date till PHOENIX-868 is fixed Sub-task Open Rajeshbabu Chintaguntla Actions
        70.
        		 Views/Index related tests are failing with NoSuchMethodError because of guava incompatibility in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        71.
        		 BigDecimal cannot set as object for parametrised queries in Phoenix-Calcite Sub-task Open Rajeshbabu Chintaguntla Actions
        72.
        		 Illegal Data exception is throwing in upserts involving PChar columns in Phoenix-Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        73.
        		 Unspecified columns in upsert are writing as nulls in Phoenix-Caclite Sub-task Open Rajeshbabu Chintaguntla Actions
        74.
        		 PDataType to Calcite type conversion should consider whether precision or scale allowed for type in Calcite Sub-task Resolved Rajeshbabu Chintaguntla Actions
        75.
        		 Index expressions are considered as columns in Phoenix-Calcite so parsing is failing Sub-task Open Rajeshbabu Chintaguntla Actions
        76.
        		 Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME Sub-task Open Rajeshbabu Chintaguntla Actions
        77.
        		 Set the right parent schema for schema snapshots Sub-task Open Wei Xue Actions
        78.
        		 Isolate materialization optimization from Volcano planning process Sub-task Resolved Wei Xue Actions

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            maryannxue Wei Xue
            maryannxue Wei Xue
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment