search

heavyai / heavydb

HeavyDB (formerly OmniSciDB)
https://heavy.ai
Apache License 2.0
2.96k stars 448 forks source link

Function SUBSTRING(VARCHAR, INTEGER, INTEGER) not supported. #580

Open alexey-milovidov opened 4 years ago

geeteshkarekar commented 2 years ago

Can you share your query? I shall fix and provide you with the updated working copy

alexey-milovidov commented 2 years ago

One of the queries from ClickBench: https://github.com/ClickHouse/ClickBench/ See the heavyai directory.

cdessanti commented 2 years ago

The substring function is implemented starting with the 6.0 release; you can use the substring or substr indifferently.

I don't remember the use of substr in the latest version of Clickbench, but probably I'm wrong.

Let me know if it's working for you so we can close the issue

From: Alexey Milovidov @.> Sent: Saturday, August 13, 2022 3:50:06 AM To: heavyai/heavydb @.> Cc: Subscribed @.***> Subject: Re: [heavyai/heavydb] Function SUBSTRING(VARCHAR, INTEGER, INTEGER) not supported. (#580)

One of the queries from ClickBench: https://github.com/ClickHouse/ClickBench/https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FClickHouse%2FClickBench%2F&data=05%7C01%7C%7Ccfe98849cc35499fdf0608da7cce265c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637959522093725927%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BUhZXThfQteFINHOn7EGhD%2FN2erm2Qgcod82o7gm%2F0I%3D&reserved=0 See the heavyai directory.

— Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fheavyai%2Fheavydb%2Fissues%2F580%23issuecomment-1213630007&data=05%7C01%7C%7Ccfe98849cc35499fdf0608da7cce265c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637959522093725927%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PSm8Dw0SR6fD3kE%2BGAhSuXznNRje7Egu%2B3t0XknkmfQ%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAHLFBF3KNY4A4MMGOFJAKETVY35M5ANCNFSM4PK43LIQ&data=05%7C01%7C%7Ccfe98849cc35499fdf0608da7cce265c%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637959522093725927%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0rIYqaGV0vrEg%2BIPUHdZdVLhlUkT56QadS%2BtJyrWnH8%3D&reserved=0. You are receiving this because you are subscribed to this thread.Message ID: @.***>