Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / thecodingmachine/magic-query issues and pull requests

#89 - Add support for UNION ALL and UNION DISTINCT

Pull Request - State: closed - Opened by Zheness 7 months ago

#88 - UNION ALL is not supported

Issue - State: closed - Opened by Zheness 7 months ago - 4 comments

#87 - Update deps + test on dbal v3

Pull Request - State: closed - Opened by aszenz 8 months ago - 1 comment

#86 - Adding ORDER support for UNION queries

Pull Request - State: closed - Opened by mhtghn over 1 year ago

#85 - Fix join with a subquery

Pull Request - State: open - Opened by rodion-k over 2 years ago - 1 comment

#84 - TIMESTAMPDIFF: Do not escape unit param (test case)

Pull Request - State: open - Opened by homersimpsons almost 3 years ago

#83 - TIMESTAMPDIFF function issue

Issue - State: open - Opened by NikitaKharkov almost 3 years ago - 2 comments

#82 - Expression: Handle null `$subTree`

Pull Request - State: closed - Opened by homersimpsons about 3 years ago

#81 - Add conditionsMode and extrapolateParameters to QueryResult

Pull Request - State: open - Opened by rodion-k about 3 years ago - 2 comments

#80 - Fix "FROM" with the specified database

Pull Request - State: open - Opened by rodion-k about 3 years ago

#79 - [FIX] CI - GH Actions

Pull Request - State: closed - Opened by homersimpsons over 3 years ago - 1 comment

#78 - CI: Move to GitHub Actions

Pull Request - State: closed - Opened by homersimpsons over 3 years ago

#77 - FROM list

Pull Request - State: open - Opened by homersimpsons over 3 years ago

#76 - Issue with comma with multi FROM

Issue - State: open - Opened by ReynaldBarbeaut over 3 years ago

#75 - Order By Alias: Adding failing test case

Pull Request - State: open - Opened by homersimpsons over 3 years ago

#74 - Left/Right join with a subquery doesn't work

Issue - State: open - Opened by Arnex93 over 3 years ago

#73 - Wrong parenthesis order with CASE

Issue - State: closed - Opened by Zheness about 4 years ago - 1 comment

#72 - Subquery aliases in Oracle don't accept the AS keyword

Pull Request - State: closed - Opened by moufmouf about 4 years ago - 1 comment

#71 - In Oracle, table aliases cannot contain the AS keyword

Pull Request - State: closed - Opened by moufmouf about 4 years ago - 1 comment

#70 - Prepare Statement Cache issue

Pull Request - State: closed - Opened by homersimpsons about 4 years ago - 2 comments

#69 - Fixing an issue if there is no alias in subquery

Pull Request - State: closed - Opened by moufmouf about 4 years ago - 1 comment

#68 - Fix ORA-00920: Operator is required in WHERE clause on Oracle

Pull Request - State: closed - Opened by homersimpsons about 4 years ago - 1 comment

#67 - Fix bracket expression position

Pull Request - State: closed - Opened by homersimpsons over 4 years ago - 1 comment

#66 - sql hints

Pull Request - State: closed - Opened by homersimpsons over 4 years ago - 1 comment

#65 - NOT LIKE: implement it

Pull Request - State: closed - Opened by homersimpsons over 4 years ago - 1 comment

#64 - Migrating to Twig 3

Pull Request - State: closed - Opened by moufmouf almost 5 years ago - 1 comment

#63 - Porting alias fix (PHP 7.4 compatiblity) to 1.4 branch

Pull Request - State: closed - Opened by moufmouf almost 5 years ago - 1 comment

#62 - Fixing alias issue (PHP 7.4 compatibility)

Pull Request - State: closed - Opened by moufmouf almost 5 years ago - 1 comment

#61 - Wrong parenthesis when parsing custom ORDER BY

Issue - State: closed - Opened by Zheness almost 5 years ago

#60 - Porting NOT IN fix to 1.4

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#59 - NOT IN parameters are not adding parenthesis automatically

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#58 - Bug with NOT IN condition (missing parenthesis)

Issue - State: closed - Opened by Zheness about 5 years ago - 1 comment

#57 - Allowing to set to null the SQL dialect

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#56 - Adding an option to choose the SQL dialect generated

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#55 - Add the ability to output in a chosen dialect

Issue - State: closed - Opened by moufmouf about 5 years ago - 1 comment
Labels: enhancement

#54 - unknown [expr_type] = in-list in "expression subtree" [4]

Issue - State: closed - Opened by Arnex93 about 5 years ago - 1 comment

#53 - Fixing Travis by adding explicit MySQL requirement

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#52 - Fixing issue with alias and having

Pull Request - State: closed - Opened by moufmouf about 5 years ago

#51 - HAVING clause disappears in some very special cases

Issue - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#50 - Case statement in where condition is removed by magic parameters

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#49 - edited the way duplicated foreignKey are detected

Pull Request - State: closed - Opened by Kharhamel about 5 years ago - 1 comment

#48 - Improving IN expression handling

Pull Request - State: closed - Opened by moufmouf about 5 years ago - 1 comment

#47 - Issue with between and parenthesis

Pull Request - State: closed - Opened by TheoBiron over 5 years ago - 1 comment

#46 - Request with cartesian product fails

