Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

string_to_datetime and '\0' symbol [CORE6496] #6726

Closed
firebird-automations opened this issue Feb 24, 2021 · 4 comments
Closed

string_to_datetime and '\0' symbol [CORE6496] #6726

firebird-automations opened this issue Feb 24, 2021 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @ibprovider

string_to_datetime returns error when translates string like:

"2021-2-20\0"
"2021-2-20 1:2\0"
"2021-2-20 1:2:3\0"

but not have problems with translation of strings like:

"5.3.2021 01:02:03.1234\0"

-----
Note that, Firebird can't translate to BOOLEAN the string with '\0' symbol (for example "TRUE\0").

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

In v4 with expects time zone, it says errors like:

For cast('01-01-1900 10:00' || ascii_char(0) as timestamp)
Invalid time zone region:

For cast('01-01-1900 10:00 America/Sao_Paulo' || ascii_char(0) as timestamp)
Invalid time zone region: America/Sao_Paulo

I'm considering it fixed then.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 RC 1 [ 10930 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants