GBase 8s
其他
问答
SQL 语法兼容问题
发表于2024-12-18 16:28:54202次浏览3个评论
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】:GBase8sV8.8_TL_3.5.1_3X2_x86_64
【JDBC驱动】:gbasedbtjdbc_3.5.1_3X2_1.jar
【操作系统】:Centos8 (Docker构建的)
【CPU】:
[gbasedbt@ae8e80484b2a opt]$ lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 48
On-line CPU(s) list: 0-47
Thread(s) per core: 2
Core(s) per socket: 12
Socket(s): 2
NUMA node(s): 2
Vendor ID: GenuineIntel
CPU family: 6
Model: 106
Model name: Intel(R) Xeon(R) Silver 4310 CPU @ 2.10GHz
Stepping: 6
CPU MHz: 799.932
CPU max MHz: 3300.0000
CPU min MHz: 800.0000
BogoMIPS: 4200.00
Virtualization: VT-x
L1d cache: 48K
L1i cache: 32K
L2 cache: 1280K
L3 cache: 18432K
NUMA node0 CPU(s): 0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46
NUMA node1 CPU(s): 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47
Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 sdbg fma cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch epb cat_l3 invpcid_single ssbd mba rsb_ctxsw ibrs ibpb stibp ibrs_enhanced tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm cqm rdt_a avx512f avx512dq rdseed adx smap avx512ifma clflushopt clwb intel_pt avx512cd sha_ni avx512bw avx512vl xsaveopt xsavec xgetbv1 cqm_llc cqm_occup_llc cqm_mbm_total cqm_mbm_local dtherm ida arat pln pts hwp hwp_act_window hwp_epp hwp_pkg_req avx512vbmi umip pku ospke avx512_vbmi2 gfni vaes vpclmulqdq avx512_vnni avx512_bitalg avx512_vpopcntdq md_clear pconfig spec_ctrl intel_stibp flush_l1d arch_capabilities【问题描述】*:
执行 SQL 时报出错误 不能解析例行程序(equal)
SQL: SELECT id,line_id,point_id,distance,status,retained,create_by,update_by,create_at,update_at,remark,org,sub_org FROM qtmp_biz_resource_std_line_point WHERE (line_id IN (?,?,?,?) AND status = ?) and (org = 'gk') and (sub_org = 'gk-gz') ORDER BY distance ASC
### Cause: java.sql.SQLException: 不能解析例行程序 (equal)。
; uncategorized SQLException; SQL state [IX000]; error code [-674]; 不能解析例行程序 (equal)。; nested exception is java.sql.SQLException: 不能解析例行程序 (equal)。
16:21:16.590 [http-nio-8899-exec-4] ERROR c.q.p.w.advice.GlobalExceptionAdvice - 未知异常!原因是:
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: java.sql.SQLException: 不能解析例行程序 (equal)。
### The error may exist in com/qualsen/thingsmind/biz/resource/mapper/QtmpBizResourceStdLinePointMapper.java (best guess)
### The error may involve defaultParameterMap
a### The error occurred while setting parametersSQL语句是:
SELECT id,line_id,point_id,distance,status,retained,create_by,update_by,create_at,update_at,remark,org,sub_org FROM qtmp_biz_resource_std_line_point
WHERE (line_id IN (?,?,?,?) AND status = ?) and (org = 'gk') and (sub_org = 'gk-gz')
ORDER BY distance ASC评论
登录后才可以发表评论
热门帖子
- 12025-12-01浏览数:182764
- 22023-05-09浏览数:25062
- 42023-09-25浏览数:18526
- 52020-05-11浏览数:17529