search

brimdata / super

An analytics database that puts JSON and relational tables on equal footing
https://zed.brimdata.io/
BSD 3-Clause "New" or "Revised" License
1.4k stars 67 forks source link

add SQL LENGTH() function as alias for len() #5486

Closed mccanne closed 1 week ago

philrz commented 1 week ago

Verified in super commit 5c1851b.

Before:

$ super -version
Version: v1.18.0-156-gb2c46ef7

$ super -c "SELECT LENGTH('W3Schools.com');"
no such function at line 1, column 8:
SELECT LENGTH('W3Schools.com');
       ~~~~~~~~~~~~~~~~~~~~~~~

Now:

$ super -version
Version: v1.18.0-157-g5c1851be

$ super -c "SELECT LENGTH('W3Schools.com');"
{length:13}

Thanks @mccanne!