View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000002 | Interbase/Firebird | General | public | 2010-03-23 12:27 | 2010-03-24 10:48 |
| Reporter | barry | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 3.2.0.1573 | ||||
| Summary | 0000002: Hexadecimal Numeric and Binary String Literals | ||||
| Description | п>ї============================================== Hexadecimal Numeric and Binary String Literals ============================================== Support for hexadecimal numeric and binary string literals. Authors: Bill Oliver <Bill.Oliver@sas.com> Adriano dos Santos Fernandes <adrianosf@uol.com.br> Syntax: <numeric hex literal> ::= { 0x | 0X } <hexit> [ <hexit>... ] <binary string literal> ::= { x | X } <quote> [ { <hexit> <hexit> }... ] <quote> <digit> ::= 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 <hexit> ::= <digit> | A | B | C | D | E | F | a | b | c | d | e | f Notes (numeric hex literal): - The max number of <hexit> should be 16. - If the number of <hexit> is greater than 8, the constant data type is a signed BIGINT. If it's less or equal than 8, the data type is a signed INTEGER. That means 0xF0000000 is -268435456 and 0x0F0000000 is 4026531840. Notes (binary string literal): - The resulting string is defined as a CHAR(N / 2) CHARACTER SET OCTETS, where N is the number of <hexit>. Example: select 0x10, cast('0x0F0000000' as bigint) from rdb$database; select x'deadbeef' from rdb$database; | ||||
| Tags | No tags attached. | ||||
| has duplicate | 0000521 | closed | barry | Склад | +Склад- Закладка Расход- Функция - Копировать счет в другое предприятие |
| has duplicate | 0000606 | closed | barry | Производство | +Производство-Справочник Нормы- Интерфейс поиска и замены Комплектующих в справочнике Изделия |
| has duplicate | 0000614 | closed | ruslan | Зарплата | -Выгрузка данных по ЗП в 1-ДФ XML- некорректность данных при использовании двух удержаний НДФЛ в одной ведомости по сотруднику |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-03-23 12:27 | barry | New Issue | |
| 2010-03-23 12:27 | barry | Status | new => assigned |
| 2010-03-23 12:27 | barry | Assigned To | => barry |
| 2010-03-24 10:46 | barry | Status | assigned => resolved |
| 2010-03-24 10:46 | barry | Resolution | open => fixed |
| 2010-03-24 10:48 | barry | Status | resolved => closed |
| 2010-03-24 10:48 | barry | Fixed in Version | => 3.2.0.1573 |
| 2013-04-26 13:15 | ruslan | Relationship added | has duplicate 0000521 |
| 2014-01-28 11:30 | ruslan | Relationship added | has duplicate 0000606 |
| 2014-01-28 11:41 | ruslan | Relationship added | has duplicate 0000614 |
