thecodingmachine magic-query issues

thecodingmachine / magic-query

A very clever library to use SQL prepared statement with a variable number of parameters... and much more!

http://mouf-php.com/packages/mouf/magic-query/README.md

22 stars 14 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Add support for UNION ALL and UNION DISTINCT

#89 Zheness closed 9 months ago
0
UNION ALL is not supported

#88 Zheness closed 9 months ago
4
Update deps + test on dbal v3

#87 aszenz closed 5 months ago
1
Adding ORDER support for UNION queries

#86 mhtghn closed 1 year ago
0
Fix join with a subquery

#85 rodion-k opened 2 years ago
1
TIMESTAMPDIFF: Do not escape unit param (test case)

#84 homersimpsons opened 3 years ago
0
TIMESTAMPDIFF function issue

#83 NikitaKharkov opened 3 years ago
2
Expression: Handle null `$subTree`

#82 homersimpsons closed 3 years ago
0
Add conditionsMode and extrapolateParameters to QueryResult

#81 rodion-k opened 3 years ago
2
Fix "FROM" with the specified database

#80 rodion-k opened 3 years ago
0
[FIX] CI - GH Actions

#79 homersimpsons closed 3 years ago
1
CI: Move to GitHub Actions

#78 homersimpsons closed 3 years ago
0
FROM list

#77 homersimpsons opened 3 years ago
0
Issue with comma with multi FROM

#76 ReynaldBarbeaut opened 3 years ago
0
Order By Alias: Adding failing test case

#75 homersimpsons opened 3 years ago
0
Left/Right join with a subquery doesn't work

#74 Arnex93 opened 3 years ago
0
Wrong parenthesis order with CASE

#73 Zheness closed 4 years ago
1
Subquery aliases in Oracle don't accept the AS keyword

#72 moufmouf closed 4 years ago
1
In Oracle, table aliases cannot contain the AS keyword

#71 moufmouf closed 4 years ago
1
Prepare Statement Cache issue

#70 homersimpsons closed 4 years ago
2
Fixing an issue if there is no alias in subquery

#69 moufmouf closed 4 years ago
1
Fix ORA-00920: Operator is required in WHERE clause on Oracle

#68 homersimpsons closed 4 years ago
1
Fix bracket expression position

#67 homersimpsons closed 4 years ago
1
sql hints

#66 homersimpsons closed 4 years ago
1
NOT LIKE: implement it

#65 homersimpsons closed 4 years ago
1
Migrating to Twig 3

#64 moufmouf closed 4 years ago
1
Porting alias fix (PHP 7.4 compatiblity) to 1.4 branch

#63 moufmouf closed 4 years ago
1
Fixing alias issue (PHP 7.4 compatibility)

#62 moufmouf closed 4 years ago
1
Wrong parenthesis when parsing custom ORDER BY

#61 Zheness closed 4 years ago
0
Porting NOT IN fix to 1.4

#60 moufmouf closed 5 years ago
1
NOT IN parameters are not adding parenthesis automatically

#59 moufmouf closed 5 years ago
1
Bug with NOT IN condition (missing parenthesis)

#58 Zheness closed 5 years ago
1
Allowing to set to null the SQL dialect

#57 moufmouf closed 5 years ago
1
Adding an option to choose the SQL dialect generated

#56 moufmouf closed 5 years ago
1
Add the ability to output in a chosen dialect

#55 moufmouf closed 5 years ago
1
unknown [expr_type] = in-list in "expression subtree" [4]

#54 Arnex93 closed 5 years ago
1
Fixing Travis by adding explicit MySQL requirement

#53 moufmouf closed 5 years ago
1
Fixing issue with alias and having

#52 moufmouf closed 5 years ago
0
HAVING clause disappears in some very special cases

#51 moufmouf closed 5 years ago
1
Case statement in where condition is removed by magic parameters

#50 moufmouf closed 5 years ago
1
edited the way duplicated foreignKey are detected

#49 Kharhamel closed 5 years ago
1
Improving IN expression handling

#48 moufmouf closed 5 years ago
1
Issue with between and parenthesis

#47 TheoBiron closed 5 years ago
1
Request with cartesian product fails

#46 TheoBiron closed 5 years ago
2
Performance improvement fix

#45 moufmouf closed 5 years ago
3
Improving performance

#44 moufmouf closed 5 years ago
2
Fix logic for parsing MATCH AGAINST statements

#43 Denis74RUS closed 5 years ago
2
Subqueries can be union queries

#42 moufmouf closed 7 years ago
1
Adding support for UNION queries

#41 moufmouf closed 7 years ago
5
Fixing SQL generation of aggregate functions with multiple parameters

#40 moufmouf closed 7 years ago
4