LEFT and RIGHT Functions Not Working

[Padraig O'Sullivan]

server revision: 1778

posullivan=> select left('foo', 3);
ERROR: Encountered " "left" "left "" at line 1, column 8.
Was expecting:
    "*" ...

LINE 1: select left('foo', 3);
               ^
posullivan=>

posullivan=> select right('foo', 3);
ERROR: Encountered " "right" "right "" at line 1, column 8.
Was expecting:
    "*" ...

LINE 1: select right('foo', 3);
               ^
posullivan=>

[Vy Nguyen (oontvoo)]

- RIGHT ins't implemented yet.

[Mike McMahon (mmcm)]

It's called get_left in the ITs.

[Timothy Wegner (timmwegner)]

Yes, the sql support
matrix<https://docs.google.com/a/akiban.com/spreadsheet/ccc?key=0AiGr_XWdHm0edFpXSTd6bUZZTDM3QXlTaFpha0hkNUE&hl=en_US#gid=9>
shows
we don't support RIGHT yet as Vy states. But Im unsure why we didn't
create an alias for LEFT ?

On Thu, Jun 7, 2012 at 5:13 PM, Mike McMahon <email address hidden>wrote:

> It's called get_left in the ITs.
>
> --
> You received this bug notification because you are a member of Akiban
> Technologies, which is subscribed to the bug report.
> https://bugs.launchpad.net/bugs/1009749
>
> Title:
> LEFT and RIGHT Functions Not Working
>
> Status in Akiban Server Project:
> New
>
> Bug description:
> server revision: 1778
>
> posullivan=> select left('foo', 3);
> ERROR: Encountered " "left" "left "" at line 1, column 8.
> Was expecting:
> "*" ...
>
> LINE 1: select left('foo', 3);
> ^
> posullivan=>
>
> posullivan=> select right('foo', 3);
> ERROR: Encountered " "right" "right "" at line 1, column 8.
> Was expecting:
> "*" ...
>
> LINE 1: select right('foo', 3);
> ^
> posullivan=>
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/akiban-server/+bug/1009749/+subscriptions
>

--
Akiban Technologies | Tim Wegner | VP of Engineering
skype: timmwegner | <email address hidden> | 508.735.6290

[Vy Nguyen (oontvoo)]

get_left isn't an alias. It's just what I called the function so it wouldn't conflict with the key word LEFT.

I had some TODOs in the yaml test file about that. But it's been awhile, and I totally forgot about it!