Closed BrainStormDevel closed 3 years ago
I have problem when using raw method to select. The and inside this query are not evaluated as tables.
Information
Detail Code $db->debug()->select('tablename', [ 'test' => Medoo::raw("CONCATWS('',, DATE_FORMAT(, '%Y-%m-%d'), 'fixedtext')"), ]);
Expected output SELECT CONCATWS('',tablename.column1, DATE_FORMAT(tablename.column2, '%Y-%m-%d'), 'fixedtest') AS test FROM tablename
tablename
column1
column2
test
Fixed it on 73f9220.
I have problem when using raw method to select. The and inside this query are not evaluated as tables.
Information
Detail Code $db->debug()->select('tablename', [ 'test' => Medoo::raw("CONCATWS('',, DATE_FORMAT(, '%Y-%m-%d'), 'fixedtext')"),
]);
Expected output SELECT CONCATWS('',
tablename
.column1
, DATE_FORMAT(tablename
.column2
, '%Y-%m-%d'), 'fixedtest') AStest
FROMtablename