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

Text Function !~ doesnt work when used with single character #505

Closed
mick2004 opened this issue Jul 14, 2020 · 1 comment
Closed

Text Function !~ doesnt work when used with single character #505

mick2004 opened this issue Jul 14, 2020 · 1 comment

Comments

@mick2004
Copy link
Contributor

Describe the bug
Text Function !~ doesnt work when used with single character

To Reproduce
Steps to reproduce the behavior:

  1. Start Questdb
  2. Run below query:

Create table x as (select rnd_str() name from long_sequence(2000))
3. Run this SQL

select * from x where name !~ 'H'
Screenshot 2020-07-14 at 10 32 28 PM

  1. See error
    unexpected argument for function: !~. expected args: (STRING,STRING constant). actual args: (STRING,CHAR constant)

Expected behavior
The query should return result where search column does not contain given character

Environment (please complete the following information):

  • OS:macOS
  • Browser:Chrome

Additional context
Add any other context about the problem here.

@mick2004
Copy link
Contributor Author

@bluestreak01 I found this today.Can I push a fix for this ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant