Uploaded image for project: 'Engineering'
  1. Engineering
  2. ENG-9283

Can't update DDL after partial creating index with comparison on timestamp column

    XMLWordPrintable

    Details

    • Team Backlog:
      CORE team
    • Release Note:
      Hide
      There was an issue in previous releases where, after creating a partial index involving a TIMESTAMP column, no further DDL statements were accepted by the database. This issue was specific to TIMESTAMP columns and partial indexes. That is, where the value of the TIMESTAMP column was used in a boolean expression, such as myTimestamp < '2001-01-01'. This problem has been resolved.
      Show
      There was an issue in previous releases where, after creating a partial index involving a TIMESTAMP column, no further DDL statements were accepted by the database. This issue was specific to TIMESTAMP columns and partial indexes. That is, where the value of the TIMESTAMP column was used in a boolean expression, such as myTimestamp < '2001-01-01'. This problem has been resolved.
    • Sprint:
      core66, core67

      Description

      create table t (i integer, ts timestamp);
      create index partial_ts_idx on t(ts) where ts > '2000-01-01';
      create index ts_idx on t(ts);

      Result: No DDL statements go through after the partial index is created:
      WARN: Unexpected error in adhoc or catalog update: class org.hsqldb_voltpatches.HsqlException, incompatible data types in combination
      org.hsqldb_voltpatches.HsqlException: incompatible data types in combination
      at org.hsqldb_voltpatches.Error.error(Error.java:111)
      at org.hsqldb_voltpatches.Error.error(Error.java:81)
      at org.hsqldb_voltpatches.ExpressionLogical.resolveTypesForComparison(ExpressionLogical.java:682)
      at org.hsqldb_voltpatches.ExpressionLogical.resolveTypes(ExpressionLogical.java:492)
      at org.hsqldb_voltpatches.Expression.voltGetExpressionXML(Expression.java:1984)
      at org.hsqldb_voltpatches.index.IndexAVL.voltGetIndexXML(IndexAVL.java:1718)
      at org.hsqldb_voltpatches.Table.voltGetTableXML(Table.java:2693)
      at org.hsqldb_voltpatches.HSQLInterface.getXMLForTable(HSQLInterface.java:568)
      at org.hsqldb_voltpatches.HSQLInterface.runDDLCommandAndDiff(HSQLInterface.java:217)
      at org.voltdb.compiler.DDLCompiler.loadSchema(DDLCompiler.java:211)
      at org.voltdb.compiler.VoltCompiler.compileDatabase(VoltCompiler.java:1148)
      at org.voltdb.compiler.VoltCompiler.compileDatabaseNode(VoltCompiler.java:1110)
      at org.voltdb.compiler.VoltCompiler.compileCatalogInternal(VoltCompiler.java:916)
      at org.voltdb.compiler.VoltCompiler.compileInternal(VoltCompiler.java:658)
      at org.voltdb.compiler.VoltCompiler.compileInMemoryJarfileWithNewDDL(VoltCompiler.java:2232)
      at org.voltdb.compiler.AsyncCompilerAgentHelper.addDDLToCatalog(AsyncCompilerAgentHelper.java:252)
      at org.voltdb.compiler.AsyncCompilerAgentHelper.prepareApplicationCatalogDiff(AsyncCompilerAgentHelper.java:115)
      at org.voltdb.compiler.AsyncCompilerAgent.dispatchCatalogChangeWork(AsyncCompilerAgent.java:326)
      at org.voltdb.compiler.AsyncCompilerAgent.handleAdHocPlannerWork(AsyncCompilerAgent.java:278)
      at org.voltdb.compiler.AsyncCompilerAgent.handleMailboxMessage(AsyncCompilerAgent.java:137)
      at org.voltdb.compiler.AsyncCompilerAgent$1$1.run(AsyncCompilerAgent.java:106)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
      at java.util.concurrent.FutureTask.run(FutureTask.java:262)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      at org.voltcore.utils.CoreUtils$7$1.run(CoreUtils.java:735)
      at java.lang.Thread.run(Thread.java:744)

      Note: If this is the integer column it works fine:
      create index partial_i_idx on t where i > 2;

        Attachments

          Activity

            People

            Assignee:
            pmartel Paul Martel
            Reporter:
            rmorgenstein Ruth Morgenstein
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support