# DOUBLE: Data Dictionary Single Row Table for test cases and value retrieval of singleton SQL functions. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `dal` - Primary Keys: `DUMMY_INT32` - Label: Single Row This is a read-only table. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## Table Columns The columns of the table `DOUBLE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `dummy_blob_null` | `blob` | | ☐ | | | `dummy_blob` | `blob` | Dummy BLOB | ☑ | | | `dummy_bool_null` | `boolean` | | ☐ | | | `dummy_bool` | `boolean` | Dummy Boolean | ☑ | | | `dummy_char_null` | `char` | | ☐ | | | `dummy_char` | `char` | | ☑ | | | `dummy_date_null` | `date` | | ☐ | | | `dummy_date` | `date` | Dummy Date | ☑ | A date in UTC. | | `dummy_datetime_null` | `datetime` | | ☐ | | | `dummy_datetime` | `datetime` | Dummy Date/Time | ☑ | A timestamp in UTC. | | `dummy_decimal_null` | `decimal` | | ☐ | | | `dummy_decimal` | `decimal` | Dummy Decimal | ☑ | | | `dummy_double_above` | `double` | | ☑ | | | `dummy_double_below` | `double` | | ☑ | | | `dummy_double_null` | `double` | | ☐ | | | `dummy_double` | `double` | Dummy Double | ☑ | | | `dummy_float_null` | `float` | | ☐ | | | `dummy_float` | `float` | Dummy Float | ☑ | | | `dummy_guid_null` | `varchar2` | | ☐ | | | `dummy_guid` | `varchar2` | Dummy GUID | ☑ | | | `dummy_int16_null` | `number` | | ☐ | | | `dummy_int16` | `int16` | Dummy Integer (16-bits) | ☑ | | | `dummy_int32_null` | `number` | | ☐ | | | `dummy_int32` | `int32` | Dummy Integer (32-bits) | ☑ | | | `dummy_int64_null` | `number` | | ☐ | | | `dummy_int64` | `int64` | Dummy Integer (64-bits) | ☑ | | | `dummy_ipv6_mapped_ipv4` | `varchar2(45)` | | ☑ | An IPv4 address in IPv4-mapped IPv6 notation, the form the engine stores it in. | | `dummy_ipv6_null` | `varchar2(45)` | | ☐ | Always null, to exercise the absence of an IP address. | | `dummy_ipv6` | `varchar2(45)` | | ☑ | An IPv6 address, from the documentation range 2001:db8::/32. | | `dummy_string_int64` | `varchar2(20)` | | ☐ | | | `dummy_string_null` | `varchar2(1)` | | ☐ | | | `dummy_string` | `varchar2(1)` | Dummy String | ☑ | | | `dummy_uint16` | `uint16` | Dummy uint16 | ☑ | | | `dummy_uint32` | `uint32` | Dummy uint32 | ☑ | | | `dummy_uint64` | `uint64` | Dummy uint64 | ☑ | |