QSQL - BETWEEN text - KX Learning Hub

KX Academy

QSQL – BETWEEN text

Posted by macius222 on October 10, 2024 at 8:12 pm
I have an issue with SQL for kdb+ .

After execution:
```
.s.e"SELECT * FROM trips
WHERE payment_type BETWEEN 'CASH' AND 'DISPUTE';
```
I get an error:

length. can’t execute ?[+`date`month`vendor`pickup_time`dropoff_time`duration`passengers`distance`start_long`start_lat`end_long`end_lat`payment_type`fare`surcharge`tip`tolls`total!(`s#2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009.01.01 2009

Have you experienced an error like that ?
megan_mcp replied 2 months, 1 week ago 2 Members · 1 Reply
1 Reply

megan_mcp

Administrator
October 11, 2024 at 4:38 pm

Hi @macius222

Thank you for reporting this! I will investigate further into why this error is occurring in the demo.

Many thanks,

Megan

Log In to Reply

Log in to reply.