本地JSON文件，select字段错位问题
Open
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 4.7k
- Forks
- 364
- PR merge metrics
- No merged PRs in 30d
Description
你好，今天简单运行了个demo测试，我是从本地JSON文件读取的JSON数组，select 某个指定的列发现数据错位了
1-数据JSON：
[
{
"TYPE":"Y",
"INDEX_NAME":"测试1"
},
{
"TYPE":"N",
"INDEX_NAME":"测试2"
}
]
2-执行SQL：
ResultSet rst = st.executeQuery("$() select INDEX_NAME from /Users/kilogram/Desktop/spl.json");
3-结果截图
INDEX_NAME
Y
N
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
Reproduce the issue with the local spl.json data and the shown Java SQL call, $() select INDEX_NAME from /Users/kilogram/Desktop/spl.json. Trace how the JSON fields are mapped when select reads the file; done means selecting INDEX_NAME returns 测试1 and 测试2 rather than the TYPE values.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100