Comments (2)
- 能自行解决的且代码有优化空间的,可提交PR。
- 自行解决不了的,请补充详细信息(包括但不限于代码和表结构)
from think-orm.
先声明,我的环境是:sql server
比如我有2个表:customer,equipment
customer表里面有字段:customer_id(主键),name
equipment表里有字段:equipment_id (主键),equipment_model,customer_id
然后我生成了2个model:CustomerModel、EquipmentModel
在CustomerModel添加了:
function equipments() {
return $this->hasMany(EquipmentModel::class,'customer_id','customer_id');
}
现在我在customer的controller里面使用
$customer_equipments_count= CustomerModel::withCount('equipments')->select();
这个就直接报错了,错误代码:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。
合成的sql语句为:
SELECT T1.* FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT ,(SELECT T1. FROM (SELECT thinkphp., ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS think_count FROM [d_equipment] [count_table] WHERE ( [count_table].[customer_id] =d_customer.customer_id ) ) AS thinkphp) AS T1) AS [equipments_count] FROM [d_customer] WHERE [customer_id] IN (1,2,3) ) AS thinkphp) AS T1
from think-orm.
Related Issues (20)
- 一对多关联字段查询BUG
- 模型自动转驼峰功能异常
- ->find()时hidden/appen/visible 逻辑问题 HOT 8
- withJoin()驼峰bug
- 非原生查询使用参数绑定
- 改一下吧 $a !== $b 不然 01 和 1 判定一样的了 HOT 1
- 一对一关联hasWhere和where同时使用bug HOT 1
- MongoDB下查询中包含数组/对象时自动加 $in 的问题。 HOT 1
- join语法不支持 cross join
- MongoDB如何批量修改
- 不开启字段缓存的情况下,即使模型中设置了schema属性,在新增数据的时候依然会从数据库中获取表字段信息 HOT 1
- find在无条件查询下返回NULL的问题 HOT 4
- 多对多模型中间表pivot提示外键不存在
- 更新数据时,创建时间字段create_time 未自动转换 HOT 4
- 关于使用自定义Collection方法且调用分页功能,列表数据为0时,找不到自定义Collection的扩展方法,从而造成的报错。
- pgsql数据库多schema支持问题
- inc, dec, setInc, setDec 步长应该支持整型、浮点型、字符串类型
- 远程关联执行 不走 模型
- where和hasWhere同时使用会出现的bug HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from think-orm.