File: passing_timing.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (18 lines) | stat: -rw-r--r-- 501 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
-- NOTE: This query is duplicated many times so the test
-- takes longer and can effectively measure timing routines.

{% for i in range(10) %}
    SELECT
        tbl.name,
        b.value,
        /*
        This is a block comment
        */
        d.something,    -- Which a comment after it
        tbl.foo,
        d.val + b.val / -2 AS a_calculation
    FROM tbl
    INNER JOIN b ON (tbl.common_id = b.common_id)
    LEFT JOIN d ON (tbl.id = d.other_id)
    ORDER BY tbl.name ASC;
{% endfor %}