aboutsummaryrefslogtreecommitdiff
path: root/sql/hive/src/test/resources/sqlgen/not_like.sql
blob: 2f66695189cba953548afa21c5edb6d0d712a0f4 (plain) (blame)
1
2
3
4
-- This file is automatically generated by LogicalPlanToSQLSuite.
SELECT id FROM t0 WHERE id + 5 NOT LIKE '1%'
--------------------------------------------------------------------------------
SELECT `gen_attr` AS `id` FROM (SELECT `gen_attr` FROM (SELECT `id` AS `gen_attr` FROM `default`.`t0`) AS gen_subquery_0 WHERE (NOT CAST((`gen_attr` + CAST(5 AS BIGINT)) AS STRING) LIKE "1%")) AS t0