Pull Request - State: closed - Opened by TheoBiron over 5 years ago - 2 comments

#45 - Performance improvement fix

Pull Request - State: closed - Opened by moufmouf over 5 years ago - 3 comments

#44 - Improving performance

Pull Request - State: closed - Opened by moufmouf over 5 years ago - 2 comments

#43 - Fix logic for parsing MATCH AGAINST statements

Pull Request - State: closed - Opened by Denis74RUS over 5 years ago - 2 comments

#42 - Subqueries can be union queries

Pull Request - State: closed - Opened by moufmouf almost 7 years ago - 1 comment

#41 - Adding support for UNION queries

Pull Request - State: closed - Opened by moufmouf almost 7 years ago - 5 comments

#40 - Fixing SQL generation of aggregate functions with multiple parameters

Pull Request - State: closed - Opened by moufmouf almost 7 years ago - 4 comments

#39 - Adding Twig 2 compatibility

Pull Request - State: closed - Opened by moufmouf about 7 years ago - 7 comments

#38 - Fixing quoting problem in Oracle

Pull Request - State: closed - Opened by moufmouf about 7 years ago - 1 comment

#37 - Fix : order by aggregate function

Pull Request - State: closed - Opened by dsavina over 7 years ago - 3 comments

#36 - Fixing IN list

Pull Request - State: closed - Opened by gulien over 7 years ago - 3 comments

#35 - Switching from exceptions to warnings if an unexpected key is found in parser

Pull Request - State: closed - Opened by moufmouf about 8 years ago - 1 comment

#34 - Fixing greater or equal bug

Pull Request - State: closed - Opened by moufmouf about 8 years ago - 1 comment

#33 - Fixing DISTINCT management

Pull Request - State: closed - Opened by moufmouf about 8 years ago - 1 comment

#32 - Fixing bug with magic parameters and expression with parenthesis

Pull Request - State: closed - Opened by moufmouf about 8 years ago - 1 comment

#31 - Fixes order by with multiple colums (backport from 1.1)

Pull Request - State: closed - Opened by dalibert42 about 8 years ago - 1 comment

#30 - Fixes order by with multiple colums

Pull Request - State: closed - Opened by dalibert42 about 8 years ago - 1 comment

#29 - Removing bundled PHPSQLParser

Pull Request - State: closed - Opened by moufmouf over 8 years ago - 2 comments

#28 - Magic Query Row error/exception on certain queries

Issue - State: closed - Opened by dalibert42 over 8 years ago - 3 comments

#27 - Fixing const detection in columns

Pull Request - State: closed - Opened by moufmouf over 8 years ago - 1 comment

#26 - Fix two parameters

Pull Request - State: closed - Opened by cbalda over 8 years ago - 1 comment

#25 - fix Or Operand detection in MagicJoin

Pull Request - State: closed - Opened by cbalda over 8 years ago - 1 comment

#24 - Fix empty array or null parameter in IN operand

Pull Request - State: closed - Opened by cbalda over 8 years ago - 1 comment

#23 - Transforms automatically '= null' into 'IS NULL'.

Pull Request - State: closed - Opened by moufmouf over 8 years ago - 1 comment

#22 - Adding support for CASE WHEN... constructs

Pull Request - State: closed - Opened by moufmouf over 8 years ago

#21 - CASE WHEN seems not working

Issue - State: closed - Opened by gulien over 8 years ago

#20 - Fixes problem in MagicJoin when some kind of branching join did happen

Pull Request - State: closed - Opened by moufmouf almost 9 years ago

#19 - Magic Query with branches in joins might not work.

Issue - State: closed - Opened by moufmouf almost 9 years ago

#16 - ORDER BY with params doesn't work

Issue - State: closed - Opened by dmaechler almost 9 years ago - 2 comments

#14 - Fixing simple function case in the sql parsing

Pull Request - State: closed - Opened by dmaechler almost 9 years ago

#13 - Adding support for BETWEEN filter. Fixes #11

Pull Request - State: closed - Opened by moufmouf almost 9 years ago

#12 - Operation class should implement abtract method getOperatorSymbol()

Issue - State: closed - Opened by nguyenk almost 9 years ago - 1 comment

#11 - Add support for between operator

Issue - State: closed - Opened by nguyenk almost 9 years ago

#10 - Add doc about magic joins and forced paths

Issue - State: closed - Opened by nguyenk almost 9 years ago - 1 comment

#8 - Fixing generation of SchemaAnalyzer from db connection

Pull Request - State: closed - Opened by moufmouf almost 9 years ago

#7 - Adding documentation regarding path ambiguities

Pull Request - State: closed - Opened by moufmouf almost 9 years ago - 1 comment

#6 - Twig integration

Pull Request - State: closed - Opened by moufmouf about 9 years ago - 1 comment

#5 - Add support for Twig in SQL queries

Issue - State: closed - Opened by moufmouf about 9 years ago - 3 comments
Labels: enhancement

#4 - Adding MagicJoin feature!

Pull Request - State: closed - Opened by moufmouf about 9 years ago - 1 comment

#2 - [WIP] Adding a traverser and visitors to scan the SQL tree

Pull Request - State: closed - Opened by moufmouf about 9 years ago - 1 comment

#1 - Fix Parameters with IN condition

Pull Request - State: closed - Opened by rbergDrox about 9 years ago