This is an automated email from the ASF dual-hosted git repository.
git-site-role pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new a6e16ff3e Automatic Site Publish by Buildbot
a6e16ff3e is described below
commit a6e16ff3eb1a5dfc8ffffdd088c6776a3b9ff7f7
Author: buildbot <[email protected]>
AuthorDate: Fri Oct 21 11:14:59 2022 +0000
Automatic Site Publish by Buildbot
---
output/docs/string-manipulation/index.html | 35 ++++++++++++++++++++++++++-
output/feed.xml | 4 +--
output/zh/docs/string-manipulation/index.html | 35 ++++++++++++++++++++++++++-
output/zh/feed.xml | 4 +--
4 files changed, 72 insertions(+), 6 deletions(-)
diff --git a/output/docs/string-manipulation/index.html
b/output/docs/string-manipulation/index.html
index 06dd38711..bf6c01040 100644
--- a/output/docs/string-manipulation/index.html
+++ b/output/docs/string-manipulation/index.html
@@ -1907,7 +1907,15 @@ SELECT LTRIM('A powerful tool Apache Drill', 'Apache ')
FROM (VALUES(1));
<p><em>string_expression</em> is the string to be matched.</p>
-<p><em>pattern</em> is the regular expression.</p>
+<p><em>pattern</em> is the <a
href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html";>Java
regular expression pattern</a>.</p>
+
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">
+The regular expression . matches any character except a line terminator unless
the [DOTALL
flag](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#DOTALL)
is specified.
+By default, the regular expressions ^ and $ ignore line terminators and only
match at the beginning and the end, respectively, of the entire input sequence.
If [MULTILINE
mode](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#MULTILINE)
is activated then ^ matches at the beginning of input and after any line
terminator except at the end of input. When in [MULTILINE
mode](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/
[...]
+ </p>
+</div>
<h3 id="regexp_matches-examples">REGEXP_MATCHES Examples</h3>
@@ -1939,6 +1947,31 @@ select regexp_matches('abc', 'a*.c');
|--------|
</code></pre></div></div>
+<p>Shows how to turn on different pattern flags to enable case-insensitive
matching, to permit whitespace and comments in pattern, etc. Complete list of
flags you can find in <a
href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#field.summary";>Java
Doc</a>):</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>select regexp_matches('String with newline character
+ ', '(?s).*');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+
+ select regexp_matches('ABC', '(?i)abc');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+
+select regexp_matches('abc', '(?x)a b c');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+</code></pre></div></div>
+
<h2 id="regexp_replace">REGEXP_REPLACE</h2>
<p>Substitutes new text for substrings that match <a
href="http://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html";>Java
regular expression patterns</a>.</p>
diff --git a/output/feed.xml b/output/feed.xml
index 96c09165f..64cd2e4ea 100644
--- a/output/feed.xml
+++ b/output/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 20 Oct 2022 14:07:15 +0000</pubDate>
- <lastBuildDate>Thu, 20 Oct 2022 14:07:15 +0000</lastBuildDate>
+ <pubDate>Fri, 21 Oct 2022 11:12:49 +0000</pubDate>
+ <lastBuildDate>Fri, 21 Oct 2022 11:12:49 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/string-manipulation/index.html
b/output/zh/docs/string-manipulation/index.html
index 666c5c464..f0d90d585 100644
--- a/output/zh/docs/string-manipulation/index.html
+++ b/output/zh/docs/string-manipulation/index.html
@@ -1907,7 +1907,15 @@ SELECT LTRIM('A powerful tool Apache Drill', 'Apache ')
FROM (VALUES(1));
<p><em>string_expression</em> is the string to be matched.</p>
-<p><em>pattern</em> is the regular expression.</p>
+<p><em>pattern</em> is the <a
href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html";>Java
regular expression pattern</a>.</p>
+
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">
+The regular expression . matches any character except a line terminator unless
the [DOTALL
flag](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#DOTALL)
is specified.
+By default, the regular expressions ^ and $ ignore line terminators and only
match at the beginning and the end, respectively, of the entire input sequence.
If [MULTILINE
mode](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#MULTILINE)
is activated then ^ matches at the beginning of input and after any line
terminator except at the end of input. When in [MULTILINE
mode](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/
[...]
+ </p>
+</div>
<h3 id="regexp_matches-examples">REGEXP_MATCHES Examples</h3>
@@ -1939,6 +1947,31 @@ select regexp_matches('abc', 'a*.c');
|--------|
</code></pre></div></div>
+<p>Shows how to turn on different pattern flags to enable case-insensitive
matching, to permit whitespace and comments in pattern, etc. Complete list of
flags you can find in <a
href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/regex/Pattern.html#field.summary";>Java
Doc</a>):</p>
+
+<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>select regexp_matches('String with newline character
+ ', '(?s).*');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+
+ select regexp_matches('ABC', '(?i)abc');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+
+select regexp_matches('abc', '(?x)a b c');
+ +--------+
+ | EXPR$0 |
+ +--------+
+ | true |
+ +--------+
+</code></pre></div></div>
+
<h2 id="regexp_replace">REGEXP_REPLACE</h2>
<p>Substitutes new text for substrings that match <a
href="http://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html";>Java
regular expression patterns</a>.</p>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index 6f962b640..308f89f38 100644
--- a/output/zh/feed.xml
+++ b/output/zh/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/zh/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 20 Oct 2022 14:07:15 +0000</pubDate>
- <lastBuildDate>Thu, 20 Oct 2022 14:07:15 +0000</lastBuildDate>
+ <pubDate>Fri, 21 Oct 2022 11:12:49 +0000</pubDate>
+ <lastBuildDate>Fri, 21 Oct 2022 11:12:49 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
