Differential D11470 Diff 32855 autotests/html/test.sql.html

Changeset View

Standalone View

View Options

autotests/html/test.sql.html

1<!DOCTYPE html> 1​<!DOCTYPE html>
2<html><head> 2​<html><head>
3<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> 3​<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
4<title>test.sql</title> 4​<title>test.sql</title>
5<meta name="generator" content="KF5::SyntaxHighlighting (SQL)"/> 5​<meta name="generator" content="KF5::SyntaxHighlighting (SQL)"/>
6</head><body style="color:#1f1c1b"><pre> 6​</head><body style="color:#1f1c1b"><pre>
7<span style="color:#898887;">-- comment</span> 7​<span style="color:#898887;">-- comment</span>
8 8​
9<span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> stuff <span style="font-weight:bold;">COLUMNS</span>(col1 <span style="color:#0057ae;">INT</span>, col2 <span style="color:#0057ae;">Varchar</span>); 9​<span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> stuff <span style="font-weight:bold;">COLUMNS</span>(col1 <span style="color:#0057ae;">INT</span>, col2 <span style="color:#0057ae;">Varchar</span>);
10<span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> stuff <span style="font-weight:bold;">WHERE</span> <span style="font-weight:bold;">id</span> = <span style="color:#bf0303;">'string'</span>; 10​<span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> stuff <span style="font-weight:bold;">WHERE</span> <span style="font-weight:bold;">id</span> = <span style="color:#bf0303;">'string'</span>;
11<span style="font-weight:bold;">select</span> * <span style="font-weight:bold;">from</span> stuff <span style="font-weight:bold;">where</span> <span style="font-weight:bold;">id</span> &lt; <span style="color:#b08000;">0.42</span>; 11​<span style="font-weight:bold;">select</span> * <span style="font-weight:bold;">from</span> stuff <span style="font-weight:bold;">where</span> <span style="font-weight:bold;">id</span> &lt; <span style="color:#b08000;">0.42</span>;
12<span style="font-weight:bold;">Select</span> col1, col2 <span style="font-weight:bold;">From</span> stuff <span style="font-weight:bold;">Where</span> stuff.col1 <span style="font-weight:bold;">IS</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NuLL</span>; 12​<span style="font-weight:bold;">Select</span> col1, col2 <span style="font-weight:bold;">From</span> stuff <span style="font-weight:bold;">Where</span> stuff.col1 <span style="font-weight:bold;">IS</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NuLL</span>;
13​
14​<span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">TABLE</span> Persons (
15​ <span style="font-weight:bold;">ID</span> <span style="color:#0057ae;">int</span> <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span> AUTO_INCREMENT,
16​ LastName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>) <span style="font-weight:bold;">NOT</span> <span style="font-weight:bold;">NULL</span>,
17​ FirstName <span style="color:#0057ae;">varchar</span>(<span style="color:#b08000;">255</span>),
18​ Age <span style="color:#0057ae;">int</span>,
19​ <span style="font-weight:bold;">PRIMARY</span> <span style="font-weight:bold;">KEY</span> (<span style="font-weight:bold;">ID</span>)
20​ <span style="font-weight:bold;">CONSTRAINT</span> CHK_Person <span style="font-weight:bold;">CHECK</span> (Age&gt;=<span style="color:#b08000;">18</span> <span style="font-weight:bold;">AND</span> City=<span style="color:#bf0303;">'Sandnes'</span>)
21​);
22​
23​<span style="font-weight:bold;">SELECT</span> column_name(s)
24​<span style="font-weight:bold;">FROM</span> table1
25​<span style="font-weight:bold;">FULL</span> <span style="font-weight:bold;">OUTER</span> <span style="font-weight:bold;">JOIN</span> table2 <span style="font-weight:bold;">ON</span> table1.column_name = table2.column_name;
26​
27​<span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> Customers
28​<span style="font-weight:bold;">WHERE</span> City <span style="font-weight:bold;">LIKE</span> <span style="color:#bf0303;">'[bsp]%'</span>;
29​
30​<span style="font-weight:bold;">SELECT</span> <span style="color:#644a9b;">Count</span>(*) <span style="font-weight:bold;">AS</span> DistinctCountries
31​<span style="font-weight:bold;">FROM</span> (<span style="font-weight:bold;">SELECT</span> <span style="font-weight:bold;">DISTINCT</span> Country <span style="font-weight:bold;">FROM</span> Customers)
32​<span style="font-weight:bold;">GROUP</span> <span style="font-weight:bold;">BY</span> Country
33​<span style="font-weight:bold;">HAVING</span> <span style="color:#644a9b;">COUNT</span>(CustomerID) &gt; <span style="color:#b08000;">5</span>
34​<span style="font-weight:bold;">ORDER</span> <span style="font-weight:bold;">BY</span> <span style="color:#644a9b;">COUNT</span>(CustomerID) <span style="font-weight:bold;">DESC</span>;
35​
36​<span style="font-weight:bold;">SELECT</span> <span style="color:#bf0303;">'Customer'</span> <span style="font-weight:bold;">As</span> <span style="font-weight:bold;">Type</span>, ContactName, City, Country
37​<span style="font-weight:bold;">FROM</span> Customers
38​<span style="font-weight:bold;">UNION</span>
39​<span style="font-weight:bold;">SELECT</span> <span style="color:#bf0303;">'Supplier'</span>, ContactName, City, Country
40​<span style="font-weight:bold;">FROM</span> Suppliers;
41​
42​<span style="font-weight:bold;">SELECT</span> <span style="color:#644a9b;">COUNT</span>(ProductID), <span style="color:#644a9b;">AVG</span>(Price)
43​<span style="font-weight:bold;">FROM</span> Products;
44​
45​<span style="font-weight:bold;">SET</span> lock_timeout = <span style="color:#b08000;">0</span>;
46​<span style="font-weight:bold;">SET</span> client_encoding = <span style="color:#bf0303;">'UTF8'</span>;
47​<span style="font-weight:bold;">SET</span> standard_conforming_strings = <span style="font-weight:bold;">on</span>;
48​<span style="font-weight:bold;">SET</span> check_function_bodies = <span style="font-weight:bold;">false</span>;
49​<span style="font-weight:bold;">SET</span> client_min_messages = warning;
50​<span style="font-weight:bold;">SET</span> default_tablespace = <span style="color:#bf0303;">''</span>;
51​
52​<span style="font-weight:bold;">DROP</span> <span style="font-weight:bold;">TABLE</span> <span style="font-weight:bold;">IF</span> <span style="font-weight:bold;">EXISTS</span> employees;
53​
54​<span style="font-weight:bold;">ALTER</span> <span style="font-weight:bold;">TABLE</span> <span style="font-weight:bold;">ONLY</span> employees
55​ <span style="font-weight:bold;">ADD</span> <span style="font-weight:bold;">CONSTRAINT</span> fk_employees_employees <span style="font-weight:bold;">FOREIGN</span> <span style="font-weight:bold;">KEY</span> (reportsto) <span style="font-weight:bold;">REFERENCES</span> employees;
56​
57​<span style="font-weight:bold;">CREATE</span> <span style="font-weight:bold;">VIEW</span> [<span style="font-weight:bold;">Current</span> Product <span style="font-weight:bold;">List</span>] <span style="font-weight:bold;">AS</span>
58​<span style="font-weight:bold;">SELECT</span> ProductID, ProductName
59​<span style="font-weight:bold;">FROM</span> Products
60​<span style="font-weight:bold;">WHERE</span> Discontinued = <span style="font-weight:bold;">No</span>;
61​
62​<span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> [<span style="font-weight:bold;">Current</span> Product <span style="font-weight:bold;">List</span>];
63​
64​<span style="font-weight:bold;">SELECT</span> * <span style="font-weight:bold;">FROM</span> [<span style="font-weight:bold;">Category</span> Sales <span style="font-weight:bold;">For</span> <span style="color:#b08000;">1997</span>]
65​<span style="font-weight:bold;">WHERE</span> CategoryName = <span style="color:#bf0303;">'Beverages'</span>;
66​
67​<span style="font-weight:bold;">begin</span>
68​<span style="font-weight:bold;">end</span>
69​<span style="color:#924c9d;">/</span>
70​ /
71​/ u
13</pre></body></html> 72​</pre></body></html>