Highlighting is one of the few areas that jekyll markdown is different from
GitHub markdown. This is how to highlight SQL in jekyll markdown:
{% highlight sql %}
select ‘example’
from myTable
{% end highlight %}
> On Nov 14, 2017, at 4:38 PM, [email protected] wrote:
>
> Repository: calcite
> Updated Branches:
> refs/heads/master 20ade9d26 -> 3e587afb0
>
>
> [CALCITE-2052] Remove SQL code style from MV documentation
>
>
> Project: http://git-wip-us.apache.org/repos/asf/calcite/repo
> Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/3e587afb
> Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/3e587afb
> Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/3e587afb
>
> Branch: refs/heads/master
> Commit: 3e587afb0d689e42b432c5024d37916ef8b2ccd4
> Parents: 20ade9d
> Author: Jesus Camacho Rodriguez <[email protected]>
> Authored: Tue Nov 14 16:38:34 2017 -0800
> Committer: Jesus Camacho Rodriguez <[email protected]>
> Committed: Tue Nov 14 16:38:34 2017 -0800
>
> ----------------------------------------------------------------------
> site/_docs/materialized_views.md | 44 +++++++++++++++++------------------
> 1 file changed, 22 insertions(+), 22 deletions(-)
> ----------------------------------------------------------------------
>
>
> http://git-wip-us.apache.org/repos/asf/calcite/blob/3e587afb/site/_docs/materialized_views.md
> ----------------------------------------------------------------------
> diff --git a/site/_docs/materialized_views.md
> b/site/_docs/materialized_views.md
> index 8cb57cd..a407b12 100644
> --- a/site/_docs/materialized_views.md
> +++ b/site/_docs/materialized_views.md
> @@ -77,7 +77,7 @@ To produce a larger number of rewritings, the rule relies
> on information exposed
>
> Let us illustrate with some examples the coverage of the view rewriting
> algorithm implemented in `AbstractMaterializedViewRule`. The examples are
> based on the following database schema.
>
> -```SQL
> +```
> CREATE TABLE depts(
> deptno INT NOT NULL,
> deptname VARCHAR(20),
> @@ -106,7 +106,7 @@ The rewriting can handle different join orders in the
> query and the view definit
>
> * Query:
>
> -```SQL
> +```
> SELECT empid
> FROM depts
> JOIN (
> @@ -118,7 +118,7 @@ ON (depts.deptno = subq.deptno)
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid
> FROM emps
> JOIN depts USING (deptno)
> @@ -126,7 +126,7 @@ JOIN depts USING (deptno)
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT empid
> FROM mv
> WHERE empid = 1
> @@ -137,7 +137,7 @@ WHERE empid = 1
>
> * Query:
>
> -```SQL
> +```
> SELECT deptno
> FROM emps
> WHERE deptno > 10
> @@ -146,7 +146,7 @@ GROUP BY deptno
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, deptno
> FROM emps
> WHERE deptno > 5
> @@ -155,7 +155,7 @@ GROUP BY empid, deptno
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT deptno
> FROM mv
> WHERE deptno > 10
> @@ -167,7 +167,7 @@ GROUP BY deptno
>
> * Query:
>
> -```SQL
> +```
> SELECT deptno, COUNT(*) AS c, SUM(salary) AS s
> FROM emps
> GROUP BY deptno
> @@ -175,7 +175,7 @@ GROUP BY deptno
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, deptno, COUNT(*) AS c, SUM(salary) AS s
> FROM emps
> GROUP BY empid, deptno
> @@ -183,7 +183,7 @@ GROUP BY empid, deptno
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT deptno, SUM(c), SUM(s)
> FROM mv
> GROUP BY deptno
> @@ -196,7 +196,7 @@ Through the declared constraints, the rule can detect
> joins that only append col
>
> * Query:
>
> -```SQL
> +```
> SELECT deptno, COUNT(*)
> FROM emps
> GROUP BY deptno
> @@ -204,7 +204,7 @@ GROUP BY deptno
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, depts.deptno, COUNT(*) AS c, SUM(salary) AS s
> FROM emps
> JOIN depts USING (deptno)
> @@ -213,7 +213,7 @@ GROUP BY empid, depts.deptno
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT deptno, SUM(c)
> FROM mv
> GROUP BY deptno
> @@ -224,7 +224,7 @@ GROUP BY deptno
>
> * Query:
>
> -```SQL
> +```
> SELECT deptname, state, SUM(salary) AS s
> FROM emps
> JOIN depts ON (emps.deptno = depts.deptno)
> @@ -234,7 +234,7 @@ GROUP BY deptname, state
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, deptno, state, SUM(salary) AS s
> FROM emps
> JOIN locations ON (emps.locationid = locations.locationid)
> @@ -243,7 +243,7 @@ GROUP BY empid, deptno, state
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT deptname, state, SUM(s)
> FROM mv
> JOIN depts ON (mv.deptno = depts.deptno)
> @@ -255,7 +255,7 @@ GROUP BY deptname, state
>
> * Query:
>
> -```SQL
> +```
> SELECT empid, deptname
> FROM emps
> JOIN depts ON (emps.deptno = depts.deptno)
> @@ -264,7 +264,7 @@ WHERE salary > 10000
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, deptname
> FROM emps
> JOIN depts ON (emps.deptno = depts.deptno)
> @@ -273,7 +273,7 @@ WHERE salary > 12000
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT empid, deptname
> FROM mv
> UNION ALL
> @@ -288,7 +288,7 @@ WHERE salary > 10000 AND salary <= 12000
>
> * Query:
>
> -```SQL
> +```
> SELECT empid, deptname, SUM(salary) AS s
> FROM emps
> JOIN depts ON (emps.deptno = depts.deptno)
> @@ -298,7 +298,7 @@ GROUP BY empid, deptname
>
> * Materialized view definition:
>
> -```SQL
> +```
> SELECT empid, deptname, SUM(salary) AS s
> FROM emps
> JOIN depts ON (emps.deptno = depts.deptno)
> @@ -308,7 +308,7 @@ GROUP BY empid, deptname
>
> * Rewriting:
>
> -```SQL
> +```
> SELECT empid, deptname, SUM(s)
> FROM (
> SELECT empid, deptname, s
>
