[SQL] EXTRACT and DATE_PART function for 'SECOND' parameter returns decimal(8,6), otherwise SECOND function returns integer
Open
- Dominant language
- Scala
- Stars
- 44k
- Forks
- 29.4k
- PR merge metrics
- No merged PRs in 30d
Description
Is this behavior specified by the SQL standard, or is it a bug?
Contributor guide
Research direction
Start by comparing the SQL EXTRACT and DATE_PART implementations for the SECOND parameter with the SECOND function behavior, then check the SQL standard referenced by the issue. Determine whether the decimal(8,6) result is specified or inconsistent, and document enough evidence for the issue to become an actionable bug or clarification.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- scala, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100