oceanbase

oceanbase copied to clipboard

[Bug]: Inconsistent Query Results Between Materialized Table and View with Compressed Data

1

**Describe the bug** In OceanBase, querying a materialized table and a view with identical data and COMPRESS produces inconsistent results. **Environment** - OS Version and CPU Arch(`uname -a`): ``` [root@332f4c044dbb...

dwenking

[Bug]: Inconsistent Query Results Between Views and Materialized Tables with Logical Comparison

1

**Describe the bug** In OceanBase, Queries involving logical comparisons and JSON data return inconsistent results when executed on a view versus a materialized table. Specifically, the query on the materialized...

dwenking

[Bug]: Complex query behavior is inconsistent with MySQL.

3

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ```bash Linux 6.8.0-49-generic 22.04.1-Ubuntu SMP PREEMPT_DYNAMIC x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`): ```bash select version();...

fenfeng9

[Bug]: Query execution failed when involving `FIELD` and `CAST` and `COALESCE` functions.

2

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ``` Linux 3.10.0-1160.102.1.el7.x86_64 #1 SMP Tue Oct 17 15:42:21 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH...

ringora

[Bug]: Query execution failed when involving INET6_NTOA and FROM_BASE64 functions.

2

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ``` Linux 3.10.0-1160.102.1.el7.x86_64 #1 SMP Tue Oct 17 15:42:21 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH...

ringora

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ``` Linux 6.8.0-49-generic 22.04.1-Ubuntu SMP PREEMPT_DYNAMIC x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`): ``` select version();...

ringora

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ``` Linux 6.8.0-49-generic 22.04.1-Ubuntu SMP PREEMPT_DYNAMIC x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`): ``` select version();...

ringora

**Describe the bug** **Environment** - OS Version and CPU Arch(`uname -a`): ``` Linux 6.8.0-49-generic 22.04.1-Ubuntu SMP PREEMPT_DYNAMIC x86_64 x86_64 x86_64 GNU/Linux ``` - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`): ```sql select version();...

fenfeng9

[Bug]: 动态内存一致性检测，observer可以启动，但无法连接，并且/data目录下没有日志 || [Bug]: Dynamic memory consistency detection, the observer can be started, but cannot be connected, and there are no logs in the /data directory

8

**Describe the bug** 我们使用对二进制文件插桩的方式，对ob进行动态内存一致性检测，当我们使用工具启动observer后，会报ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.0.214' (115) 这个错误，看起来是observer未正常启动。 我们首先使用obd start集群，然后kill掉observer，然后使用工具启动observer的方式来进行内存一致性检测， **Environment** - OS Version and CPU Arch(`uname -a`): - OB Version(`LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V`):...

yujiabin123

[Question]: 有计划推出Windows版本的吗？ || [Question]: Are there any plans to launch a Windows version?

2

背景是一名学生想用ob来写毕设 之前也提问过docker部署的方式，但是感觉还是不太方便。 --- The background is that a student wants to use ob to write a graduation project I have asked about the docker deployment method before, but it still...

xingjunfeng