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

query with system function: "index"(varchar, boolean) fails with GDK error or assertion failure. #7238

Closed
mvdvm opened this issue Feb 3, 2022 · 2 comments
Labels
bug GDK Kernel
Milestone

Comments

@mvdvm
Copy link
Contributor

@mvdvm mvdvm commented Feb 3, 2022

Describe the bug
Select query with system function "index"(name, true) produces a GDK error:
createExceptionInternal: !ERROR: MALException:algebra.projection:GDK reported error: project1_bte: does not match always

Select query with system function "index"(name, false) triggers an assertion failure:
gdk/gdk_bat.c:2537: BATassertProps: Assertion `strcmp(b->theap->filename, filename) == 0' failed.

To Reproduce
compile mserver5 from Jan2022 branch and start it.
start mclient and run queries:
select name, "index"(name, true) nm_idx from sys.schemas order by nm_idx;
select name, "index"(name, false) nm_idx from sys.schemas order by nm_idx;

Expected behavior
+----------+--------+
| name | nm_idx |
+======+======+
| sys | 4 |
| tmp | 12 |
| json | 20 |
| profiler | 32 |
| wlc | 48 |
| wlr | 56 |
| logging | 64 |
+----------+--------+

Software versions

  • MonetDB version number: MonetDB 5 server v11.43.8 (hg id: 0768335463bb)
  • OS and version: Fedora 35
  • self-compiled with assertions enabled
@mvdvm mvdvm added bug GDK Kernel labels Feb 3, 2022
@PedroTadim
Copy link
Contributor

@PedroTadim PedroTadim commented Feb 3, 2022

We removed these functions on pushcands. We can remove them on default.

@sjoerdmullender
Copy link
Member

@sjoerdmullender sjoerdmullender commented Feb 4, 2022

Fixed in Jan2022 branch. We should probably indeed remove these on the default branch.

monetdb-team pushed a commit that referenced this issue Feb 4, 2022
@PedroTadim PedroTadim added this to the NEXTRELEASE milestone Feb 4, 2022
@sjoerdmullender sjoerdmullender removed this from the NEXTRELEASE milestone Feb 14, 2022
@sjoerdmullender sjoerdmullender added this to the Jan2022-SP1 milestone Feb 14, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug GDK Kernel
Projects
None yet
Development

No branches or pull requests

3 participants