On 2/26/2018 12:23 AM, Gary Briggs wrote:
Evening
I'm seeing a weird effect when concatenting things:
WITH q(tape,dp) AS (SELECT '04E', 1)
SELECT SUBSTR(tape,1,dp-1) || SUBSTR(tape,dp,1)+1 || SUBSTR(tape,dp+1) AS
expect_14E,
|| has higher precedence than +. Your expression is an arithmetic sum of two
values:
SUBSTR(tape,1,dp-1) || SUBSTR(tape,dp,1) -- 0
+
1 || SUBSTR(tape,dp+1) -- '14E', converted to integer 14
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
