Results of 1 - 10 of about 28 for rules (0.003 sec.)
- Keywords and Identifiers – DuckDB 12601
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keywords() ),...data structure. In these cases, DuckDB automatically deduplicates column names by renaming them according to the following rules: For a column named name , the first instance is not renamed. Subsequent instances are renamed to name _ count , where cou..., 'b' : { 'a' : 88 , 'b' : 99 }}, recursive : = true )); a a_1 b 42 88 99 Database Names Database names are subject to the rules for identifiers . Additionally, it is best practice to avoid DuckDB's two internal database schema names , system and temp... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Data Types – DuckDB 11650
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...RRAY , LIST , MAP , STRUCT , and UNION . Each supports different use cases and has a different structure. Name Description Rules when used in a column Build from values Define in DDL/CREATE ARRAY An ordered, fixed-length sequence of data values of the...ember type. Rows may be set to different member types of the union. union_value(num := 2) UNION(num INTEGER, text VARCHAR) Rules for Case Sensitivity The keys of MAP s are case-sensitive, while keys of UNION s and STRUCT s are case-insensitive. For ex...amples, see the Rules for Case Sensitivity section . Updating Values of Nested Types When performing updates on values of nested types, DuckDB p... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Collations – DuckDB 11175
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...mat Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Collations Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules fo...HÄNNES ICU Collations The collations we have seen so far are not region-dependent, and do not follow any specific regional rules. If you wish to follow the rules of a specific region or language, you will need to use one of the ICU collations. For tha...ations would be used before. They can also be combined with the NOCASE collation. For example, to use the German collation rules you could use the following code snippet: CREATE TABLE strings ( s VARCHAR COLLATE DE ); INSERT INTO strings VALUES ( 'Gab... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Crashes – DuckDB 10700
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e query: PRAGMA disable_optimizer ; If the query finishes successfully, then the crash was caused by one or more optimizer rules. To pinpoint the specific rules that caused the crash, you can try to selectively disable optimizer rules . This way, your...query can still benefit from the rest of the optimizer rules. Try to Isolate the Issue Some issues are caused by the interplay of different components and extensions, or are specific...example . 関連キーワード DuckDB issue crash query database crashes optimizer client step occur process also example caused rules still errors memory session there build using smaller multi Troubleshooting 関連するページ Internal Errors Out of Memory E... - https://man.mtool.work/duckdb/1.3/guides/troubleshooting/crashes.html
- Typecasting – DuckDB 10389
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ER []); Literal Types Integer literals (such as 42 ) and string literals (such as 'string' ) have special implicit casting rules. See the literal types page for more information. Lists / Arrays Lists can be explicitly cast to other lists using the sam...e casting rules. The cast is applied to the children of the list. For example, if we convert an INTEGER[] list to a VARCHAR[] list, the ch...to VARCHAR and a new list is constructed. SELECT CAST ([ 1 , 2 , 3 ] AS VARCHAR []); Arrays Arrays follow the same casting rules as lists. In addition, arrays can be implicitly cast to lists of the same type. For example, an INTEGER[3] array can be im... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Timestamp Types – DuckDB 9913
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ESTAMP WITHOUT TIME ZONE stores the same INT64 , but arithmetic, binning, and string formatting follow the straightforward rules of Coordinated Universal Time (UTC) without offsets or time zones. Accordingly, TIMESTAMP s could be interpreted as UTC ti...2001-02-16 03:38:40 Note that TIMESTAMP s are displayed without time zone specification in the results, following ISO 8601 rules for local times, while time-zone aware TIMESTAMPTZ s are displayed with the UTC offset of the configured time zone, which...simply applying this practice to instants; for example, by binning instants into years, months, and days. Temporal binning rules are complex, and generally come in two sets: time zones and calendars . For most tasks, the calendar will just be the wide... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Map Type – DuckDB 8963
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ther values and are considered equal to each other. At the top level, NULL nested values obey standard SQL NULL comparison rules: comparing a NULL nested value to a non- NULL nested value produces a NULL result. Comparing nested value members , howeve...r, uses the internal nested value rules for NULL s, and a NULL nested value member will compare above a non- NULL nested value member. Functions See Map Functions...nested type types list comparison also using extract ordered need single Keys bracket Maps entries contained used compare rules member Functions Documentation Types 関連するページ Data Types Map Functions Struct Data Type Nested Functions Array Type... - https://man.mtool.work/duckdb/1.3/sql/data_types/map.html
- Casting – DuckDB 8160
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...eries ( 1 , 3 ) tbl ( i ); i 1 2 3 SELECT i :: DOUBLE AS i FROM generate_series ( 1 , 3 ) tbl ( i ); i 1.0 2.0 3.0 Casting Rules Not all casts are possible. For example, it is not possible to convert an INTEGER to a DATE . Casts may also throw errors...26 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Explicit Casting Casting Rules TRY_CAST cast_to_type Function... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Timestamp Issues – DuckDB 7996
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...│ ├──────────────────────────┤ │ 0 rows │ └──────────────────────────┘ These confusing results are due to the SQL casting rules from DATE to TIMESTAMP WITH TIME ZONE . This cast is required to promote the date to midnight in the current time zone . I...the ones in the list is avoids duplicate calls to the slow ICU function. Also notice that we are leveraging the DATE cast rules from the previous section to bound the calendar to the model domain. Half Open Intervals Another subtle problem in using S... - https://man.mtool.work/duckdb/1.3/guides/sql_features/timestamps.html
- Literal Types – DuckDB 7996
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEGER and VARCHAR types. Null Li...ic Literals DuckDB's SQL dialect allows using the underscore character _ in numeric literals as an optional separator. The rules for using underscores are as follows: Underscores are allowed in integer, decimal, hexadecimal and binary notation. Unders... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
DuckDB 1.3 Documentation / man.mtool.work