Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UnsupportedOperationException on SELECT DISTINCT PERIOD #4263

Closed
Akeboshiwind opened this issue Mar 12, 2025 · 0 comments
Closed

UnsupportedOperationException on SELECT DISTINCT PERIOD #4263

Akeboshiwind opened this issue Mar 12, 2025 · 0 comments
Assignees
Milestone

Comments

@Akeboshiwind
Copy link
Contributor

This is on edge:

16:35:39 | DEBUG xtdb.pgwire | Interpreting SQL:  SELECT DISTINCT PERIOD(TIMESTAMP '2024-01-01Z', TIMESTAMP '2024-01-02Z');
16:35:39 | ERROR xtdb.pgwire | #error {
 :cause xtdb.vector.extensions.TsTzRangeVector
 :via
 [{:type java.lang.UnsupportedOperationException
   :message xtdb.vector.extensions.TsTzRangeVector
   :at [xtdb.vector.ValueVectorReader unsupported ValueVectorReader.java 97]}]
 :trace
 [[xtdb.vector.ValueVectorReader unsupported ValueVectorReader.java 97]
  [xtdb.vector.ValueVectorReader getBytes ValueVectorReader.java 142]
  [xtdb.vector.ValueVectorReader hashCode0 ValueVectorReader.java 87]
  [xtdb.vector.ValueVectorReader hashCode ValueVectorReader.java 93]
  [xtdb.expression.map$$reify__25924 hashCode map.clj 31]
  [xtdb.expression.map$$reify$reify__26018 addIfNotPresent map.clj 242]
  [xtdb.operator.set.DistinctCursor$reify__27641 accept set.clj 185]
  [xtdb.operator.project.ProjectCursor$reify__26567 accept project.clj 133]
  [xtdb.operator.table.TableCursor$fn__27772 invoke table.clj 36]
  [xtdb.operator.table.TableCursor tryAdvance table.clj 34]
  [xtdb.operator.project.ProjectCursor tryAdvance project.clj 119]
  [xtdb.operator.set.DistinctCursor tryAdvance set.clj 176]
  [xtdb.query$wrap_cursor$reify__29370 tryAdvance query.clj 92]
  [xtdb.pgwire$cmd_exec_query invokeStatic pgwire.clj 1344]
  [xtdb.pgwire$cmd_exec_query invoke pgwire.clj 1333]
  [xtdb.pgwire$execute_portal invokeStatic pgwire.clj 1753]
  [xtdb.pgwire$execute_portal invoke pgwire.clj 1716]
  [xtdb.pgwire$eval31220$fn__31223$fn__31226$fn__31231 invoke pgwire.clj 1792]
  [xtdb.pgwire$eval31220$fn__31223$fn__31226 invoke pgwire.clj 1778]
  [xtdb.pgwire$eval31220$fn__31223 invoke pgwire.clj 1770]
  [clojure.lang.MultiFn invoke MultiFn.java 234]
  [xtdb.pgwire$handle_msg invokeStatic pgwire.clj 1827]
  [xtdb.pgwire$handle_msg invoke pgwire.clj 1821]
  [xtdb.pgwire$conn_loop invokeStatic pgwire.clj 1863]
  [xtdb.pgwire$conn_loop invoke pgwire.clj 1834]
  [xtdb.pgwire$connect invokeStatic pgwire.clj 1913]
  [xtdb.pgwire$connect invoke pgwire.clj 1873]
  [xtdb.pgwire$accept_loop$fn__31298$fn__31299$fn__31300 invoke pgwire.clj 1957]
  [clojure.lang.AFn run AFn.java 22]
  [java.util.concurrent.Executors$RunnableAdapter call Executors.java 572]
  [java.util.concurrent.FutureTask run FutureTask.java 317]
  [java.util.concurrent.ThreadPoolExecutor runWorker ThreadPoolExecutor.java 1144]
  [java.util.concurrent.ThreadPoolExecutor$Worker run ThreadPoolExecutor.java 642]
  [java.lang.Thread run Thread.java 1583]]}

Vs beta6 on play where it works fine.

@Akeboshiwind Akeboshiwind added this to 2.x Mar 12, 2025
@github-project-automation github-project-automation bot moved this to 💭 Backlog in 2.x Mar 12, 2025
@mbutlerw mbutlerw moved this from 💭 Backlog to 🔖 Selected in 2.x Mar 13, 2025
@mbutlerw mbutlerw self-assigned this Mar 13, 2025
@mbutlerw mbutlerw moved this from 🔖 Selected to 🏗 In progress in 2.x Mar 13, 2025
@FiV0 FiV0 self-assigned this Mar 13, 2025
@FiV0 FiV0 closed this as completed in 5ad56f2 Mar 13, 2025
@github-project-automation github-project-automation bot moved this from 🏗 In progress to ✅ Done in 2.x Mar 13, 2025
@jarohen jarohen added this to the 2.0.0-beta7 milestone Mar 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Archived in project
Development

No branches or pull requests

4 participants