[Bug]: Spatial Reference System has no WGS 84（SRID=4326）support
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 2.9k
- Forks
- 339
- Avg merge
- 1d 19h
- Merged PRs (30d)
- 52
Description
Describe the bug
Spatial Reference System has no WGS 84（SRID=4326）support
Environment
-
OS Version and CPU Arch(
uname -a): Rocky 9.7 x86 -
OB Version(
LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V): seekdb 1.2 -
Hardware resource(
cpu core/memory size/disk hardware): 4 core 16Gmemory
Fast Reproduce Steps(Required)
Steps to reproduce the behavior:
Execute: SELECT * FROM information_schema.ST_SPATIAL_REFERENCE_SYSTEMS;
Expected behavior
The query result includes SRS_ID=4326
Actual Behavior
Only one record: SRS_ID=0
Additional context
no
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by running SELECT * FROM information_schema.ST_SPATIAL_REFERENCE_SYSTEMS in seekdb 1.2 and inspect the implementation of that information_schema table and its spatial reference data. Trace how SRS_ID=0 is populated and identify the existing database tests for this query. Done means the result includes SRS_ID=4326 for WGS 84 and the relevant tests pass.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100